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...
Forum Discussion
Hey @Jennason Quick Base Admin
Just to clarify the ultimate purpose of all this work: Is your goal to create a QB notification? Or a distribution list that would be exported and copy/pasted into an email address field?
------------------------------
Chelsea Carpenter
------------------------------
Just to clarify the ultimate purpose of all this work: Is your goal to create a QB notification? Or a distribution list that would be exported and copy/pasted into an email address field?
------------------------------
Chelsea Carpenter
------------------------------
Hi Chelsea- My ultimate goal is to create a user list field at the parent level (customers) that is a collection of the user fields on all child records (contacts). I would then use this user list field as the recipient of QB notifications at the customer level
Im playing around with Marks suggestion and also with using a simple pipeline that appends the user to the multi-user field each time a new contact is added... just struggling a bit with figuring out the correct jinja syntax to do that (in case there are any jinja experts out there)
Thanks.
------------------------------
Jennason Quick Base Admin
------------------------------
Im playing around with Marks suggestion and also with using a simple pipeline that appends the user to the multi-user field each time a new contact is added... just struggling a bit with figuring out the correct jinja syntax to do that (in case there are any jinja experts out there)
Thanks.
------------------------------
Jennason Quick Base Admin
------------------------------
- Okay, I don't know if this helps, but I did a similar thing - except the notification kicks off from the parent table.
On the parent table, I have a multi-select text field called "Contact(s)". Input type is From Another Field, and that references the child table.
I then created separate Contact Email fields (I made 5 because that's the max we expect), these are Formula - Email fields:
var text EmailList = ToText([Contact(s)]); Trim(Part($EmailList, 1,";")) // Taking values from multi-select field Contact(s) and parsing into separate email fields
(Just update the 1 to the 2-5 for the other fields)
It'd be easy enough to now pull those Contact fields into your child table as regular lookup fields, and you can then address your notification to go to Contact Email 1-5 (in this example).
------------------------------
Chelsea Carpenter
------------------------------