Field datatype Select Question

Applications Forms
#1

Hi all,

I have a field on a form that I have used a SELECT as the datatype.

Is there a way to reference the displayed value as well as the hidden value.

E.G the select Displays the ‘Document Type’ and returns ‘Document Type Code’

when i reference the {doc_type} field I get the ‘Document Type Code’ but i’d also like to be able to retrieve the 'Document Type

Any help appreciated.

Cheers

#2

I’m not sure I completely understand what you are trying to do but, you could use SELECT id, concat(c1,’ ',c2) from TABLE where c2 = {doc_type};
Hope this helps.