Skip to main content
Question

Quickbase Help

  • January 21, 2022
  • 0 replies
  • 23 views

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
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
------------------------------