Hi,
I need help here.
I have setup a few fields for users to key in. For address purpose.
Depending on user, some users may key in the entire street address to street1 field or some users may key the address in both street 1 and street 2 field.
I have setup a workflow to add all these fields values together to look like a proper address.
The problem I’m facing is that, I need commas to be automatically added to each values and for fields that has values in them.
So lets say users keys in all street info to street 1 then the output should be
Street1, City, State, Postal Code, Country.
Or
If users key in to both street1 and street2 then the output should be
Street1, Street2, City, State, Postal Code, Country.
the workflow works, but i need to make sure that commas are added to each value.
What my workflows gives at the moment :
Street1 City State Postal Code Country
What i need is
Street1, City, State, Postal Code, Country.
Thanks for taking the time reading my lengthy post
Alvin.