Generate Audit Number

Background: 

This script will create an number field that keeps a count based on the selected field.  When the contents of the field change it resets to 0 and starts the count over.  There is also a second script that will order the field based on a date field.

Documentation: 

This script will create an number field that keeps a count based on the selected field.  When the contents of the field change it resets to 0 and starts the count over.

To use this script you must select a file and a field to perform the count on.

Using the sales transaction file as an example and selecting the PROD_CODE as the field we get the following:

If we index the file by PROD_CODE you will see that the auto number changes with the contents of the PROD_CODE changes.

 

Comments

Hi
I would like to create an number field that keeps a count based on the selected field.  When the content of the field change it resets to 0 and starts the count over however, i want it to consider the dates also such that the oldest date is assigned the earliest number

Hi
I would like to create an number field that keeps a count based on the selected field.  When the content of the field change it resets to 0 and starts the count over however, i want it to consider the dates also such that the oldest date is assigned the earliest number

Brian Element's picture

Hi Lotis,

I have posted a second script that is what I think you are looking for.  

Brian

This is exactly what I was Looking for.
Thanks a lot

Thank you Brian