Forum Discussion

Qrew Captain

4 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...

Relationships

MarkShnier__You
4 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.

MarkShnier__You

Qrew Legend

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.

CarolMcconnell

Qrew Captain

3 months ago

Okay, this worked, now how do I pull out only the email address. I would assume that this formula would need to change? SearchAndReplace(ToText(Combined Text Contact for Roll up])," ; ", " \n"). Right now it pulls in the Name,email and phone and I only want email.

MarkShnier__You
Qrew Legend
3 months ago
Well one way is to make a new Formula Text field on the child called [Email for Rollup] with the formula of just [my email field] and roll it up to the Parent.
- CarolMcconnell
  Qrew Captain
  3 months ago
  Yep, I figured that one out. I wasn't thinking. I am having one issue with the formula though. It's bring back the email and then (1. How do I get rid of the (1
  - CarolMcconnell
    Qrew Captain
    3 months ago
    I guess I should state what that (1 is. It's a check box field that I need to pull in because I only want to see the ones where that check box is check. So the question is, how do I update this formula SearchAndReplace(ToText(Combined Text Contact for Roll up])," ; ", " \n"). to only give me the email address and not the checkbox.