Discussions

Expand all | Collapse all

Summary of a User Field

  • 1.  Summary of a User Field

    Posted 06-10-2020 15:59
    Hi everyone!

    I need to create a summary field in my parent table that summarizes a User field in the child table. Is this possible? Seems like I'll be able to do what I need when the new formulas come out later this year, but just wondering if I can do this now.

    Thanks!

    ------------------------------
    Nathan Allan
    ------------------------------


  • 2.  RE: Summary of a User Field

    Posted 06-10-2020 16:01
    Do you mean a combined text summary field and then non the parent turn this into a userlist field type?

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



  • 3.  RE: Summary of a User Field

    Posted 06-10-2020 16:06
    I think that would work. I tried a combined text summary field, but it says that function can't be applied to my User field in the child table.

    ------------------------------
    Nathan Allan
    ------------------------------



  • 4.  RE: Summary of a User Field

    Posted 06-10-2020 16:17
    ... I will post back later when i get a chance.

    Mark Shnier
    'Your Quick Base Coach







  • 5.  RE: Summary of a User Field

    Posted 03-25-2021 16:43

    I'm guessing you figured this out since this was from so long ago, but in case anyone else runs into this thread I'll throw this out there:

    I haven't done this with a list of multiple users, but I have worked around this issue when creating a summary field that returns only one user - here is how I've done it:

    1. On the child table, create a formula field that converts the user field you care about to text, e.g. ToText([User])
    2. Create the combined text summary field on that new text field
    3. On the parent table, create a formula field that converts the summary field from a text list to text, then from text to user, e.g. ToUser(ToText([User Summary Field]))

    This method may be able to be tweaked to use for a user list, but I'm not sure exactly how it would differ in that case.



    ------------------------------
    Hannah Jacobson
    ------------------------------