Set the date to today, but allow it to be edited

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I need to track the completion date of the task. So, ideally, when user changes the status of the task to "Completed", I would like the Completion date field to be set automatically to Today. But users need to have the ability to change the date, as say, for example, they've completed the task yesterday and only got to the QB today. Is it possible? When I do this through form properties, the date is locked for Today and I can't change it.

Thank you in advance,

Polina

Photo of Polina

Polina

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
How about a form rule

When multiple conditions are are

ALL of the following
Date completed is blank
Stays is Completed.

Action:
Change Date Completed to Today.

Only fire when conditions become true.
Photo of Polina

Polina

  • 0 Points
Mark, thank you very much! Working perfectly for me!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
Great, thx for letting me know.