Forum Discussion

JemmaDicks's avatar
JemmaDicks
Qrew Trainee
5 years ago

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)

  • When you say that your tables are "Related" do you mean that there is a Quickbase relationship between the tables.

    Also can you take a step back and explain the business purpose of what you are trying to do.  It would help us suggest a structure for their tables and their relationships.


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • JemmaDicks's avatar
      JemmaDicks
      Qrew Trainee
      Hi Mark

      Yes there is a QuickBase relationship between the tables. 

      The business purpose is that the value entered into the related tables may be different, but it could be the same. So, I don't want people to have to replicate the data if it's the same. I want them to indicate if the value is the same in both tables, and for the form for the second table to display the value from the first.

      Thanks

      ------------------------------
      Jemma 
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        Can you tell me the name of the two tables and explain which is the Parent and which is the Child?

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------