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 ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendyou 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
------------------------------
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
------------------------------
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
------------------------------
------------------------------
Renee Hansen
------------------------------
- MarkShnier__YouIn 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
------------------------------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
------------------------------