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.
Thank you for your response. You mean doing it with or without creating parent-child relation. I would like to do it avoiding this relation if possible. How do I create a formula numeric that refers to a field value of another table? and automatically get that value?