Changing the value name of a database field

[Kendra]

Is there a way to change the value of a field other than it defaulting to a number?

For instance, I would like to have it display as \"approved\" or \"not approved\" instead of 0 and 1.

Not sure if it's possible.

Thanks!

[Julea]

On the configure results page you should do the following:

In the Field Options Section:

Formatting: Custom

Format Type: Yes/No

Yes/No Display: custom (this will enable the Custom Yes/No Symbol)

Custom Yes/No Symbol: Approved (in the 'yes' field) and Not Approved (in the 'no' field).

[AtayBalunbalunan]

For more information about Format Types, you can refer to this article: https://howto.caspio.com/localizations/format-types/

[MayMusic]

What is the form element of the field? I believe it is a Yes/No field as you get 1 and 0. If you change it to a text field then you can change the value when checked on your DataPage if it is a checkbox. Or you can have a radio button and enter your custom options.  

[PotatoMato]

Hi! Just to update this post. You may refer to this forum post: 

 

[RuisiHansamu]

Hi! I believe this will be helpful as well: