count how many times date is changed

  • 1
  • 1
  • Question
  • Updated 3 months ago
  • Answered
  • (Edited)
Basically I have a date field and want to change a field called number of time contacted everytime date is changed. The date field is last contacted so everytime date changes, increment number of times contacted by 1
Photo of tayeb x

tayeb x

  • 70 Points

Posted 3 months ago

  • 1
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 11,516 Points 10k badge 2x thumb
Hi Tayeb,

In the past the way I have done this is to have a field on a record that tracks number of times changed and another field that is a numeric formula that pulls up number of times changed +1. Then you can set up an Automation that say whenever a record is edited and that date field is changed copy the value from the field times changed +1 to times changed. Then each time it is edited it will climb up one increment. You just need to set up that formula field to give you the next increment and then the logic for your Automation to edit the triggering record when the date field changes. I hope that suggestion is helpful.