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
------------------------------
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
------------------------------- MarkShnier__YouOK, so I think that you are saying that One Dataset has many Reports. That is how we talk about Relationships in Quickbase.
If you look at a dataset record, do you have an embedded child table there for Reports?
Conversely, if you look at any Reports record is the field for Related Dataset populated? ie, just because you make a relationship, the parents and children don't automatically know how to attach to each other, unless they are done by manual data entry or if the child record has a formula to calculate the key field of the parent.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------