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

Populate a dropdown with combined first and last names.

Overview

The issue occurs when trying to concatenate two database fields into a single dropdown option.
Use the CONCAT function in the Read Data action, ensuring proper spacing around commas in the syntax.

nu 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.

Gr 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

nu 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?

he healyhatman 12 May, 2018

Answer

1 Likes

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

The  commas need to be separated by spaces

nu 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.