Dropdown menu with 2 display fields

[maicolgalante]

Hi, i want to create a dropdown menu into my submission form that display 2 concatenated fields (data and ora) into the "Field for display".  Is that possible?

[TellMeWhy]

You may create a Formula Field in your Table instead, concatenate the two field through that field, and use that for Display.

 

[RuisiHansamu]

When creating a Formula field, please make sure to have knowledge about the best practices as well. I suggest you check this article from Caspio: https://howto.caspio.com/tables-and-views/data-types/formula-fields/ This helps a lot.  

[cheonsa]

Hi all, 

In addition to previous responses, make sure that when you concatenate fields, convert it to Text(255) as well if you would like to use this Formula Field in Field for Value. Concatenating two Text(255) fields, makes the Formula Field as Text(64000). 

Refer to this formula:

Convert(nvarchar(255), [@field:First_name] + ' ' + [@field:Last_name])

Hope this helps.