Automatically update status when field is blank formula | Discussions

Expand all | Collapse all

Automatically update status when field is blank formula

  • 1.  Automatically update status when field is blank formula

    Posted 03-21-2018 17:49
    I need help writing a formula for:

    When the field Assembly Hours is left blank, the Status of Change Order (which is a drop-down text field) goes to Awaiting Manufacturing 

    When the field Material Hours is left blank, the Status of Change Order (which is a drop-down text field) goes to Awaiting Materials 


    Thank you


  • 2.  RE: Automatically update status when field is blank formula

    Top
    Contributor
    Posted 03-22-2018 16:50
    Try playing with dynamic form rules to accomplish this. 

    If those fields are not visible for whatever reason, you can add this logic to an "Action" or a webhook to make the appropriate updates.