Discussions

Expand all | Collapse all

Change a Status Automatically

  • 1.  Change a Status Automatically

    Posted 10-11-2017 21:54
    I have a [Status] field that is a normal text field, with a list inside it. I have a checkbox that automatically checks if an estimate has been open for more than 30 days without becoming an order. This checkbox is the indication that the estimate should be marked expired in the status field. 

    How do I make the status automatically change when that box is checked. Form rule didn't work because you would have to go in to edit each estimate first.  I need it to automatically mark the estimate as expired.  

    Thanks!


  • 2.  RE: Change a Status Automatically

    Top
    Contributor
    Posted 10-11-2017 22:04
    You would need to make your 'status' field be a formula as well.  

    Most people handle this by having a "master Status" and a "manual" status.  

    That way the formula will update based on dates and other criteria that you define, while still allowing for manual overrides.