How to format a field that is a checkbox in Google Sheets

I am new to AppSheet. I searched for an answer to this question in the help forums, but did not find an answer.

In my Google sheet I used data validation to format a column as a checkbox. I am not sure how to format this column in AppSheet. The closest solution I found is to format the column as Yes/No. However, when I edit this column in AppSheet, the result violates the column's validation rule in the Google sheet.

Here is a screenshot of what the result looks like in my Google sheet:

2023-06-04 23-08-52.jpg

 

 

 

Is there a way to format the column in AppSheet, so that the results comply with the checkbox validation rule in the Google sheet?

0 1 245
1 REPLY 1

If possible, don't use the Sheets data validation feature.

If necessary, fiddle with the Sheets data validation settings or just use a checkbox without data validation.

dbaum_0-1685893637096.png

 

Top Labels in this Space