Skip to main content
Question

User Summary Field

  • Feb 15, 2024 7:49 PM UTC
  • 0 replies
  • 176 views

I have an application in which there is an intake (Parent) table which can then be assigned to different users across multiple (Child) workflow tables.  Since there is a user assignment for each child record, how can i possibly summarize the users across the multiple child records and display it on the parent record?



------------------------------
MICHAEL SARGENT
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24

np,

If you make a field on the child table called [User in text format] with a formula of

ToText([myUser Field])

You can make a combined text summary field on the text field to roll up those words to the Parent.

Then you can covert those back to being a formula List User field field type on the Parent which can be good for say Notifications to all the "Project Team members".

var text value = ToText([Combined Text User in text format]);


ToUserList(
ToUser(Trim(Part($value,1,";"))),
ToUser(Trim(Part($value,2,";"))),
ToUser(Trim(Part($value,3,";"))),
ToUser(Trim(Part($value,4,";"))),
ToUser(Trim(Part($value,5,";"))),
ToUser(Trim(Part($value,6,";"))),
ToUser(Trim(Part($value,7,";"))),
ToUser(Trim(Part($value,8,";"))),
ToUser(Trim(Part($value,9,";"))),
ToUser(Trim(Part($value,10,";"))),
ToUser(Trim(Part($value,11,";"))),
ToUser(Trim(Part($value,12,";"))),
ToUser(Trim(Part($value,13,";"))),
ToUser(Trim(Part($value,14,";"))),
ToUser(Trim(Part($value,15,";"))),
ToUser(Trim(Part($value,16,";"))),
ToUser(Trim(Part($value,17,";"))),
ToUser(Trim(Part($value,18,";"))),
ToUser(Trim(Part($value,19,";"))),
ToUser(Trim(Part($value,20,";"))))

If you then wanted to have a dynamic filter on the parent table to filter from a drop-down of individual project team members then you could use this formula multi select field  

Field type Formula Multi Select Text

Split(ToText([Combined Text User in text format])

He wanted to have a nice vertical list of the project team members up on the parent table I think this would work as a formula text field.  

var text value = ToText([Combined Text User in text format]);


List("\n",
UserToName(ToUser(Trim(Part($value,1,";")))),
UserToName(ToUser(Trim(Part($value,2,";")))),
UserToName(ToUser(Trim(Part($value,3,";")))),
etc

UserToName(ToUser(Trim(Part($value,20,";")))))



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------