Forum Discussion

PaulEaston's avatar
PaulEaston
Qrew Assistant Captain
4 years ago
Solved

Dynamic Form Rule - when record opened by User specified in field

I am wondering whether the following is possible and, if so, how to go about accomplishing it.

I have a new task form that includes a field for "Assigned To"

There is also a "Status" field.

Tasks are only created by supervisors. 

When the User selected in the "Assigned To" field opens the created task record, the Status field should be set to "OPENED".  

I know you can create a dynamic form rule to fire when a record is opened, but I only what it to fire when the user specified in the Assigned To field opens it. 

Is this possible? If so, how do I go about accomplishing this?

------------------------------
Paul Easton
------------------------------
  • np
    Just set up a form rule that says when 

    Multiple conditions are true

    Status is blank

    Assign to is the current user

    action

    Change status to opened

    And uncheck that little check box at the bottom of the rules so that the rule fires all the time



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------

2 Replies

  • np
    Just set up a form rule that says when 

    Multiple conditions are true

    Status is blank

    Assign to is the current user

    action

    Change status to opened

    And uncheck that little check box at the bottom of the rules so that the rule fires all the time



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • PaulEaston's avatar
      PaulEaston
      Qrew Assistant Captain
      Great, thank you!

      ------------------------------
      Paul Easton
      ------------------------------