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

Question

Question

Table fill out textbox - duplicates

asked on January 9, 2017

Hi everyone!

I am yet again struggling with using table to fill out a single textbox. (https://answers.laserfiche.com/questions/94768/Table-values-in-one-textbox)

This time I got it setup but even with the previous setup, the form creates duplicates.

In my table I have max 5 rows. In my PDF, if the user submits a form that only has one row, the form will copy that one row 5 times. Similarly, if I the users submits a form that has 2 rows, first one will be unique and the last one will duplicate 3 more time (total of 5 rows). However, if a user submits a form with 5 unique rows then that isn't a problem. See screenshot:

 

Does anyone have a solution for this issue?

0 0

Answer

SELECTED ANSWER
replied on January 9, 2017 Show version history

Hi Lidija,

Here's a quick attempt at reproducing things for you:

Here's the submitted form data:

 

Here's the Workflow.  Note that the "Course Info" token within the "For Each Row" activity is appending the data to the "Course Info For Email" token, which is then being used to populate the data in the Email (I've used an Email activity instead of trying to set up a fillable PDF):

Here's the setup of the first token:

And the second token:

And the Email settings:

 

Finally, here's the resulting email content in a single block which is what I'm assuming you're after for a "single text box":

 

I've got some sort of date translation/formatting issue in my setup, but hopefully the above makes sense and helps with what you're trying to achieve.

Cheers,

Mike

 

0 0

Replies

replied on January 9, 2017

Hi Lidija,

I had a similar issue with a table I was trying to populate because I was referencing the token inside the "For Each" activity instead of the one being updated by that token.  In your original post, it would be making sure the table was being updated from the first token in your description of the resolution, the one prior to the For Each loop.  Could that be the problem?

Cheers,

Mike

 

0 0
replied on January 9, 2017

Hi Mike, thanks for your feedback! Here is what that previous form workflow looked like:

I am using the tokens within For Each, is that what is wrong?

0 0
SELECTED ANSWER
replied on January 9, 2017 Show version history

Hi Lidija,

Here's a quick attempt at reproducing things for you:

Here's the submitted form data:

 

Here's the Workflow.  Note that the "Course Info" token within the "For Each Row" activity is appending the data to the "Course Info For Email" token, which is then being used to populate the data in the Email (I've used an Email activity instead of trying to set up a fillable PDF):

Here's the setup of the first token:

And the second token:

And the Email settings:

 

Finally, here's the resulting email content in a single block which is what I'm assuming you're after for a "single text box":

 

I've got some sort of date translation/formatting issue in my setup, but hopefully the above makes sense and helps with what you're trying to achieve.

Cheers,

Mike

 

0 0
replied on January 10, 2017

You are totally right, I had worked through the steps again and go it, thanks for the screenshots!!!! 

0 0
replied on January 10, 2017

No problem, glad it sorted it for you.

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

Sign in to reply to this post.