Forum Discussion

NatasaNedeljkov's avatar
NatasaNedeljkov
Qrew Member
5 years ago

Change drop down value based on last modified date

Hi,
I'm having some issues with setting value to drop down field, based on last modified date.

I've created 2 dynamic rules.
One that works - when I select user, status is changed:
if [user] is not equal to "blank" change [status] to active  

And second one that is based on helper number field:

Helper field ([Notification Time] is numeric set to one of the following values 24/48/72):
past_due = ToHours(Now()-[Date Modified]) - [Notification Time]

and main condition which doesn't work:
if [past_due] >= 0 change [status] to idle

Past_due itself works, and it's calculated well, I've checked by adding it to form as visible field, but condition itself isn't changing value.

------------------------------
Natasa Nedeljkovic
------------------------------
Formulas and functions

1 Reply

Sort By
  • AustinK's avatar
    AustinK
    Qrew Commander
    5 years ago
    So you are editing the record and saving it when it should be triggering the Past Due rule right? If the record is not being edited and saved again during the time it is past due then nothing will change when doing this with form rules.

    If you want your dropdown to be dynamic and change as data changes and time passes then it will need to be a formula field and take into account all the possible changes you want to see. Then people cannot explicitly change the Status on their own though, only through data changes.