Forum Discussion

ReneeHansen's avatar
ReneeHansen
Qrew Member
2 years ago

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 ...
ReneeHansen's avatar
ReneeHansen
Qrew Member
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
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
2 years ago
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
------------------------------
  • ReneeHansen's avatar
    ReneeHansen
    Qrew Member
    2 years ago

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