Question

sending only one row of a collection in an email

Forms

Updated April 9

asked on April 9 • Show version history

So I have a collection that pulls values from a table and the user assigns each collection row to an email address. I would like to email each row's information to the assigned person only and not send all of the information to each person. Is it possible to pull this information out in the email html task?

Here is the email as it sends now the Your payment for 1; 2;3;4 are each of the collection rows, 1 should only go to first person's email with the first amount, and 2 should go to the second with the second amount, etc.

P.S. Forms 11...

Here is what I have, and I need to figure out how to get the rows separated:

Your payment for {/dataset/Batch_Warnings/Warning_Number} in the amount of {/dataset/Batch_Warnings/Amount}...to person {/dataset/Batch_Warnings/Email}

I know I can do this in workflow with a for each, just was wondering if I could do it right form forms somehow.

0 0

Answer

SELECTED ANSWER

replied on April 9

It sounds like you just need to use the For Each Row activity to separate out the variables and fill in the tokens in the email with individual data.

Have your For Each Row Activity reference the collection in your form. Then use the tokens in your email for the To: and the amount and any other fields in the row you want to add.

2 0

Replies

replied on April 9

That is what I did. I was hoping to do be able to do it right in forms and not have to create a workflow to go along with it.

0 0

replied on April 9

Sorry I missed the forms part. Workflow would be the cleanest. If you really wanted to do it in forms you could create individual hidden fields in the form and INDEX each row value to an individual field.

If you know exactly how many rows you would have, this could be fairly simply, but you would need to create the number of Email activities to accommodate each row. If you don't know how many rows but you have a max amount, you would need to create based on the max amount. Use an Inclusive gateway to send each set of variables to the correct email task.

If you don't know how many rows, you have to use WF.

I do have this setup in one of our forms, with a max of 15 rows. I have 15 first name fields, 15 last name fields and 15 email address fields. Then 15 tasks for each row.

Since you are only sending emails, WF will be much faster and easier to maintain, but it can be done in forms.

0 0

replied on April 9

Yeah, I just used workflow. Thank you for all of this.

0 0

You are not allowed to follow up in this post.

Question

Question

sending only one row of a collection in an email

Answer

Replies

Sign in to reply to this post.