I would do it through Globyflow. When the date field changes, run a flow that increments a numeric field in your app
Count the times I change a field
I'm trying to add a calculated field on one of my apps that counts how many times I change a certain field. I'll explain:
1. I have an app that is set up as a CRM
2. Within the app, I have a field that's called "Last Contacted". Every time we call a contact, we change the date on this field.
3. I would like to set a new calculated that counts every time I change the "Last Contacted" field so that I can keep track of how many times I called a certain contact.
Please sign in to leave a comment.
I would approach this by simply adding a numerical field in the app, then using a simple globiflow that is set up as follows:
-When an item is updated
-Filter for If Last Contacted has just changed
-Then use an update item step and update the "contact count" field with a calc of the current value + 1
If you are wanting to avoid the possibility of someone manually editing the Contact Count value, you could even make the Contact Count numerical field an always hidden field, then use a calc field to simply reference/display that value.
You could create a new app called "Contact Records" with fields
Then whenever the date field changes, create an item in this app using Globiflow. This would allow you to access the total number of contacts and date of last contact within your CRM app as:
@all of Contact Date.length
@max of Contact Date