Randomly Selecting a table row

[Brent_W]

New GlideApps user here, currently on the free account. Loving everything that I’m able to do so far but I am hitting a roadblock that is making me think I need to look at other options, but wanted to ask the community first.

The App I’m making is basically a task list of “Quest items” that I’m making for some friends. My main question is, Is there a way to make an action that will update a row on the table based on certain criteria?

Here are some of the use cases I’m trying to figure out:

Each quest Row has a “Quest Completed” “Quest Cooldown”, and “Quest Status” as the rows i want to work with. Once the quest is completed, The status goes to complete, then the table calculates the date for when the cooldown ends (Ex: Complete on 10/10/24 with a cool down of 2 days, the Calculated date will be 10/12/24). I want to make an action that would:
1 - Filter all the rows that have a status of complete
2 - Check to see if the cooldown date has passed
3 - Set the Status back to pending.

The next step would to have an action Randomly pick a table row with a “Pending” status, and then set that value to “Active” which would make that quest appear to the end user.

I’ve been searching around and trying to figure out a way to do this. If anyone has any ideas or knows of a way to work toward what I want, that would be awesome.

Thanks in Advance

[ThinhDinh]

This would be possible once Glide’s Scheduled Workflows come out. I don’t know of a definite ETA for that, but it would solve your problem.

For the moment, the only way I can think of, is upgrading to get access to the API and do scheduled actions in Make.

[Brent_W]

What if I went a button action route and not a scheduled route? Do you think that would be possible?

[Darren_Murphy]

You can only set values in a single row with an action. So it would be possible, but you’d have to click once for each row that needs to be reset, through a dynamic single relation.

An alternative is to use some variation of the below technique:

Reset Multiple Rows At Once

There have been several requests for people to find a way to clear a value in multiple rows. I was thinking about that and came up with a quick example of a way to handle that. Instead of trying to clear a value in an entire column, I realized we could just change one value on a parent column, load it as a single value in our sheet and then compare that parent value to a column that we set or unset for each row. It’s not about clearing an entire column, it’s about making a value in each row n…

[Brent_W]

@Darren_Murphy

You can only set values in a single row with an action. So it would be possible, but you’d have to click once for each row that needs to be reset, through a dynamic single relation.

An alternative is to use some variation of the below technique:

This looks like it could help. I’m still new to Glide and learning how to do the more “fancy” things. Is there a way i look at the actions of his example? I’m kinda getting what he is saying but not sure how to actually do it.