Hi Andy,
If I understand your need, I have been able to do this before.
Let's say you have address fields addressline1, addressline2, city, state, zip and on your Word template, you only want the fields that are filled in to show.
First, create a multi-line text field called something like TemplateAddress.
Then, create a process that is triggered on update of any of your address fields (addressline1, addressline2, city, state, zip).
In this process, first clear the TemplateAddress field, then use conditional statements to add only the filled in address fields to the TemplateAddress field.
So your workflow would be something like:
- Clear TemplateAddress field
- If addressline1 contains data
- Append address line 1 to TemplateAddress field.
- If addressline2 contains data
- Append a line break plus address line 2 to TemplateAddress field.
- If city contains data
- Append a line break plus city to TemplateAddress field.
- etc...
Now, in your Word Template, instead of including the individual address fields, just include the TemplateAddress field.
