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 ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendWhen 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
------------------------------
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
------------------------------
- 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__YouCan 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
------------------------------- Sure Mark
The parent table is called 'Dataset' and the child is called 'Report'
The text field in Dataset is called 'Range Covered'
In Report (relates to a report connected to the Dataset using Power BI) there is the same question. I have a checkbox next to the question which says 'Same as Dataset'.
I have managed to get the question to disappear in the Report Table when this checkbox is selected, but I can't get the value from the Dataset table to pull through.
------------------------------
Jemma
------------------------------
