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 ?