topic Concatenating multiple values for one field in App Development

Concatenating multiple values for one field

aswinnar — Mon, 20 Dec 2021 21:08:46 GMT

Hi All,

I am having another requirement, where for example for a store we are showing multiple locations:

For the store walmart for example, we have the following locations:

Dallas, Houston, Chicago, Denver, Miami

When making a selection of a store, we are needing to have a text object that concatenates all of these locations for that store

so if I select Walmart in the text object I should be getting:

Dallas/Houston/Chicago/Denver/Miami

But it seems whatever I try to do I am just getting null values due to their being too many values

Can you please help resolve this

Thanks

Vegar — Wed, 30 Sep 2020 04:37:01 GMT

Hav you tried using concat().

Try like this: concat(distinct [Locations], '/')

ramchalla — Wed, 30 Sep 2020 04:48:14 GMT

@aswinnar if you want to see the values based on the selections, you can use the below

Replace( concat(GetFieldSelections(Location),',','/')