Thanks Mark! I went with that assumption and it worked great,
Here's what I did for anyone wondering:
This was helpful to add the "NONE" option because sometimes a Unit name is not available.
If(
[Distinct Count UNIT NAME - UNIT TABLE] > 0, [UNIT NAME - UNIT TABLE],
[Distinct Count UNIT NAME - WELLS TABLE] > 0, [UNIT NAME - WELLS TABLE],
[Distinct Count QRA - CALC TABLE] > 0, [UNIT NAME - CALC TABLE],
[Distinct Count UNIT NAME - UNIT TABLE] < 1, "NONE",
[Distinct Count UNIT NAME - WELLS TABLE] < 1, "NONE",
[Distinct Count QRA - CALC TABLE] < 1, "NONE")
------------------------------
Renee Hansen
------------------------------
Original Message:
Sent: 01-25-2023 18:48
From: Mark Shnier (Your Quickbase Coach)
Subject: Aggregate data from multiple fields into one
In answering this question I am assuming that you have three look up fields for the same field coming from three different possible parent records. So these fields, I assume, are going to have have similar but different names. If these fields were text fields are not numeric fields then the formula would be this.
if(
[Units - QRA#] <> "", [Units - QRA#],
[Wells - QRA#] <> "", [Wells - QRA#],
[Calculations - QRA#] <>"", [Calculations - QRA#])
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 01-25-2023 16:11
From: Renee Hansen
Subject: Aggregate data from multiple fields into one
Thanks Mark! Do I need to have a count so the formula works? and then would those be numeric formulas? and what if there is a txt field
------------------------------
Renee Hansen
Original Message:
Sent: 01-25-2023 12:34
From: Mark Shnier (Your Quickbase Coach)
Subject: Aggregate data from multiple fields into one
you can make a formula field called QRA#
if(
[Units - QRA#] > 0, [Units - QRA#],
[Wells - QRA#] > 0, [Wells - QRA#],
[Calculations - QRA#] > 0, [Calculations - QRA#])
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 01-25-2023 12:22
From: Renee Hansen
Subject: Aggregate data from multiple fields into one
Hi!
I have a notes table setup where a user can add a note from different tables and relate it to that record, but since it's pulling from multiple different relationships
(EX: QRA# is coming from the Units table, the Wells table, or the Calculations table, I want a field that will pull that QRA# into one field, instead of it being in one of the others.
Does that make sense?
------------------------------
Renee Hansen
------------------------------