Delete Row workflow

This should be easy for you! Thank you for helping!

Hello Glide Community!

Since days I’m encountering the same problem to a basic function, with no solution found.

I’m new to Glide, watched all the video content and asked ChatGPT and the support bot for help - no solution.

Problem Description:

I have set up a Glide workflow that should trigger when the “Infusion Assemble” button is pressed in the “Infusion Selection” table. The workflow is intended to delete all previous scent selections made by the current user in the following tables:

  • Scent Selection 1
  • Scent Selection 2
  • Scent Selection 3

Setup:

I have created relations in the “Infusion Selection” table linking the User-ID to the corresponding scent selection tables using the column User ID. The relations are configured to Match multiple rows.

In the Glide workflow, the “Delete Row” action is used to delete all related rows based on these relations.

What is not working:

When the workflow is triggered, the Delete Row action does not delete any rows from the Scent Selection tables.
I have confirmed that the relations are correctly established, as they show the expected related entries.
Even when I remove the conditions and use a direct Delete Row action linked to the relation, the rows are still not being deleted.

Request:

What could be preventing the Delete Row action from working as expected in this setup?

Are there any known issues or specific settings required for relations or Delete Row actions in Glide workflows that could be causing this behavior?

What should I do? Thank you for your help!

Have a look in your workflow run log. That should provide a clue.

Some screen shots would be useful to help troubleshoot. Show us how your workflow is configured, and the related tables/columns.

When you open the workflow, you should see “Run History” in the top right corner, and a list of runs. Clicking any of those will show the details for the given run. Please check there and show me what you see.

This is what I see. Thank you so much, you are a lifesaver Darren!

If you expand those Delete row steps (click the curly brackets), what do you see?

So each Delete row step is deleting a single row. Is that what you expect?

It kind of makes sense, but I get the feeling that you are making this much more complicated than it needs to be. Perhaps we should take a step back a bit…

If you are deleting rows, then I assume that means that each time a user makes a selection a row will be added?

This seems to me to be completely un-neccessary. What I would do instead is just write the selections as a joined list in a single user specific column, split that and use it to make the relations, and then when you want to clear the selection just clear the user specific column.

Maybe I’m missing something, but does that not seem a simpler approach?

So would each “session” consume one row of “selections” in your flow? Say I have a session in your app and choose as many as I want, do you want to store it in my historical data, or would they all be deleted after a session?

This sounds like your screen/workflow is attaching to the wrong user.

I assume this is where you add rows. Wouldn’t this part need to be the signed-in user’s ID?

Thank you, usually I use the rowID for that, but if that User ID is unique, you can use it as well.

Can you please record a video using Loom for your problem?

Is the “chosen” data only shown to the user? Or does it get shown to the admins as well?

It is only shown to the user that is logged in.

But the deletion only happens to the user in the first row of the choice overview table “Aufgusswahl”, regardless of who presses the button.

For now, I don’t have admin status, I just have the same user role. (If you mean that.)

Thank you for your help!

I think you can simplify this.

Add columns to the user profiles table that would hold these choices, you don’t need to add a row each time.

Based on those choices, you can show a collection that contains info from those choices, let’s say a rowID.

On navigation to the screen the next time, clear those columns.

1 Like

Thank you so much, you are a lifesaver. That worked!

1 Like

Great to hear! Thanks for the videos!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.