Is there a way without using API I can change status of all rows based on condition?

Ask for Help
1

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

2

Why not just use a simple if-then-else column?

3

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

4

Correct. It would be a computed value based on the passage of time.

5

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

6
  • If Status is C, then Status
  • If Status is D, then Status
  • If Age is greater than 7 Days, then Stagnated
1 Like
7

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

8

If-then-else will return the first condition that is true.

9

Thank you for clarifying that. @Darren_Murphy

I got confused

Regards,
Dilip

10

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