troubleshooting Question

Script Alert for Duplicate Entries

Avatar of Krisraychris
Krisraychris asked on
FileMaker Pro
3 Comments1 Solution617 ViewsLast Modified:
Hi
I would like to know how to set up a script that will tell the user if a number  has been entered twice.
For Example I have a a field in a Day Table which sets the order in which events take place on that day in that week.
The event order needs to be chageable where on event will preceed another etc
So there will be 1st 2nd 3rd 4th 5 th event and so on( numbered 1 2 3 4 5 6) ....Portal Filtering is set to on .
Validate by Unique value is a problem  as these numbers are reused in other Events occuring in the same week.
I have tried to perform a find in the script and count say all the 1 s or 2s and if  more than one  Event number 2' are found show custom dialogue..this way around sets a limit to what I have placed int he script.
Is there a more efficient way ?
ASKER CERTIFIED SOLUTION
North2Alaska
Senior Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros