CarolMcconnell
3 months agoQrew Captain
Get data from an unrelated table
I have a QuickBase and I have three tables involved. DSO TINS Contacts The Tins and the contacts table are related to the DSO table using the Field DSO name. What I need to do is pull in some...
- 3 months ago
OK, np,
Create a field called [Contact for Rollup] on the Contracts table which combines the fields you want to retrieve. For example
List(" ", [Name],[ Email],Phone])
Use a Combined Text Summary field on the relationship between DSO and Contacts to roll these up to the Parent DSO. Accept the suggested name for the field. Filter on Primary.
Make a formula field on the DSO
SearchAndReplace(ToText(Combined Text Contact for Roll up])," ; ", " \n")
Look that field up down to TINS.