Forum Discussion

JennasonQuick_B's avatar
JennasonQuick_B
Qrew Trainee
6 years ago

Creating user list or email list field

I have parent table (customers) with a child table (Contacts).  Contacts contains a user field and an email field I'm trying to combine all of the contact users into a single user list in the paren...
Formulas and functions
Tables and fields
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
There is often a need to summarize non-numeric data up to a parent level when the child level data is not taxed fields.

So the technique is to make a formula at the child level which converts that field to a tax field then use the combine text summary field to get that up to the parent record and then parse it apart on the parent record.

 so for example

on the child record 

ToText(Userid])

Then on the Parent record you can make a field to convert the Combined text summary field to text so you can see what it looks like.  It will be a semi colon delimited string - actually space semicolon space delimited. 

Then you will need a formula to turn that into a UserList field 

The formula would somethng like this

(not tested for syntax)

var text UserString = ToText(Combined text summary field]);
touserlist(
touser(trim(Part($UserString,1,";'))),
touser(trim(Part($UserString,2,";'))),
touser(trim(Part($UserString,3,";'))),
touser(trim(Part($UserString,4,";'))),
touser(trim(Part($UserString,5,";'))),
touser(trim(Part($UserString,6,";'))),
touser(trim(Part($UserString,7,";'))),
touser(trim(Part($UserString,8,";'))),
touser(trim(Part($UserString,9,";'))),
touser(trim(Part($UserString,10,";'))))








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