App Script Constants!

What's New


We've enhanced the performance of application scripts (app scripts) to help them load and execute faster.

We've also introduced a new feature, App Script Constants, to help make app scripts more robust.

App Script Constants is an enhancement to our powerful scripting feature. App scripts commonly include the names of tables, fields or relationships. However, sometimes the script becomes problematic when the name of a referenced table, field or relationship is inadvertently changed; the script no longer recognizes the new name and breaks, causing some automation to grind to a halt. 

Each table, field and relationship in TrackVia has a unique numeric identifier (ID) that never changes.  This data has been hidden in the past and used behind the scenes when building an application and resources.  The new capability in this release exposes this internal system ID for each table, field and relationship. With the newly-exposed data, the person writing the script can define a variable and set it equal to the unique ID - the constant - for the table, field or relationship. When the script executes, it will use the constant ID. If field, relationship or table name is changed, the script will still execute correctly.

To see the IDs, go to the Application Scripts page in the Table Editor. Click the arrow on the right of the screen to open the slide-out drawer. You will see all your applications listed in alphabetical order with your current application expanded to show its tables. You can expand each table to show its fields and relationships. Beside each is the system ID in parentheses. For example, in the below screenshot, the application “DD cars, Sales” has an application ID of 11, the table “Inventory” has ID 55 and the “Car ID” field has ID 608. Click the clipboard beside an ID to copy the constant declaration to your clipboard. Paste the declaration into the script editor and away you go!





Product Release Notes

  1. Dashboard Tabs
  2. July 2020 Web Maintenance
  3. iOS Mobile App v5.1: Dashboards and Dates
  4. Android Mobile App v3.1: General Maintenance
  5. June 2020 Platform Maintenance
  6. TrackVia Mobile - Dashboards Reimagined!
  7. TrackVia's New Look
  8. Update to Flows - New Exit Button And More!
  9. Advanced Link to Parent
  10. New and Improved Lanes View!
  11. Introducing Backup and Restore!
  12. View Filters + Web Maintenance
  13. Android Mobile App v2.24.1: Resolved Workflow Decision Conflict
  14. February 2020 Web Maintenance
  15. iOS Mobile App v4.5: Voice Memo, Barcodes, Manual Sort, and Charts
  16. iOS Mobile App v4.4.2: Resolve Unintentional Logouts from the App
  17. Web Maintenance January 2020
  18. Web v20.10: New Permission & Enhancements to Bulk Select
  19. Android Mobile App v2.23: Side by Side Multi-Select and Maintenance
  20. December 2019 Web Maintenance
  21. Microservices Update
  22. iOS Mobile App v4.4.1: Login to Sandbox Environment
  23. iOS Mobile App v4.4: Locations, Directions, and Maintenance
  24. October 2019 Web Maintenance
  25. iOS Mobile App v4.3.1: Logout Issue Resolved
  26. October 2019 Platform Maintenance
  27. Introducing Pivot Views!
  28. Android Mobile App v2.21.7: Maintenance Release
  29. iOS Mobile App v4.3: Sync Center Enhancements and Maintenance Release
  30. September 2019 Platform Maintenance
  31. September 2019 Web Maintenance
  32. iOS Mobile App v4.2 Maintenance Release
  33. August 2019 Platform Maintenance
  34. Android Mobile App v2.21.6: Maintenance Release
  35. Introducing TrackVia Integrations!
  36. Android Mobile App v2.21.5: Maintenance Release
  37. August 2019 Release Notes: Web Maintenance
  38. iOS Mobile App v4.1: Updates to Grid Views, Multi Select Widgets and Date/Time Stamps
  39. June 2019 Maintenance
  40. New in Mobile: iOS v4.0 - Simplified Offline Data Sync
  41. iOS Mobile App v4.0: Release Notes
  42. May 2019 Release Notes: Web Maintenance 2
  43. May 2019 Release Note: Web Maintenance
  44. App Script Constants!
  45. April 2019 Release Notes: API Maintenance
  46. Entity Relationship Diagram Improvements
  47. Improved Lanes View!
  48. December 2018 Release Notes: Web Maintenance
  49. Custom Mail Settings!
  50. November 2018 Release Notes: Platform Maintenance
  51. October 2018 Release Notes: Maintenance
  52. Improved User Management
  53. Views & Quick Filter Updates
  54. July 2018 Release Notes: Maintenance
  55. June 13, 2018 Release Notes: Maintenance
  56. May 25, 2018 Release Notes: Sandbox Environments
  57. May 2018 Release Notes: Deprecating TLS 1.0 & 1.1
  58. April 23rd Release Notes: Maintenance
  59. April 18th Release Notes: Maintenance
  60. April 10th Release Notes: Maintenance
  61. March 2018 Release Notes: Maintenance
  62. February 2018 Release Notes: More Intelligent Saving & Other Notes
  63. January 2018 Release Notes: Maintenance
  64. December 2017 Release Notes: Offline Editing on Android
  65. November 2017 Release Notes: Timeline | Calendar and Conditional Formatting
  66. September 2017 Release Notes: Maintenance
  67. August 2017 Release Notes: Maintenance
  68. July 2017 Release Notes: Maintenance
  69. June 27, 2017: TrackVia Introduces Flows!
  70. May 22, 2017: TrackVia Apple Watch App
  71. May 2017 Release Notes
  72. May 5, 2017: Better Connectivity Handling
  73. April 2017 Release Notes
  74. March 2017 Release Notes
  75. March 27, 2017: Single Sign On
  76. February 23, 2017: Winter Polish
  77. February 2017 Release Notes: Session Timeouts
  78. January 2017 Release Notes: Number Display Options & Min / Max

Feedback and Knowledge Base