Can someone show me how to do incrementation? There is a file with the field "name" and the field "number of times" in it. When "Tom" is entered into the file the first time, the number 1 would appear in the "number of times" field. When "Tom" is entered again into the file (as a separate record), the "number of times" change to 2. I want to be able to not have a second record, but instead have one record with the 'number of times' as 2.

Thanks.

Not sure that I understand you correctly, but this makes what you wish (or so I think), without script.

Main.zip

Thanks Raybaudi,

What you have there isn't exactly what I need. I've included a copy of my file here. You will see that I have figured out a way to increment by the number of times the name is entered, but I have not been able to figure out how to delete the duplicate copies. For example, amongst others, I currently have the following in 3 records:

Name Number of Times

Jim 1

Jim 2

Jim 3

I only want to retain the record with "Jim" as the name and "3" as the number of times (as I have entered the name 3 times), but don't want the other 2.

Any help would be appreciated!

test_number_of_times.zip

Ok Ants

do a try to this.

test1.zip

Thanks a lot raybaudi, this is exactly what I've been trying to accomplish! I altered the script a little (by adding a loop) as I wanted it to open a new record automatically. I currently set a script to read "If field = '#', go to last record and delete it". I had wanted to end the script automatically by pressing an "end" button, but have not been able to do that.

Again, thanks so much!

Hi Ants

you don't need to make a loop, my example just "open"(create) a new record and, if the name is the same of another record deletes the previous record and add 1 to the "Total times" field, else do nothing; neither you need an END script !

Hi raybaudi,

I wouldn't if this is exactly what I'm incorporating into my solution, but this is a mock test that I had made up to test incrementation. I tried using the same method yesterday in what I'm actually trying to do, but I buck against a wall again. I am actually trying to do an automatic scan of upc codes for a retail solution. Since the solution is in a portal and is linked to a line items file, it is somewhat different from a self-joined file. I am still working on it, altering a few steps, trying to figure out where the differences are and why it's not working as yet.

Hi,

I've been trying to incorporate the test methods into the present "solution", but can't seem to get anywhere. Can anyone help me out here?

new_transaction_test.zip