Hi,
I have a column with a Yes/No type. I want the initial value to be false so have set the initial value formula to be =false. When I add a new record, the form shows the Yes/No column with the No button coloured as if it is being used but when the app is synced, the google sheet column is blank and does not contain FALSE. I have slices that filter my data based on this column being false. Does anyone know how to set the initial value of a Yes/No column type?
Thanks in advance.
That’s how it should be…
That’s very odd.
Have you tried setting =“N” to the initial value?
Just to be clear, since you didn’t say so explicitly, you did Save the form before the sync, yes?
I just tested and was unable to reproduce that issue; the Initial Value of =false for a Yes/No column type worked, and when adding new record No button was selected by default, and after save/sync I did find FALSE value in the back-end Google Sheet.
If default Yes/No column type is chosen, the default check for it shall be =“N” or = FALSE and it’s recorded as TRUE/FALSE to the backend sheet.
I tried it. It didn’t work for me, may be I did something wrong.
So I have a Yes/No column, and it’s initial value is =“N”, but I can not see both in the application and in spreadsheet, “N” as a default value.
If you have a Yes/No type column and the initial value is set to FALSE, when you launch the form “No” option will be automatically selected/highlighted.
when you launch the form
I feel dumb, I was trying to view that in the existing form.
Thank you.
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |