Hi everyone, I would like to have a enumerat...

(Kayman Mckay) #1

Hi everyone,

I would like to have a enumerated list that contains a Yes/No option but inputs a value as 1 or 0. 1 for yes, 0 for no.

Is this possible?

Thanks in advance!

(Aleksi Alkio) #2

May I ask this… Do you want to use Yes/No in the app but 1/0 on the sheet?

(Maneesh kumar Pal) #3


(Aleksi Alkio) #4

Then you could use a small table where the numer is the key column and Yes/No column should be the label column. When you call that table from a ref type field, it will show you either Yes or No, but it will write 1 or 0 into the spreadsheet.

(Kayman Mckay) #5

@Aleksi_Alkio Thanks for the tip! It seems like there should be a “display name” for enumerated values in the future.