asked on

Script Alert for Duplicate Entries

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

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Krisraychris

ASKER

Thanks I tried that.If I set it up as a separate file it works (of course) but I think it has to do with the rellationship of the Events Table to the Parent.
Anyway I tried this
ValueCount( FilterValues( List( Set Production Order); "2'' ) for counting the second event for example.
I could have up to 25 events in one day .Any Ideas ?

Tocacar

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.