Hi,

I'm hosting a survey that submits to a Filemaker Pro 5.5 Database.

One of our objectives is to be able to reject people that try to

submit the survey twice by logging the clients IP address and

rejecting repeat addresses. Currently, I can log the clients IP

address with the [FMP-ClientIP] CDML tag. But, I'm having trouble

coming up with a way to reject people if Filemaker grabs an IP address

that's already been submitted.

Any help is much appreciated.

Couldn't you just delete the duplicates later with a script?

This will delete the first submission of all duplicates, presuming that the reason they are resubmitting is because they made an error. Otherwise it doesn't really matter.

Set error capture [on]

Loop

Enter find mode

Set field, IPAddress, "!!"

Perform find

Exit loop if (status(currentFoundCount) = 0)

Delete record

End Loop

Message ("Duplicates Purged")

Well, we are paying people to take the survey. The payment method works in a way that once the client finishes the survey, filemaker sends an email (using mondomail) off to one of our people with instructions to pay the client. So it's really important that we prevent repeat IP addresses from having access to the survey.

But thankyou for the suggestion!