I have a form that needs to generate an email to several people based on what the user selects.
I have a table of contacts with name and email address that is pulled using a database join and displays in a multi select box on the form.
This multi select is fed from this database table (carriers).
Users select one or more recipients from this select box to get an email when submitting the form.
The details of who is selected is stored in a database table called "shipping_bids_repeat_select_carriers" which stored the ID of the record from the carrier database table (carriers).
I need to grab the email addresses of those selected and I am struggling with the proper code to achieve this in the (eval) section.
Does anyone have any sample code or can help with assisting me with the code I would use here to grab those emails in a comma separated list?
Thank you!
I have a table of contacts with name and email address that is pulled using a database join and displays in a multi select box on the form.
This multi select is fed from this database table (carriers).
Users select one or more recipients from this select box to get an email when submitting the form.
The details of who is selected is stored in a database table called "shipping_bids_repeat_select_carriers" which stored the ID of the record from the carrier database table (carriers).
I need to grab the email addresses of those selected and I am struggling with the proper code to achieve this in the (eval) section.
Does anyone have any sample code or can help with assisting me with the code I would use here to grab those emails in a comma separated list?
Thank you!