User Summary Field
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 chil...
Forum Discussion
Mark, thank you. Since I have 4 child tables related to the parent, and each of those child tables have a list-user field, i assume I would replication this process for each child table. I did that and now I have 4 summary fields on the parent table. Would I combine those summary fields using a list function in a rich text field? And would your code then work on the combined list?
------------------------------
MICHAEL SARGENT
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendI think this will work.
var text value = List(" ; ",
ToText([Combined Text User in text format 1 ]),
ToText([Combined Text User in text format 2]),
ToText([Combined Text User in text format 3]),
ToText([Combined Text User in text format] 4));
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,";"))))
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------