Jump to content

Welcome the ORIGINAL FileMaker Community

Take a moment to join us, no noise, all FileMaker...We Promise


Access privelege to a single field to be edited once

Recommended Posts


Hello there! First post and already asking for help...


Just started learning FM and so far I am liking the whole system a lot, I have a eletronic store and repair shop and I am thinkering on bulding a system where my clients (other stores) can access the db of the eletronics they have with us to be repaired, and aprove (or not) the repair.


I built up the whole DB and I am testing the program to learn it, but I got stuck at it. I am trying to make an account that have very limited access, it can read most of the fields, use specific layouts and it must be able to edit ONE field only. I have many fields with the Service Order, Costumer Name, Date, Serial of the gadget etc, all those should be read only by the costumer, the one I want to be edited by him is:


Status (with a dropdown) = waiting approval | approved | not approved


What I need is to the costumer to log in, access the db, search for that service order, then he can select to approve, but only once, so when it gets approved he can not undo it.


Maybe the best option would be add a button with "approve it?" and submit? Or is it possible to make a dropdown, to select the right option and then submit?


All help and suggestions appreciated, thank you very much!

Share this post

Link to post
Share on other sites

1) Give the limited users data entry privileges ONLY in Upper Menu ---> "File" ---> "Manage" ---> "Security"


2) In the Database Dictionary "Edit Layout" ---> "Manage" ---> "Database" create a calculated copy of each field on your FORM except the ONE FIELD you want the USER to modify/choose a value.



-LastName [text field]

-cLastName [calculated field; value = Table::LastName]



3) Then DUPLICATE the form layout. Name it something you can easily remember since this will be the FORM the USER goes to to change the one field. On this form change each field that you don't want the user to be able to change from the original TEXT FIELD to the CALCUATED version of this field. Remember that calculated fields CANNOT be changed.


4) You might be tempted to uncheck the box "Enter Field in Browse Mode" in Inspector. Even if you do this it is possible to be able for a user to enter these fields (unintentionally). This happens if a script innocently is run that uses the "Go to Field [FieldName]" or "Go to Next Field" steps that weren't intended for the user to use. In the calculated fields a user can enter the field but changes cannot be made. In cases like this (using a calc field to prevent changes) I usually also prevent the user from entering the field.


EDIT: After the user selects the option in the STATUS field, he/she will be unable to make any changes since their security level will NOT allow them to make any changes to the value.

Edited by Techphan

Share this post

Link to post
Share on other sites

Thank you! Will work on it tonight!

Share this post

Link to post
Share on other sites
This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use