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. App Script Constants!
  2. Entity Relationship Diagram Improvements
  3. Improved Lanes View!
  4. December 2018 Release Notes: Web Maintenance
  5. Custom Mail Settings!
  6. November 2018 Release Notes: Platform Maintenance
  7. October 2018 Release Notes: Maintenance
  8. Improved User Management
  9. Views & Quick Filter Updates
  10. July 2018 Release Notes: Maintenance
  11. June 13, 2018 Release Notes: Maintenance
  12. May 25, 2018 Release Notes: Sandbox Environments
  13. May 2018 Release Notes: Deprecating TLS 1.0 & 1.1
  14. April 23rd Release Notes: Maintenance
  15. April 18th Release Notes: Maintenance
  16. April 10th Release Notes: Maintenance
  17. March 2018 Release Notes: Maintenance
  18. February 2018 Release Notes: More Intelligent Saving & Other Notes
  19. January 2018 Release Notes: Maintenance
  20. December 2017 Release Notes: Offline Editing on Android
  21. November 2017 Release Notes: Timeline | Calendar and Conditional Formatting
  22. September 2017 Release Notes: Maintenance
  23. August 2017 Release Notes: Maintenance
  24. July 2017 Release Notes: Maintenance
  25. June 27, 2017: TrackVia Introduces Flows!
  26. May 22, 2017: TrackVia Apple Watch App
  27. May 2017 Release Notes
  28. May 5, 2017: Better Connectivity Handling
  29. April 2017 Release Notes
  30. March 2017 Release Notes
  31. March 27, 2017: Single Sign On
  32. February 23, 2017: Winter Polish
  33. February 2017 Release Notes: Session Timeouts
  34. January 2017 Release Notes: Number Display Options & Min / Max
  35. December 2016 Release Notes
  36. November 2016 Release Notes
  37. October 2016 Release Notes
  38. September 2016 Release Notes
  39. August 2016 Release Notes
  40. July 2016 Release Notes
  41. June 2016 Release Notes
  42. May 2016 Release Notes
  43. April 2016 Release Notes
  44. March 2016 Release Notes
  45. February 2016 Release Notes
  46. January 2016 Release Notes
  47. December 2015 Release Notes
  48. November 2015 Release Notes
  49. October 2015 Release Notes
  50. September 2015 Release Notes
  51. August 2015 Release Notes
  52. July 2015 Release Notes
  53. June 2015 Release Notes

Feedback and Knowledge Base