You are viewing limited content. For full access, please sign in.

Question

Question

Forms Tables - using data for email notifications

asked on March 25, 2016

Hi!  I have a multi-line table (actual # of lines will vary with each submission).  From this table, I will need to send out email notifications to each person listed in the table and include another field in the table in the email notification.

For example, my table may look like this:

City ID     FName      LName     Email                           Disposition

3333        John         Doe          jdoe@gmail.com          In Compliance

3334        Jane         Smith       jsmith@gmail.com        Non Compliance

3335        Mary        Murphy   mmurphy@gmail.com   In Compliance

 

I need to send an email to each individual separately and include their disposition only in the notification -- I need 3 emails with the disposition specific to that individual.

 I can't figure out how to do this utilizing the table.  Can someone help?

Thanks!

Laura

 

0 0

Replies

replied on March 25, 2016

Laura,

I'm not sure there's a way to do this from inside the Forms Process Modeler but you can achieve this by invoking a Workflow.

You would retrieve your fields from the form and then use a "For each value" loop to send out the individual emails.

Within the email editor, you can specify which row in the table you're looking at using the For Each Value -> Iteration variable to grab the values from a different row each time.

 

1 0
replied on March 25, 2016

Laura,

After thinking about my answer, a better solution would be to just grab the entire table and use the For Each Row loop instead. It saves needing to deal with the iteration variable.

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.