Create full name column

I have a table with 2 columns: name and full name.
It's retool database (sql)

How to query and then use in select component a variable which is a full name?

fullName = name + surname

@Ana - Can you post some screenshots?

If you use the Mapped option in a select component you can dynamically define any field including the Value or the Label of any option based on values for that option's row. The row is stored in the {{ item }} object and has keys for each column, so you could try something like {{ + " " + item.surname }}.

Curious to know if that works here, or if something different is needed.

thank you! :slight_smile: works