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.
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
lotis
Fri, 01/25/2019 - 00:11
Permalink
Auto 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
lotis
Fri, 01/25/2019 - 00:12
Permalink
Auto 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
Fri, 01/25/2019 - 07:40
Permalink
Hi Lotis,
Hi Lotis,
I have posted a second script that is what I think you are looking for.
Brian
SAM
Sat, 01/26/2019 - 01:13
Permalink
This is exactly what I was
This is exactly what I was Looking for.
Thanks a lot
lotis
Sat, 01/26/2019 - 23:12
Permalink
thanks
Thank you Brian
Anthony.Kariuki
Mon, 08/24/2020 - 05:40
Permalink
Bag tagging
I would like to create an number field that keeps a count based on the selected field(Farmer No Or Name). When the content of the field change it resets to 0 and starts the count over -Even if he reappears again however, i want it to consider the dates such that on a certain day everytime he appears the count resets
E.g
Farmer_Name Farmer_No Transaction_Code BagTag/Appended_Field
John KP01 T_09_01 1
John KP01 T_09_02 2
John Kp01 T_09_03 3
Tom Kp02 T_09_04 1
John Kp01 T_o9_05 1
Anthony.Kariuki
Tue, 09/15/2020 - 07:18
Permalink
Bag tagging
The solution above resolves the issue
kpmg_kiddo13
Fri, 11/13/2020 - 06:07
Permalink
I an unable to open this huhu
I an unable to open this huhu. Says the file extension should be .ism?
Brian Element
Fri, 11/13/2020 - 06:34
Permalink
That is because the script is