Display the value of an Option field

poppins

Hi everyone,

How can I display the value of an Option field???
For example, the code Employee.PaymentMode returns 1, but I want it to display the corresponding OptionString...

How to do that???

mohana_cse06

Did you set OptionCaption for the field in table?

David_Singleton

poppins wrote:

Hi everyone,

How can I display the value of an Option field???
For example, the code Employee.PaymentMode returns 1, but I want it to display the corresponding OptionString...

How to do that???

Try

message(format(Employee.PaymentMode));

poppins

May be I wasn't clear enough...The value is displayed just fine in the report...
The problem is when I try to display it in an Excel file (I am exporting data to Excel)...

poppins

mohana_cse06 wrote:

Did you set OptionCaption for the field in table?

Yes, I did it...

poppins

David Singleton wrote:

Try

message(format(Employee.PaymentMode));

Thanks David, it works

David_Singleton

poppins wrote:

David Singleton wrote:

Try

message(format(Employee.PaymentMode));

Thanks David, it works

:thumbsup: