Adding Comma automatically in text input fields

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.
image

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 :slight_smile:
Alvin.

Street1’s Value is not empty:
formatted as text:
Yes → Street1’s value,
No → Empty

Add all rest one after next without append. You can add multiple dynamic values without the append function.

Hope it works.

Hi @animisha45
I truly appreciate your help in looking into this!

Would you mind providing a bit more detail? I’m not entirely sure I fully understand what you’re referring to.

Could you kindly explain further?

Thanks again!
Alvin

@domreg Hope the screenshots help:
Screenshot 2024-09-26 at 9.30.21 PM

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.