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

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!

0 4 289
4 REPLIES 4

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

Yes

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.

@Aleksi_Alkio Thanks for the tip! It seems like there should be a โ€œdisplay nameโ€ for enumerated values in the future.

Top Labels in this Space