How To Delete Multiple Rows Conditional Thru Glide App?

Hi Members,

Kindly guide me for deletion multiple rows conditionally thru Glide App. This is for your information that I am using Glide Table. Thanks in advance.

At the moment, the only way to delete multiple rows from a Glide Table with a single action is via a custom action with multiple Delete Row actions - which isn’t very scalable.

My understanding is that the Glide API will be made available for apps on Pro Plans at sometime in the future, so that could be an option soon(ish).

1 Like

Hello, I am new to glide and this option interests me. Do you have an example to understand it better and be able to apply it? Thank you

Consider this as an alternative.

I delete rows in my restaurant app with a similar method.
I have a table for waiter calls which records certain calls to the waiter with a time stamp.

In every waiter call row, there is a column IF Else True/ False if this row is available to delete. That is if the timestamp the row created is over 3 hours (for example)

In the same row as well there is a single relation to the first available row to delete.

Every time a new row is added to the table… the first available row to delete is deleted.

6 Likes

I think a multi-delete action should be added as it is impossible to workaround it.
For some applications it is necessary and the workaround people is taking is like deleting one by one when some action is triggered, which is not good for user experience.

That would be ideal, but with the Glide API in action now, you can:

  • Create a relation and joined list on top of it to return a list of rows that needs to be deleted.
  • With a button, send that list to an external service like Make.
  • Use an iteration module to loop through the array created from that list.
  • Use a HTTP module to iteratively delete rows using the rowID you sent.
3 Likes

Ya…I’ve gotten this to work as @ThinhDinh describes above, but it’s not intuitive. Set Column and Delete Row action over a multiple relation needs to be a thing. We’ve been asking for it since 2019. @Mark :pray:

2 Likes

This is still one reason to use GoogleSheets: search rows in make.com or zapier → rowIDs-> delete with GlideAPI.

To avoid GoogleSheets, I guess, we would need Glide’s API to have GET requests.

I have been waiting for this ever since the API gets introduced… Even getting all rows like what they have with enterprise would be great, the dream is to get a single row by specifying a column name and a value, I imagine.

1 Like

Thanks. i will try that option. Seems better than anything else

1 Like

I think today It’s a mandatory. Ok it works with Make, but this feature is really required in many apps.