Question
count how many times date is changed
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
This topic has been closed for replies.
+17Hi 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.
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.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.