How to change the status of multiple filtered rows (user's pending products) with one button?

Ask for Help
1

Hi Glide community! :waving_hand:

The app has no login, so I identify each user session through a User_Session ID (Unique Identifier). I’m currently stuck on something that seems simple:

  • I have a Products_Master table that contains all the products a user adds to their cart.

  • Each row has a User_Session ID and a Status field: "Pending" (initially) or "Ordered".

  • There’s also a User_Session table, which stores one row per session and includes a relation to the user’s pending products (Status = Pending).

  • On the “My Cart” screen (based on User_Session), I show only pending products.

:white_check_mark: What I want to do:

When the user taps “Confirm Order”, I want to update all those "Pending" product rows to "Ordered".

:cross_mark: What’s the issue:

  • Since there’s no login, I can’t access the user ID or User_Session from just any table.

  • Loops in Glide don’t let me filter based on the session from the current row unless I store it as a variable first.

  • I tried using JSON Object + Query JSON to filter products by User_Session and Status, and then loop through them — but it feels overly complex.

  • I also can’t loop over the relation directly (from User_Session → Products_Master) to update multiple rows, since Glide doesn’t allow that.

:speech_balloon: Any tips on the best approach?
Is JSON + Query JSON the only way? Is there a clean way to loop through related rows from User_Session and update them?
I’m looking for the simplest method that works without login.

Thanks in advance! :folded_hands:

1 Like
2
  • Use a webhook workflow for your looping part (where you update the rows).
  • Your “Confirm Order” button will have an action to trigger the webhook workflow, and also send a JSON through the body.
  • Configure the JSON in advance, with one of the variables being User_Session.
  • In the webhook workflow, add a Query JSON step right at the top, query the User_Session variable out from the body of the trigger.
  • Use that throughout your loop.
1 Like
3

Yes!!! Works perfectly, thank you much :smiley:

1 Like