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 LegendOK, 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
------------------------------
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
------------------------------
Yes, both have related records for parent/child and you're right, there is a one to many relationship from Dataset to Report.
------------------------------
Jemma
------------------------------
------------------------------
Jemma
------------------------------
- MarkShnier__YouOK, so you are saying that there is a relationship and indeed the parents are connected to the children.
Did you go to the relationship and create a lookup field for the Range Covered field to get that down to the child records?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- I'm guessing i've done it wrong by trying to pull the value through via a formula!
I don't know how to create lookup fields yet, I really don't know how to use QuickBase...
------------------------------
Jemma
------------------------------ - Don't worry, i've figured it out. I went to the relationship between the tables, and added the 'date range covered' field as a lookup value. Then I updated my formula to show this field if the checkbox was checked.
It only took me a day! :-P
------------------------------
Jemma
------------------------------- MarkShnier__YouOk, glad to hear you are now an expert on Relationships. Now just 999 other easy things to learn.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------