Field Validation in IWP

[GoTigers]

Because the built in field validation causes a problem with FM Server Advanced (the error 13 problem that has been discussed here in this forum), I've had to turn off unique field validation for a field that really needs to be unique. Does anyone have a good script for validating a field as unique in IWP? Thanks!

[Inky Phil]

How about setting up a self relate on that field and using the Count() function in your script to see if it already exists

Phil

[GoTigers]

I've been trying a script with that as an element, but I've been unable to make it work. Thanks for the input, though!

[xochi]

Are you committing the record before you check for duplicates? My guess is that if you haven't submitted the record, the relationship won't work and you'll always get N-1 as the count of identical keys.

Another way to do it might be to break up the data entry: Have an initial screen where the person enters only the info that must be unique, and have them enter that into a global field. Then script a "continue" button which checks it for uniqueness by doing a scripted Find (setting the Find field to the value of the global field they just entered). If you find matches, you can then do something sensible (like, take them to the duplicate record and have them edit it, etc.)

[GoTigers]

I have committed the record, but the script I have, which I've customized (I believe from the FM knowledge base) has a step in it which pauses the script, and I think this is what isn't working with IWP. Thanks so much for the advice.

[xochi]

Yep. Click the "show web compatibility" checkbox in the script editor, and it will alert you to script steps (or script step options) that are not IWP friendly.

[Vaughan]

What's this "error 13" problem?

[GoTigers]

When using FileMaker Server Advanced and IWP, when you have field validations turned on, after a time, noone can log into any hosted databases. They instead get "error 13" when they attempt to log in. FIleMaker is aware of this "bug." I don't know whether it's fixed for FM Server Advanced 8.5 or not.

[GoTigers]

Yes, this is a great feature to instantly identify IWP compatible script steps.