Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

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

Recommended Posts

Posted

Hi

Hope I'm in the right forum - could be a script question. So sorry if that's the case.

I have a number field with the validation set to UNIQUE VALUE. However I do have instances where the data does not have to be unique.

Specifically I need it to be OK if "CLASS II" is entered.

( Which I have entered automatically through a calculation in the number fields options, [if ( Job Type = "Class II"; "CLASS II" ; "" )] )

During a script, when the "CLASS II" is auto entered the dialog box comes up and asks if I want to allow this or not since it is supposed to be unique.

Question: Is there a way to have this querie answered YES (allow)automatically in the script or through a modification of my calculation?

Thanks for the time!

Posted

Yes, you can.

Add this step at the end of your script:

Commit Records/Requests [ Skip data entry validation ; No dialog ]

This topic is 5779 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
×
×
  • Create New...

Important Information

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