It’s a bit complicated. I am creating an app that works similar to classified ads - one user posts an ad, another responds to it. When the second user searches for an ad to respond to, he or she selects certain criteria, such as City, Date, and Category.
“City Selection” and “Date Selection” are user-specific columns in the “Posts” sheet. “Categories” is another sheet (displayed as a checkbox list) with a user-specific “Check value” column.
When a user starts a new search, I need to clear out his or her previous selections. To do so, I made a custom action on the “Search” button, that has three steps inside:
- Set columns (sheet “Posts”) - Clear values (“City Selection” and “Date Selection”)
- Set columns (sheet “Categories”) - Clear values (“Check value”)
- Link to screen with search parameters
In order to be able to set columns, I had to create relations between the Home sheet and the “Posts” and “Categories” sheets. To do so, I created a regular column “True” in the Home sheet (with just one “True” in the first row) and single-value columns “Dummy True” in the other two sheets, that take the value from the “True” column. Then I created two relations in the Home sheet between “True” and “Dummy True”.
Now, the question.
It works for one sheet (“Posts”), but it doesn’t work for the other (“Categories”).
In other words, “City Selection” and “Date Selection” are cleared, but “Check value” is not.
UPD: It actually clears only the first row of the sheet.
Why is that?
The only difference I see is that “City Selection” and “Date Selection” are text columns, and “Check value” is boolean. However, it should not be the reason (and also, converting it to text doesn’t help).
My app’s URL: Glide · Create Apps from Google Sheets