I am trying to make a script that will perform a script (find) and populate a field (field1) with the CurrentFoundCount, then run another script (find) and populate another field (field2) with the CurrentFoundCount again. I am using setField to do this, but for some reason it clears the results of the first find and only fills in the results in the last script. For example:

Script 1 = 4 records

Script 2 = 8 records

Results, Field1 = Blank

Field2 = 8

My ultimate goal is to have a script that will run 14 sub-scripts, filling in the CurrentFoundCounts for each script. If this is possible, will I need to create 14 different fields?

Thanks,

There might be an easier way to do this, one not involving 14 different finds and set fields. Probably depends on what kind of finds you are doing. Do they change or are they always the same finds?

I'm thinking there should be a way to duplicate this functionality with self-join relationships.

Don't know if it will work or not. Some more information about what you are needing to do would help.

Hi,

a little unsure why you want to do this.

Are you wanting to remember the records you found, because if so, the Status(CurrentFoundCount) will not give you at the end of your scripting a list of all those records found. It just lists the number of found records at that time.

So, you may have a total of 380 in your result, but only have found 20 records.

Can you clarify what you want to do with the found count at the end of the script run.

I played around with something that I found in the Forums and I think I figured out how to do it. I created a global field to store the Search Criteria and another to hold the results. It works fine. I got it to give me 14 different results running 7 different scripts!

Thanks anyway.