Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
5 years ago

Summary Field showing only unique entries

I have a parent summary table, it's children are Daily Reports. Each report is associated with a site. There may be mulitple daily reports at once site.

I want to show a summary field of the list of sites visited on that day. It looks like I can get a distinct count of the Site field, but I am unclear if I can get a list (combined text?) of the unique sites. Is this possible?

------------------------------
Mike Tamoush
------------------------------
Formulas and functions
Relationships
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    That is exactly how a combined text field works. It rolls up the UNIQUE values of all child values in a field.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • MichaelTamoush's avatar
      MichaelTamoush
      Qrew Captain
      5 years ago
      LOL. I didn't event try. I thought the combined text just listed all entries in a string. Well, that solves that.

      ------------------------------
      Mike Tamoush
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        If you don't like the pill appearance, you can show them, vertically for example with this formula

        SearchAndReplace([my combined text summary field], " ; ", "\n")


        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------