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

Question

Question

Removing Mail Merge References from empty fields and Replace with N/A

Workflow
Updated September 1, 2020
asked on August 27, 2020 • Show version history

Hi,

Is there a way when the Table from Forms is empty and  when Workflow merges the word tables, then the Table merge rows display N/A instead of just removing the region? Below is the table, so it removes the entire row when it is empty. Instead I would like the values to be replaced with N/A.

This is the desired result:

Is there a way to do this without having to change anything on forms, perhaps with merge if conditions or any functions in Laserfiche Workflow that will allow that?

0 0

Replies

replied on August 27, 2020

You could wrap them in a conditional field in Word to check if the values are blank. This is the Microsoft documentation that describes IF statements:

https://support.microsoft.com/en-us/office/field-codes-if-field-9f79e82f-e53b-4ff5-9d2c-ae3b22b7eb5e?ui=en-US&rs=en-US&ad=US

But this link is a better example of how to use them with merge fields:

https://support.conga.com/content/composer/creating-composer-templates/word-templates/advanced-word-templates/how-to-create-if-fields-in-a-microsoft-word-template

1 0
View 1 previous reply
replied on August 27, 2020

Thanks Miruna, but i am still not getting it correct. I changed the Value 1 to Value 4 in the table to {IF "«Value1»"="" "N/A" " «Value1»"} I could toggle the code and see it is saving it this way and when i toggle code it showed the merge field as  «Value1» then leaving the value empty, but then it just showed the merge field.

 

So I am saying If Value 1 is blank then use N/A otherwise use Value 1. 

0 0
replied on August 27, 2020

Do you still have the WF activity set to remove empty regions and fields?

0 0
replied on August 27, 2020

I have removed those options when i ran the tests, assuming it would need to see the fields to action the conditions.

0 0
replied on September 1, 2020

Hi @Miruna, 

Just letting you know, alternative to the above I used the for each activity to insert the values into SQL and then with conditional decisions I could change the variables as needed which was in turn used in the Word Table merge activity and it is working perfectly.

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

Sign in to reply to this post.

Details
Related Posts
Loading ...