I have a work
table that has hours
worked. I’d like to include the settings.rate
(one row that contains a money value) field as a repeating column. I’d also like to create a formula that is work.hours * settings.rate
in the work
table.
I tried linking the work
table to the settings.rate
table, but nothing is displayed in the column.
Is this possible?
1 Like
One way I do it is this. I create a Settings
table, with a rate
column and a single row. In the Hours
table, I add a formula column, named settings
, with the formula
Settings.lookupOne()
i.e. literally a lookup with no parameters – it simply returns the first row. I convert it to a Reference column and hide it.
Now in all other formulas in the Hours
table, I’ll be able to use $settings.rate
.
Any other global values that I add to the Settings
table could then be accessed similarly without repeating any other steps.
1 Like