Jump to content

What privileges are needed to override field data validation?


eljefejb
 Share

Recommended Posts

I had a user today who couldn't exit a new record (created on accident) because the Title field is set to require a value.  When I log in with the Full Access privilege set, I am given the option to revert the record or allow the field to remain blank.  If logging in with the user privilege set, those options are not given. 

I thought that the missing revert option was probably because the user privileges didn't include the ability to delete records.  I did some research and found that I could allow delete if the calculation Get (RecordOpenState) = 1 evaluates to true, meaning that it's a new record that hasn't been committed.  So now the delete button will allow the user to delete the new record. However, the "Revert Record" button still does not appear in the data validation error dialog, and I can't find anything that controls whether or not the user should be allowed to override the data validation during entry.

Anybody know?

Link to comment
Share on other sites

20 minutes ago, eljefejb said:

I thought that the missing revert option was probably because the user privileges didn't include the ability to delete records.

No. Reverting a record is not the same as deleting a record. Users with permission to create and/or edit records also have permission to revert - even if they do not have permission to delete.

 

21 minutes ago, eljefejb said:

I can't find anything that controls whether or not the user should be allowed to override the data validation during entry.

image.png.66bb8b763fbb0f500cf1b171219daaf6.png

 

Link to comment
Share on other sites

Thanks, comment!

The Users privilege set already had create and edit privileges, so it must be the checkbox that shows the "Revert" option.  Not sure how I didn't see that.  Tired eyes, I guess.  😴

The problem is that I want to allow reverting of a new record, but I don't want to allow users to override the data validation.  It seems to be all or nothing.  I'm tinkering with scripts to try to accomplish it.  So far, the best I've come up with is something like like this, attached to the layout trigger OnRecordCommit:

If [Get (RecordOpenState) = 1]
  If [Title = "" or Created_By = "" or Reason = ""]
    Show Custom Dialog["Values Required"; "Go back or Cancel Record?"]
    
    If [Get (LastMessageChoice) = 2]
      Revert Record/Request [With dialog: Off]
      Go to Layout ["View Details"; Animation: None]
    Else
      Exit Script [Text Result: True]
    End If
  End If
End If

I put a red "Cancel New Record" button on the layout, hidden unless Get (RecordOpenState) = 1 but the script fires any time the user clicks outside of a field, so it's really just a dummy target.  Not the most elegant solution, but it seems to work okay.

Thanks again for your help!

Link to comment
Share on other sites

I'm a dunce.  I'll blame it on the triple-digit heat and smoke in our area making me not see the obvious.  😄

In my defense, someone else created this particular file long before me, and I don't work with FileMaker all the time, so sometimes I forget all the settings. 

Thanks for getting me back on the right track!  Things are working nicely, now.

Link to comment
Share on other sites

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

  • Similar Content

    • By bgscott
      I have a field, item ID, set to auto enter a serial number and validation set to not empty and unique.  If the serial number entered is not unique I do not get an error message when exiting the item ID field.  If I turn off auto enter serial number and manually enter a non unique item ID, I do get an error message when I exit the field.
      With auto enter a serial number turned on I only get the non unique error message when I commit the record.  I would like to get the error message when exiting the field when auto enter a serial number is turned on
      Any suggestions?
    • By Sinky
      Hi people!
      I have a field which validation is set to Always, Allow user to override during data entry unchecked, unique value, custom message checked.
      When validation fails the message box offers two options: revert record and OK.
      Is there a way to trigger particular script if I choose OK?
      or is there a way to get the message with only one option (revert record) to choose?
      Much obliged!
       
    • By lutfishah
      Dear All,
      I am trying to put a conditional formatting validation which turns Red when the value is entered wrong. Basically all my tries have failed so I would like your help here.
      The criteria of entering a value is 
      xxxx-xxxx-xxxx-xxxx
      1111-2222-3333-4444
      1. Length of value is  = 19     OR      this should be a 16 digit number, in groups of 4 separated with dashes
      2. Non-Digits characters are not valid.
      Please could you help me with this and I will really appreciate. 
      Many thanks
      Regards
      Lutfi
       
    • By gwjo
      I have a database which I want to deploy using FMS16 webdirect. It has several value lists which form dropdown lists. One of these has a lot of text in the value list items and in the webd view these extend beyond the edges of the screen. Is there any way of formatting the dropdown list so that the value list items wrap into a specified size text box?
      Many thanks for any input.
      George
    • By eljefejb
      Has anyone found a way to center text within a field when using WebDirect?  The only workaround I have seen is to add a padding value to each field.  Definitely not clean or ideal.
×
×
  • Create New...

Important Information

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