Data type "Yes/No": How to show it in a view as checkbox instead of "Yes/No"?

[Thulium]

Hi.

I do not yet understand the handling of the data type "Yes/No".

In the database, a checkbox is shown in the table for this data type.

In the view, however, "Yes/No" is shown.

My public app as an example:
https://www.appsheet.com/start/0d9b20e7-a481-429a-bc9b-95e8fc7a329c

1. How can I realize a "No" in the column in the database table? An empty checkbox is not a "No".
2. How can I show a checkbox in the view?
3. How can I display the data of two columns together at one place in the view type "deck"?
   Specifically: "Task" and "Done"
   Motive: in the view type "deck" there is no possibility to display a fourth content.
   That's why I have like to realize this presentation:
   "Bulb in room 1 [ ]"
   "Doorknob in office [x]"

Thank you for your help : )

[yasarcan]

hi

1.IFS([OnayKutusu]=TRUE, "Evet", [OnayKutusu]=FALSE, "Hayır")

2.Type : yes/no

3.CONCATENATE("Oda 1'deki ampul ", [Görev], " [", IF([Tamamlandı], "x", " "), "]")

Turkish and English are mixed, sorry

[Steve]

---

@Thulium wrote:

How can I realize a "No" in the column in the database table? An empty checkbox is not a "No".

---

In AppSheet Database, a Yes/No column is a Boolean value, TRUE/FALSE, Yes/No, 1/0, set/unset. There is no third option for undefined/blank.

---

How can I show a checkbox in the view?

---

---

How can I display the data of two columns together at one place in the view type "deck"?

---

As per @yasarcan, add a virtual column to the table and use its App formula to include whatever content you want. Display this column rather than one or more of the others in your view.

Note that a deck view will only show one line from each column with no line wrap. If you want line wrap, you might consider @AleksiAlkio's suggestion to use card view, as its description field will wrap and is better suited to longer content.

[Thulium]

---

@Steve wrote:

There is no third option for undefined/blank.

---

I must have expressed myself in a misleading way. That's not what I meant.

Steps to reproduce:

1. Open the database
2. Open a table
3. Add a new empty column
4. Assign the data type "yes/no" to the column

Results:

1. All cells of the column have an empty checkbox (square)
2. In the view those cells do not have the value "N"

To my question:
"How can I show a checkbox in the view?"

With checkbox I meant the square. 

[Steve]

As noted in my previous reply, you could try using the Yes/No display values option.

[JhunePol]

Hi @Thulium 

@Steve  is correct. You can customize the value of Yes or No.

Example:

And the result is 

[Thulium]

---

@Steve wrote:

As noted in my previous reply, you could try using the Yes/No display values option.

---

Hi Steve, thanks for your idea.

But I meant something else.

A checkbox is a standard operating element in the GUI.
https://en.wikipedia.org/wiki/Checkbox 

It is not two symbols next to each other from which you can select one (as with the words "yes" and "no").

It is a single element that changes its state by clicking or tapping.
In my first message I showed a screenshot of the database. The checkboxes are shown there.

In the view for adding a data record, of course I want consistency.
There should be a checkbox. There should not be two different symbols next to each other.

However, this does not seem to work.

It is completely unclear to me why the data type "yes/no" is shown in the database as a checkbox instead of the values "Yes" and "No".

[Steve · Accepted solution]

---

@Thulium wrote:

In the view for adding a data record, of course I want consistency.

---

The database isn't seen by app users, so there is no consistency concern there.

As mentioned previously, Boolean values can be validly represented in a variety of ways.

AppSheet Database is a hack add-on derived from a completely independent experimental Google product. There are many inconsistencies and bugs. You shouldn't be using it, as I've advised previously.

Regardless, that there are inconsistencies is irrelevant. Why should a development tool behave like the production app? The app editor itself doesn't behave like the apps it's used to create.

---

In the view for adding a data record, of course I want consistency.
There should be a checkbox. There should not be two different symbols next to each other.

---

Nevertheless, you've got what you got. You cannot get a checkbox in a form view. As I think about it, I don't think native checkboxes occur anywhere in an AppSheet app.

[MultiTech]

---

@Steve wrote:

AppSheet Database is a hack add-on derived from a completely independent experimental Google product.

---

This had me rollin 🤣

[Thulium]

I searched for an option to export my database (i used the database directly in appsheet as you know) of my app to gsheet. 

Is it true, that there is no such option?

Gemini does not "know" an option.

[Steve]

I don't know. Please contact AppSheet Support for help with this.

[Thulium]

@Steve 

I did that now and will post the result.

[Steve]

Yes, please. I looked briefly at my one Database and was surprised there was no export option. I suspect this may be another reflection of the immaturity of the product.

[Thulium]

I got an answer from the support.

The complete steps to export an internal database to Gsheet

• Go to AppSheet Settings  >  Sources  >  Click on Add new Data source  >  Now add your Google Account 
• Open the App > Data> Table Settings (It is a Database icon right beside View datasource button on top right corner)
• In table settings > Storage > Copy Data Source
• Save the Data to Google 
• Data will be copied in your google drive in folder named Appsheet > Data > “App name” 

It worked for me.

Quite cumbersome for my taste. But I'm sure this will continue to develop. The support is great and friendly. I really appreciate that.