Hi, I have a column with a Yes/No type. I w...

[Nick_McDermott]

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.

[Grant_Stead]

That’s how it should be…

[Steven_Coile]

That’s very odd.

[Levent_KULACOGL]

Have you tried setting =“N” to the initial value?

[Steven_Coile]

Just to be clear, since you didn’t say so explicitly, you did Save the form before the sync, yes?

[RezaRaoofi]

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.

[Levent_KULACOGL]

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.

[Atlas]

@LeventK

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.

[LeventK]

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.

[Atlas]

when you launch the form

I feel dumb, I was trying to view that in the existing form.

Thank you.