How can I realize a “No” in the column in the database table? An empty checkbox is not a “No”.
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”?
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 ”
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.
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”.
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.
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.
