Hi all,
I'm wondering if there is a use the build string function based on conditionally set values and exclude the blanks.
I have a workflow that checks whether multiple fields are blank vs corrected. If the field does have text in it, I want to create a summary only including the fields that are not blank.
Maybe I'm overthinking this but I can't seem to get it to work.
Exam fields:
Name | Corrected Name | address1 | corrected address1 | city | corrected City | Zip | corrected zip |
---|---|---|---|---|---|---|---|
Joe | 25somewhere | 205 anywhere | home | 12345 | |||
From this ample, I would need the "Corrections Summary" to be "Address1"
but if there were a city correction as well, I'd need it to be:
Address1
City
I think I'm close to having this work but my result ended up being: <br><br>Address1<br><br>
Any help would be appreciated