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!
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.
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |