Acionar o checkbox do checklist de produtos

[Jeff_Hager]

1. I tried to figure out a way to hide items in a list that was filtered using a query in google sheets. I can’t think of a good solution. Using a script to delete a row once it’s checked might be a better solution.

2. You could have a sheet with all of your products listed. Using a Query, you could pull the info into another sheet where the checkbox is checked or unchecked. You couldn’t edit that list from the app, but you could manually edit it inside google sheets on the master product list sheet.

There’s some good info here that might be similar to your situation:

Delete rows programmatically

Is there a way to delete rows based on a set condition? Now that there are row limitations for free apps, I’m thinking of a way to build an app that basically resets itself every month so that it (hopefully) never hits the 500 row limit. Here’s the concept: users enter workout details into the app (i.e. on Monday, I biked to work). Each workout has a points value attached. Users are then ranked and top users for the month are recognized in some way for promoting health and wellness (FYI I work …