Question

Displaying a collection in Email Body

Workflow Version 10 Forms Laserfiche

Updated May 16, 2019

asked on May 9, 2019

I collect data from a LaserFiche form that contains 3 fields *Charge, Level and IC Code). I could have 1 to 100 rows of data.

How can I have workflow display each row (With the three fields) in a body of an email?

Like this:

Theft A Felony IC 35-12-34-3-1

Fraud C Felony IC 35-10-3-4

Robbery A Felony IC 35-19-4-5

Is there a table function or something for the body of an email? Thanks John

1.PNG (6.79 KB)

| Download

2.PNG (11.15 KB)

| Download

3.PNG (11.87 KB)

| Download

4.PNG (9.99 KB)

| Download

5.PNG (13.85 KB)

| Download

0 0

Answer

SELECTED ANSWER

replied on May 16, 2019

From your screenshots I can see when you created the combine token, you entered something into the first line. That must be what your seeing. Leave the token empty since it is only going to be for holding the values we set in the loop.

0 0

Replies

replied on May 9, 2019

Each of those variables your pulling from forms comes over as a multi-value token in workflow.

First combine the values into a single multi-value token

For Each Value of Charge

Append Current Value + Level at Index of current iteration + IC Code at Index of current iteration

Here is the syntax

but you can right click on the Level token and the IC Code token to configure it manually like this

Now with all the values combined into one token you can just use the feature, also shown in the screenshot above "all values separated by line break"

1 0

replied on May 14, 2019

Chad thanks for the input. I'm still a little confused any way you can dumb it down a little? The first step above "Assign Token Values" I don't even show the options at the bottom "Append to Existing Values". Can you show it in the designer view by any chance? Thanks John

0 0

replied on May 16, 2019

You have to mark your token as multi-value when you create it to get the option to append values when you modify it later.

0 0

replied on May 14, 2019

See what I did. Only shows one charge on the email when there were 3 charges. John

Capture1.PNG (4.55 KB)

| Download

Capture2.PNG (12.13 KB)

| Download

Capture3.PNG (5.11 KB)

| Download

0 0

replied on May 14, 2019

Hi John

Looks like you chose Create instead of Modify in your Assign Token Values activity. What you want to do is click this Modify button, then Modify an existing Token from another Assign Token Values activity. If that token is setup to be a multi-value token, then you will get the option to append.

In your current workflow, you are creating a new token every time, overwriting the last one. This is why you only end up with the final set of values.

0 0

View 5 previous replies

replied on May 16, 2019

Ok changed it from created to modify which shows the missing options. Still don't have it though. See screenshots. Still only getting the last charge on the email and not the other 2 charges that were enter prior to the 3rd charge. Any more help? Thanks again John

Capture1.PNG (7.81 KB)

| Download

Capture2.PNG (15.97 KB)

| Download

Capture3.PNG (9.59 KB)

| Download

Capture4.PNG (18.72 KB)

| Download

Capture5.PNG (11.46 KB)

| Download

0 0

replied on May 16, 2019

This looks correct, your now appending the values to combine. If your viewing the token values with token tracker you should see it contains all the appended data.

Don't forget when creating the email to separate all values by line break using Apply Index, All values separated by Line Break.

0 0

replied on May 16, 2019

Chad, Can you show what you are talking about? Really struggling with this stuff driving me crazy - I think. I looked at the token values and I'm not sure if the tokens are right. If they are I have no clue how to show them in the body of the email. Is it one token or several. You talked about "line breaks" so I'm guessing more than one??

On the Screenshot I entered two charges on the form:

Charge 1 Level 1 IC 11111111

Charge 2 Level 2 IC 22222222

It only shows charge 1 with the level and IC in the body of the email - Any more help? John

Capture.PNG (20.67 KB)

| Download

0 0

replied on May 16, 2019 • Show version history

Looks like you got it. The combine token has 2 rows now of your combined columns. Now just right click the token and go into the editor, then set it up like this

0 0

replied on May 16, 2019

Ok I got the line breaks in and its returning multiple lines :) But for some reason its not correct the first line is a different format and is repeated in the 2nd line with the correct format?

charge1 IC 1111 Level 1 Felony
charge1 Level 1 Felony IC 1111
charge2 Level 2 Felony IC 22222

0 0

SELECTED ANSWER

replied on May 16, 2019

0 0

replied on May 16, 2019

That was it!!!! I entered all three fields in that combine token instead of leaving it blank!

charge1 Level 1 Felony ic11111
charge2 Level 2 Felony ic2222
charge3 Level 3 Felony ic3333

Thanks Chad appreciate the help!!! John

0 0

replied on May 16, 2019

Awesome! Combining relative multi-value tokens like this is a common operation in Workflow, so now you have a reference you might be able to use again and again.

0 0

You are not allowed to follow up in this post.

Question

Question

Displaying a collection in Email Body

Answer

Replies

Sign in to reply to this post.