Default value for a yes/no column

[YIK3S]

I'm trying to set the default value of the question as N/No however the button isn't being highlighted. I've even attached a pictured of what I've set the initial value as.

[diogolupcosta]

You should use "No"

[YIK3S]

Nope, it still hasn't worked.

[Joseph_Seddik]

FALSE

[YIK3S]

nope still doesnt work 

[Joseph_Seddik]

Works for me. Are you testing without saving maybe?

[diogolupcosta]

"No" with double quotes is the way for it. If it isn't working, u should contact support

[SkrOYC]

I use logic when it comes to Yes/No stuff.

0=0 as true
1=0 as false, for example

So, place this on your initial value:

0=1

[SkrOYC]

?

[YIK3S]

place my initial value as 0=1 in the initial value column? again I just want the default value of the button to be set at No but then the user can change it to Y if needed 

[SkrOYC]

---

@YIK3S wrote:

place my initial value as 0=1 in the initial value column?

---

Exactly

[YIK3S]

still doesn't work, do u have any other suggestions?

[SkrOYC]

Actually, a bug.

https://www.appsheet.com/Support/Contact

[Steve]

Are these the same column?

[YIK3S]

yes, I had changed the display name to "complete ?" but it is the same column 

[Marc_Dillon]

Are you adding a new record or trying to edit an existing one?

[YIK3S]

adding a new record

[Fernando_Lopez1]

the initial value has to be FALSE

[chetany]

Try giving the initial value as "N", it works for me.

[PostOffice22]

The same bug is happening to me as well at the moment.
No matter what I put for initial value (FALSE, "No", No) it does nothing. Both options are selectable when form appears.

[leonsteber]

Yep, Same for me, I've tried everything mentioned above to set the initial value and it's ALWAYS defaulting to the YES value.

I've managed to get this working elsewhere, I'm sure of it 

[ScentStrategy]

Hi,

You need to set the initial value as FALSE, not No, as AppSheet doesn't understand Yes/No, it understands TRUE/FALSE, and then translates it to Yes/No for the user.

Hope that clarifies.

[leonsteber]

Yes, I tried:

• FALSE
• "FALSE"
• No
• "No"
• N
• 1=0

[ScentStrategy]

That is so weird.... Just to confirm, you're editing here right:

[leonsteber]

Yes, that's the spot. It's weird, because like I said, I've had it working with an expression in another app!

[ScentStrategy]

Wow, that is really weird. And since there is no error, I can't think of anything else.

[Steve]

Please start a new topic for your problem. Please include a complete description of the problem and include screenshots of the relevant configuration.