How can you record the Date (and or Date/Time) when a formula text field changes?

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

I have a Quote Table with a text formula field "DocuSign Status" (formula is

If ([# of DocuSign Envelopes]=0,"Not Sent",

If ([# of DocuSign Envelopes Completed]>0, "Completed","In Process"))

I'd like to be able to create a formula date field that captures the Date (or Date/Time) of when that status is changed to "Completed." Since this is a formula field and triggered by a summary field from the DocuSign Management table, I know I can't use a form rule to trigger the Date. 

Any ideas? Thanks!

Photo of Dawn

Dawn

  • 0 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 62,994 Points 50k badge 2x thumb
I suggest that since capturing the time that a formula field changes is impossible that you instead do a summary field of the maximum or minimum of the date timestamp of when the child Docusign Envelopes records were created.
Photo of Dawn

Dawn

  • 40 Points
Worked perfectly! Thanks Mark!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,994 Points 50k badge 2x thumb
thx for letting me know.