Question

Checkbox Values into Word Doc

Forms Workflow

Updated January 6

asked on January 3

I have a checkbox variable that I would like to merge into a Word Doc. I am able to remove the underscores by applying the split function, but how can I get the values to separate by a comma or in a list if there is more than one checkbox selected?

0 0

Replies

replied on January 3

You're there pretty much.

Here is All values separated by Line Break:

And here is all values separated by a comma:

0 0

replied on January 6

You can create two multi line fields in your form and use Advanced Calculation to format the values:

Mutli Line Field 1 will capture the selections:

=CONCATENATE(IF(CheckboxVariable.Choice1,"your full explanation here, ",""),
IF(CheckboxVariable.Choice2,"your full explanation here, ",""),
IF(CheckboxVariable.Choice3,"your full explanation here, ",""),
IF(CheckboxVariable.Choice5,"your full explanation here, ",""),
IF(CheckboxVariable.Choice5,"your full explanation here,", ""))

Mutli Line Field 2 will format them:

=IF(RIGHT(MultiaLineField2,1)=",",LEFT(MultiLineField2,LEN(MultiLineField2)-1),MultiLineField2)LEN(MultiLineField2)-1),MultiLineField2)

Then use the 2nd Multi Line Field in your workflow to merge to the Word Doc.

0 0

You are not allowed to follow up in this post.

Question

Question

Checkbox Values into Word Doc

Replies

Sign in to reply to this post.