Forum Discussion

CarolMcconnell's avatar
CarolMcconnell
Qrew Captain
3 months ago

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...
  • MarkShnier__You's avatar
    MarkShnier__You
    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.