Jump to content

Calc for validating unique field?


This topic is 5786 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I checked the 'unique value' under validation tab to prevent user from recreating duplicates, but i believe the error buttons (Revert, Yes, No) that appear when validationg fails are very unuser-friendly. Some of the users are limited to be unable to delete or edit records, only add. I can education them, but accord to murphy's law; "Whatever can go wrong, will go wrong"

Thus is there any calc that can be use to mimic this function?

Link to comment
Share on other sites

FileMaker really could use a "Unique( FieldName ; TableName )" function -- hint hint to those that don't read the forums ;)

On that topic, can't really be helped, unless you MAYBE stored those values in a related table and then using some sort of plugin executed a script that uses the IsEmpty( relatedtable ) function (related via a global that gets set) and then act on the results of that. Kind of annoying, but if you can work it out... yay.

Plug-in that might help: DoScript by myFM Butler -- Freeware

Link to comment
Share on other sites

This topic is 5786 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.