Discussions

 View Only
  • 1.  Summary Field showing only unique entries

    Posted 06-15-2020 18:04
    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
    ------------------------------


  • 2.  RE: Summary Field showing only unique entries

    Posted 06-15-2020 18:11
    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
    ------------------------------



  • 3.  RE: Summary Field showing only unique entries

    Posted 06-15-2020 18:17
    LOL. I didn't event try. I thought the combined text just listed all entries in a string. Well, that solves that.

    ------------------------------
    Mike Tamoush
    ------------------------------



  • 4.  RE: Summary Field showing only unique entries

    Posted 06-15-2020 18:36
    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
    ------------------------------