Forum Discussion
QuickBaseCoachD
Qrew Captain
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.
QuickBaseCoachD
8 years agoQrew Captain
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.
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.