Forum Discussion

DanielSim's avatar
DanielSim
Qrew Member
3 years ago

Quickbase Help

Hello I am new to Quickbase and I am looking to add a completion date field to my form. This completion date would trigger based on when the user modifies a record. The user would go into the entry, change the status field (multi-choice select) to complete, and then when that user saves the record... it would mark the completion date. Can this be done?

------------------------------
Daniel Sim
------------------------------
  • Sure, no problem.
    You can view any record and then at the top right customize this form and then go into dynamic form rules  

    Make a rule something like this.  
    When multiple conditions are true

    when all of
    Then completion date is blank  (just leave the date blank)
    Stauts = Complete

    Action
    Change the value of Date Completed to the current date.

    Post back if you have any problems with that.


    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • DanielSim's avatar
      DanielSim
      Qrew Member
      Wow! I think that worked! Thanks!

      ------------------------------
      Daniel Sim
      ------------------------------