# Randomly Selecting a table row **URL:** \ **Category:** Ask for Help\ **Created:** [October 12, 2024, 9:39pm UTC](https://community.glideapps.com/t/randomly-selecting-a-table-row/77018 "2024-10-12T21:39:28Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Brent\_W](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brent_w/32/80656_2.png) [@Brent\_W](https://community.glideapps.com/u/Brent_W)\ **Post date:** [October 12, 2024, 9:39pm UTC](https://community.glideapps.com/t/randomly-selecting-a-table-row/77018/1 "2024-10-12T21:39:28Z")
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 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 13, 2024, 12:08am UTC](https://community.glideapps.com/t/randomly-selecting-a-table-row/77018/2 "2024-10-13T00:08:37Z")
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. ---
**Author:** ![Brent\_W](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brent_w/32/80656_2.png) [@Brent\_W](https://community.glideapps.com/u/Brent_W)\ **Post date:** [October 13, 2024, 6:40am UTC](https://community.glideapps.com/t/randomly-selecting-a-table-row/77018/3 "2024-10-13T06:40:36Z")
What if I went a button action route and not a scheduled route? Do you think that would be possible? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 13, 2024, 7:56am UTC](https://community.glideapps.com/t/randomly-selecting-a-table-row/77018/4 "2024-10-13T07:56:28Z")
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](https://community.glideapps.com/t/reset-multiple-rows-at-once/22211): > > 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… ---
**Author:** ![Brent\_W](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brent_w/32/80656_2.png) [@Brent\_W](https://community.glideapps.com/u/Brent_W)\ **Post date:** [October 13, 2024, 1:44pm UTC](https://community.glideapps.com/t/randomly-selecting-a-table-row/77018/5 "2024-10-13T13:44:51Z")
> [@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.