How to track number of times a field is changed into the Activities section on a form?

[thrsdy1512]

Hi 

I'd like to track the number of times a field changes in the Activities section on a form. There is a 'Outcome' field that has been added to the form & I want the Activities notes to increment number of times that field has been changed. I am working with the Change Task table. 

I would also this number to be visible in a read only field that is displayed on the form.  What is the most straightforward (ie - beginner level 😊) way of achieving this? 

Thanks

[Voona Rohila]

Hi @thrsdy1512 

You can write a before Insert/update BR which triggers when 'Outcome || changes' 

In the script part use below code : Give the field name of the number field which is storing the count

current.fieldname = current.fieldname +1 ; //use proper field name here

[Ankur Bawiskar]

@thrsdy1512 

I agree with what Mark has mentioned.

We would like to know the business use-case for this.

You can create a field as per suggestion by Mark and increment it everytime field is changed.

Please let us know if any further help required.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Dr Atul G- LNG]

Hi @thrsdy1512 

Could you clarify what your business case is in this context, and what you plan to do after retrieving these records? Understanding the objective will help in determining the next steps and how to handle the data effectively.