Forums

Please write a review for the extension you are using on the Joomla extensions directory before posting a new question as we are being spammed by many negative reviews.

Thank you for your support!

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

nugget 12 May, 2018

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 12 May, 2018

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

nugget 12 May, 2018

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 12 May, 2018

Answer

1 Likes

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

The  commas need to be separated by spaces

nugget 14 May, 2018

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

This topic is locked and no more replies can be posted.

2Checkout.com

2CheckOut.com Inc. (Ohio, USA) is an authorized retailer for goods and services provided by ChronoEngine.com