Skip to main content
Question

Aggregate data from multiple fields into one

  • January 25, 2023
  • 0 replies
  • 87 views

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
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+22
    • MarkShnierYou
    • Quickbase Alumni
    • January 25, 2023
    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
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement