Use a table just like you do in the body of the email. I assume you are emailing employees of customer information? If so, then setup a employee table with a relationship to the customer table using the Cartesian. employee::id x customer::id This type relationship will match all employees to all customers. You would then have a dropdown to select the employee you want to text with their phone number.
If it is the customer you are texting then just add a phone number field to the customer table.
I am able to do the drop down list and relate the table to the rest of the database, but I still don't know how to set the variable to the MOBILE NUMBERS by only passing the name to the script. Essentially, I don't know what to substitute for the CASE command.
You don't need the case script step. Use the Phone Number field in the send mail script step. The dropdown is used to select the employee record which contains the Phone Number field. The Phone Number field will work just like all the other fields in the email script step. Instead of $$mobilenumber you would use employeetable::mobilenumber.
I'm sorry. I'm not able to get it to work.
I choose a name from the drop down field, which gets passed to the script via List Parameters::Mobile Numbers. Then Employeetable::mobilenumber will yield the related phone number.
It seems like I would need something like Go To Related Record where the List Parameters::Mobile Numbers is passed to find the field with Employeetable:employeename.
Thank you so much for your patient.