Forums

I have a table with: ID; name; surname; etc ..
I would like to be able to create dropdown showing surname + name
How should I set the data setting select in read_data?
How to play a 2-field arry from the "All matching records" set?
Thanks.

Hi Nugget,
​
You should be able to specify a combined column in the Save Data action using code like this in the Fields to Retrieve box of the Read Data action:

CONCAT(Model.name, ' ', Model.surname):Model.full_name 

Bob

Hi Bob and thank you for your answer
I had already tried but unfortunately it does not work. The concat function returns an error; I tried with all the possible syntaxes.
Is there another way?

Thanks Healyhatman!
I could never have done it myself.
I lost hours trying to find the solution.