Buy Now
Sign in

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

nugget , May 12 2018
N
nugget 3
May 12 2018 #377647
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 63.5
May 12 2018 #377648
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 3
May 12 2018 #377651
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 6.0
May 12 2018 #377652
1
 Answer
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

You can now copy+paste code from forums
N
nugget 3
May 14 2018 #377661
Thanks Healyhatman!
I could never have done it myself.
I lost hours trying to find the solution.