Summarizing users
I'm wrestling with the lack of an option to use a Summary field to pull together a list of Users as defined on a child table. I'm hoping QB adds this type of summary field in the future. In the mean...
Forum Discussion
OK, not tested but try this.
var text value = ToText([My combined text summary field of Users in text format]);
ToUserList(
ToUser(Trim(Part($value,1,";"))),
ToUser(Trim(Part($value,2,";"))),
ToUser(Trim(Part($value,3,";"))),
Trim(Part($value,4,";")),
etc
ToUser(Trim(Part($value,20,";")))
)
// The ToUserList only allows up to 20 entries.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var text value = ToText([My combined text summary field of Users in text format]);
ToUserList(
ToUser(Trim(Part($value,1,";"))),
ToUser(Trim(Part($value,2,";"))),
ToUser(Trim(Part($value,3,";"))),
Trim(Part($value,4,";")),
etc
ToUser(Trim(Part($value,20,";")))
)
// The ToUserList only allows up to 20 entries.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
This is awesome, thank you so much!! I'll try this next week but looks like it makes intuitive sense. I always forget about Trim.
------------------------------
Brian Richardson (test editor)
------------------------------
------------------------------
Brian Richardson (test editor)
------------------------------
