Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 7961 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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.

Posted

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")

  • Newbies
Posted

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!

This topic is 7961 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.