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?
- If you make a formula numeric field with a formula of 1 it will calculate to a 1
- I do not understant what you mean saying a formula of 1 �?
- Make field of type formula numeric.
put a 1 in the formula box as a formula.
Not surprisingly, it will always calculate the result to be 1.
The point is that the settings table has a record ID# of 1 in its one and only record.so to match up with that your child table, the child table also needs to have a 1 in it to make the relationship lookup the correct record from the settings table. - I see, clever idea, so that way you do not need select in table 2 anything and it all will be automatic. I understand. I will try later today. Thanks very much for your support.
- Yes! you get it! Great.
