# Is there a way without using API I can change status of all rows based on condition? **URL:** \ **Category:** Ask for Help\ **Created:** [August 30, 2024, 4:35am UTC](https://community.glideapps.com/t/is-there-a-way-without-using-api-i-can-change-status-of-all-rows-based-on-condition/75984 "2024-08-30T04:35:19Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [August 30, 2024, 4:35am UTC](https://community.glideapps.com/t/is-there-a-way-without-using-api-i-can-change-status-of-all-rows-based-on-condition/75984/1 "2024-08-30T04:35:19Z")
Hi Guys, I have a requirement where I need to check data difference and if the date difference is more than 7 days I need to change that particular row status to Stagnated. I want to have a button called “Clean Up” and on click of that I want it to change Is using API the only approach? Os is there any other way? Regards, Dilip ---
**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:** [August 30, 2024, 5:26am UTC](https://community.glideapps.com/t/is-there-a-way-without-using-api-i-can-change-status-of-all-rows-based-on-condition/75984/2 "2024-08-30T05:26:43Z")
Why not just use a simple if-then-else column? ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [August 30, 2024, 5:39am UTC](https://community.glideapps.com/t/is-there-a-way-without-using-api-i-can-change-status-of-all-rows-based-on-condition/75984/3 "2024-08-30T05:39:07Z")
Hi @Darren_Murphy , Thank you for replying. I want it to update every corresponding rows Column after checking the condition. You mean I use if else if by comparing it with number of days.? **If I do that I wont need a button right? correct me if I am wrong** It should update without any users action? Regards, Dilip ---
**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:** [August 30, 2024, 5:44am UTC](https://community.glideapps.com/t/is-there-a-way-without-using-api-i-can-change-status-of-all-rows-based-on-condition/75984/4 "2024-08-30T05:44:29Z")
> [@Dilip\_Adiga](#): > > It should update without any users action? Correct. It would be a computed value based on the passage of time. ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [August 30, 2024, 7:04am UTC](https://community.glideapps.com/t/is-there-a-way-without-using-api-i-can-change-status-of-all-rows-based-on-condition/75984/5 "2024-08-30T07:04:33Z")
Hi @Darren_Murphy , Here is a complication for me. I have 4 status A, B , C and D Only when it is status A and B and date difference is more than 7 days I want it to change the status to stagnated. Else it should be as it is. how can I make this happen? Right now it changes everything to stagnated after 7 days Meaning even C and D **Should I Use Javascript?** Regards, Dilip ---
**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:** [August 30, 2024, 7:10am UTC](https://community.glideapps.com/t/is-there-a-way-without-using-api-i-can-change-status-of-all-rows-based-on-condition/75984/6 "2024-08-30T07:10:30Z")
- If Status is C, then Status - If Status is D, then Status - If Age is greater than 7 Days, then Stagnated ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [August 30, 2024, 7:25am UTC](https://community.glideapps.com/t/is-there-a-way-without-using-api-i-can-change-status-of-all-rows-based-on-condition/75984/7 "2024-08-30T07:25:39Z")
Thank you for helping me out @Darren_Murphy I understand now the if condition is sequential series thus it will take the latest value. Regards, Dilip ---
**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:** [August 30, 2024, 7:26am UTC](https://community.glideapps.com/t/is-there-a-way-without-using-api-i-can-change-status-of-all-rows-based-on-condition/75984/8 "2024-08-30T07:26:18Z")
If-then-else will return the first condition that is true. ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [August 30, 2024, 7:27am UTC](https://community.glideapps.com/t/is-there-a-way-without-using-api-i-can-change-status-of-all-rows-based-on-condition/75984/9 "2024-08-30T07:27:53Z")
Thank you for clarifying that. @Darren_Murphy I got confused Regards, Dilip ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [September 6, 2024, 7:28am UTC](https://community.glideapps.com/t/is-there-a-way-without-using-api-i-can-change-status-of-all-rows-based-on-condition/75984/10 "2024-09-06T07:28:02Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.