AnsweredAssumed Answered

FIeld Validation script for IWP

Question asked by rphillips on Mar 2, 2012
Latest reply on Mar 2, 2012 by davidanders


FIeld Validation script for IWP


I was helped previously with this information,

"Then define a text field as UniqueKey and give it this auto-enter calcualiton:

FiscalWeek & " " & UserID

Now you can set a unique values validation rule on UniqueKey and it will pop up an error message if the user attempts to create a records where that combination of UserID and FiscalWeek already exist."

Thanks PhilModJunk.

 This information worked great and I was able to finish the project to the desired level. Now I am required to put this filemaker database through the IWP publishing of a filemaker advanced server for Group authentication, probably a later post. Now when I put in a duplicate week through the browser,  I get stuck at validation errors on commit and cannot get out unless I cancel with the menu bar cancel button.

 Could someone point me in the right direction as to what type of field validation script I should use, or how I should go about making this ready for Instant Web Publishing. Any pointers would be appreciated.