Buy Now
Sign in

How is it possible to populate the dropdown field by showing two united fields?

nugget , May 12 at 08:05
Answered
N
nugget
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.
GreyHead
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
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
N
nugget
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?
healyhatman
CONCAT(Model.name , ' ' , Model.surname):Model.full_name​
​​
​The commas need to be separated by spaces
Web developer at SkySpider.com.au
I don't work for ChronoEngine but I do accept donations paypal.me/healyhatman
N
nugget
Thanks Healyhatman!​
​I could never have done it myself.​
​I lost hours trying to find the solution.