skip loop step if duplicate/non-unique number found

[jaygamel]

I have a loop that works! (MYFIRST!EVER!) (see screenshot).

What I hope would be possible is to avoid making duplicates. I have a unique control number (AID+CID) for each record of the link table (linking customers (CID), ads (AID) and the issues the ads appear in (IssueID). this table generates printing text as well as billing and payment records. i cannot figure how how to tell FM to skip making a new record if the control number already exists and go on to the next until the loop is exhausted.

the called script copies a customer's ID and the ad ID (from the ad table that already has both numbers) and makes a new link record with the current issueID. The loop script goes through and generates new link record for every found record in the ad table, thus compiling a list of all the ads that should be in the current issue. But if someone accidentally runs that script twice, I get duplicates. Rather than delete duplicates, I'd prefer to avoid making them in the first place.

I can't figure how to script "if this number already exists, skip to the next record until they are done"

Any help appreciated.

[jaygamel]

I should have updated my profile before: I'm using FMP advanced 11.

[Fitch]

So you're in Ads, and it presumably has a relationship by Ad ID to Links.

We can get a list of all issues this ad has been in with a calc:

List( Links::Issue ID )

I would set the current issue ID into a variable at the top of your script so you don't have to go through the Issues relationship to retrieve it for every ad. So let's say that we have that in the variable 

$current_issueID

We can see if the current issue is in the list of related issues like so:

FilterValues( List( Links::Issue ID ); $current_issueID )

Or test that it's NOT in the list like so:

IsEmpty( FilterValues ( List( Links::Issue ID ); $current_issueID ) )

So in your script you can say...

If[ IsEmpty( FilterValues ( List( Links::Issue ID ); $current_issueID ) ) ]

... proceed to create a new link record

End If

[Jay Gamel]

This looks like it will do the trick, thank you, Fitch. Now I just have to figure out how to insert the if/then into the loop. But that's half the fun of learning this stuff. Happy New Year and I'll be back if I pop a gasket.