Generate 'yes/no' from checkbox

[TCM]

Hello,

I am trying to generate 'yes/no' answers from two checkboxes and have it show up as 'yes/no' in my data source. I've tried following some other guides, but get stuck. This is probably very simple, but I haven't been able to figure it out.

Thanks! 

[Akash17]

Hi @TCM 

Your scenario is not much clear as you haven't attached anything but still in general scenario you can do following😊

You can patch your checkbox response into database using

Patch(Tablename,Defaults(Tablename),{Yesno:Checkbox1.Value}); note Yesno is my column name in database

and if you want to show this response in the form of Yes/No in gallery then on Text property of the Label you can set 

If(ThisItem.Yesno=true,"Yes","No")

[WarrenBelz · Accepted solution]

Hi @Akash17 ,

Just adding another option if you are using SubmitForm - I do exactly what you are doing (I do not use Boolean fields at all) - here is a section of my Delegation blog with the process.

[Akash17]

Thank You @WarrenBelz 😊

[TCM]

Hello,

Here the image for my app. I've tried both solutions and the code is showing up as an error. I'm not sure where to put Patch(Tablename,Defaults(Tablename),{Yesno:Checkbox1.Value});. 

Thanks!

[WarrenBelz]

@TCM ,

The code is actually exactly what @Akash17 had for the label but in reverse - it is also in my blog

Patch(
   Tablename,
   Defaults(Tablename),
   {
      Yesno: If(Checkbox1.Value, Yes","No")
   }
)