Application variables
Is it possible to create a table where defined application variables could be updated? How fields of this table could be defined to call the application variable
Forum Discussion
Not natively. But you can create a table called Settings with 1 record in it. It will be Record ID number 1.
Then in any tables where you need values from that single record., you can create a formula numeric field with a formula of 1 and relate that table to the the Settings table and look up values
Set access permissions for the Settings table to the appropriate Roles.
Then in any tables where you need values from that single record., you can create a formula numeric field with a formula of 1 and relate that table to the the Settings table and look up values
Set access permissions for the Settings table to the appropriate Roles.
If you make a formula numeric field with a formula of 1 it will calculate to a 1