Forum Discussion

AndrewRyder's avatar
AndrewRyder
Qrew Cadet
6 years ago

Grabbing a field from a separate table to use in formula

Hi, I'm wondering if it is possible to use a field from another table (same app) in a formula? I know how to do this with a lookup field once a table-to-table relationship is established.  I'm c...
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
If I understand the question, the solution here would be to have a table of rates, but they Key field would be a field on the format

Dept-LaborType

so for example

Plumbing-Supervisor
Plumbing-Helper
Roofer-Supervisor
Roofer-helper.

You can have these be two data entry fields but then a formula field to calculate like

List("-", [dept], type])

then a form rule to fill in the key field for the user  

Then you can lookup that down to your proposal table based on the reference field on ghe proposal record being a similar calculation.

Then snapshot that field   https://help.quickbase.com/user-assistance/setting_up_snapshot_fields.html so you can adjust the rates in that lookup and not change historical records.