You could possibly do this.
Set $Next with the next meeting#.
Set $Current with the current meeting#.
Go to the Minutes Log. GTRR not needed since you are doing Finds there anyway (unless the Find is Constained)
Execute your find - presume $Current and some field = "incomplete".
Then a loop where you go to last record, duplicate, change meeting# to $Next, change field Business to "Previous Business"
and Exitloop when FoundCount = 0
You could then do a find for $Next and $Current and maybe GTRR back to to Minutes Table from the log.
I have found it easier to start at the end of the found set when duplicating records since the duplicate pops to the end (if not sorted) anyway.
So your script may look like the following
Go to Related Record (from Minutes Table using the layout Minutes Log)
Constrain Found set (limit the find incomplete)
Unsort Records // if your records have a sort to them
Go to record Last
Duplicate Record // You are now on the duplicate
Set Field - Previous Business
Set Field - MeetingNumberField + 1
Omit Multiple Records [ With dialog: Off ; 2 ] // The duplicate and the record duplicated
Exit Loop If [ not Get ( FoundCount ) ] // Gets you out of an infinite loop when you run out of records.
'Thank you both for your input, I will work with these suggestions. I just realized that my found set includes incomplete from all meetings in the project so will need to fix that first.
Actually, my way is safer. If another user deletes a record in your found set during this process then your way will end up duplicating a duplicate.
You start with 10 records and store that info in your variable.
Someone deletes one of your records.
You loop through and go to each record in time, duplicating it.
When your counter reaches 10 you are actually on the duplicate of records 1 and you duplicate that record again.
Thank you I will give this a try.
And I guess duplication would be the only way?
The reason your found set has complete from all meetings is because you are using "Find" instead of "Constrain Found Set" in your script. The first just finds "Incomplete" the second finds "Incomplete" *within* your current found set. Your go to related record should keep you to only one meeting. (if you have it set to "Show Only Related Records->Match Current Record Only"
Awesome, thank you ...it works.
Okay now to finish the rest..... this may take me a while to digest.
I don't understand how to set up the following:
Omit Multiple Records [With dialog: Off ; 2 ] // The duplicate and the record duplicated
I have the rest of the script set up as you suggested. I don't know how to do the With dialog: Off;2
so the idea is to export the found set and import them back in a new records?
That script step will omit 2 records and not popup and ask you if that is what you want to do. I usually do the Omit Record, Omit Record as it does, in my view, enhance easy readability.
Yes, you can use two "Omit Record" steps instead of omitting specifically two records with Omit Mulitple. I am glad it is working for you!
Don't forget to mark an answer as correct when things work out for you so that others can find a helpful answer and so that those seeking to answer know that this is resolved.