Merge Cell Data

Can anyone explain how to merge cell data from a query. Example combine the first name and last name into 1 cell or combine street, city, state and zip into 1 cell when the query is displayed on the page. It was real easy in dream weaver but i can’t figure it out in Wappler.
Thanks

You can do this in app connect when displaying the data, just use the data formatter => concatenate to on the fields (include concat a space between if needed)

1 Like

Thank you very much, so much to learn about this great product!

1 Like

One last question, the space, how do do I add the space within concat?

Just stack the concatenations like this

image

1 Like

Perfect, thanks again!!

I have been doing quite a bit of this recently and found a slightly different way to add the space. I have found the following simpler and easier to read by using a plus sign “+” which reduces the number of concate steps.

dmx-text="title.concat(' ' + (forename.concat(' ' + (midname.concat(' ' + surname)))))"

Do you need ‘concat’ at all? Couldn’t the expression simply be:
dmx-text="title + ' ' + forename + ' ' + midname+ ' ' + surname"
?

2 Likes

:clown_face: :crazy_face: Doh!
Why oh why didn’t I just think that! The simple things.

<div classroom="always learning!">

:+1: