Formula syntax to reference a related table
Hi there,
I will preface this post with the fact I'm very new to QuickBase. Day 2, in fact.
I have two related tables. In table 1 I have a text field called 'Range covered'
In table 2 I have a similar question, and checkbox which says 'Same as table 1'
So if the value of 'Range covered' is the same as in table 1, they don't need to re-enter it and the information from 'table 1' is displayed.
If they don't check the box, they get the opportunity to enter different information in a field called 'New range covered'
So, I created a field in Table 2 and made it a Formula Text field.
My formula so far is
IF([Same as table 1]=FALSE, [????],[New range covered]
My issue is, the [????] is the field from table 1 called 'Range covered'. I don't know how to reference it. Please tell me the correct syntax?
Jemma (noob)