Skip to main content
Question

Summary of a User Field

  • June 10, 2020
  • 0 replies
  • 145 views
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • June 10, 2020
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
------------------------------
Mark Shnier. Your Quickbase Coach
Forum|alt.badge.img+1

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
------------------------------
Terms & ConditionsAccessibility statement