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

Question

Question

Populate Email with first row from table

asked on December 20, 2018

I'm attempting to send an email to the first person in a table. In the email body, I'm trying to use the variable with the first index specified (/dataset/Household_Members[0]/Name). You can see that I'm using the typical array programming index to specify, but that doesn't accomplish what I want and the email is still addressed to each name in the table (Name1; Name2; Name3,). How do I specify that I only want the first row?

0 0

Answer

SELECTED ANSWER
replied on December 20, 2018 Show version history

You have the index in the wrong place. It should be at the end next to the variable, not next to the table name. Also, I believe the indexing starts at 1 so it matches the "Row()" value.

{/dataset/Household_Members/Name[1]}

 

https://answers.laserfiche.com/questions/88482/In-Forms-10-are-you-able-to-relate-field-values-to-a-file-upload-in-a-given-row?sort=newest

1 0
replied on December 20, 2018

Thank you! I'm used to the 0-index being the first item in an array/collection, so when I tested the placement of the index on the Name, I used ...Name[0], and nothing was populated. Good to know that the index starts at 1. Thanks again!

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.