Hello! I have asked for help with this before, but I think I understand my issue a little more. I have a checklist of kids’ names for the school I work at, and I need some type of mechanism to clear the checkmarks in a column. I originally tried using this in Glide tables and using the loop action in workflow to edit each row and check for the checkmarks, but since there are going to be over 200 names to clear every day, I did not realize this counted for an update (I only have 250 a month, and I would need around 4,000 for this specific method to work. I then tried to use Google Sheets and connect it to a Glide App, which is totally fine, but I realized there is about a 3-5 minute delay from Google Sheets to Glide. Does anyone know a way around either of these problems? To be clear, I basically just need something capable of doing a bulk clear on a column and syncing within 15-20 seconds if possible. Sorry for the long paragraph, thanks!!!
Hi Camryn,
If you don’t need the bulk action to be automated, you can always create a button and make a custom action to clear all of the checkmarks on press.
I have tried that but every time I do it, it does not seem to connect correctly or only does one row at a time. Am I doing this wrong?
This has already been discussed in your previous thread, but there’s pretty much no way to actually clear the value without incurring a lot of updates in Glide.
In Google Sheets, probably you can write a script that can be executed from a call in Glide. I’m not sure if “Trigger Webhook” can do that.
Though, can you tell us what exactly this data is for? There’s probably a way to do it with a bit of a difference in data structure.
I have a solution for you, but you will need to roll up your sleeves for this one.
