Limit Field Modification in Data Entry

Posted on 2006-04-19
Last Modified: 2010-04-27
I'm working on a tool testing and certification database where I have a keyboard wedge importing data recieved from a tester to the wedge, and then to the database.

At the start, the fields are obviously empty and I have the tabs set up to go from one reading to the next and the wedge with automaticly insert a {TAB} to move the fields along.

Is there a way to hinder a user from changing any numbers once a result is entered?
Question by:Cruizectrl
    LVL 19

    Accepted Solution

    FileMaker can't tell whether it's the wedge or a real person doing the typing, so basically all you can do is allow data to be entered once, but not modified once it has been entered initially.

    Assuming FM7 or later, you can accomplish this by creating a custom privilege set, and giving the user rights to create records, but restrict their ability to edit records. To do this, you create a privilege set that gives the user the rights they need for normal operation, then specify Custom Privileges in the Record entry under Data Access and Design.
    Then, specify the table you want to restrict editing for, and specify that they can create, but not delete records. Then, for Edit, specify Limited, and enter a boolean expression that evaluates whether or not the required fields are blank. For example, if I have three fields, AAA, BBB, and CCC, I would enter something like this as my formula:
      isempty(AAA) and isempty(BBB) and isempty(CCC)

    This will allow data to be entered in the record as long as all three of those fields are blank. Once it's committed, if even one of those fields isn't blank anymore, further editing is then prevented.

    If you have an older FileMaker version, you're probably looking at a lot more work to do something like this.

    LVL 1

    Author Comment

    Tried that.  For some reason it doesn't work as swift as I would like it too.  I can still go back to a previously entered field and change the data.  But after a click on the outside to allow the record to commit the changes.  THEN the block begins.  But not just for the entered fields,  but ALL of them.  But thats okay.  I have another fields the runs % calculations and then returns a PASS/FAIL to another fields.  All I had to do is make the field reject changes and block the fields to be entered while browsing.  Close to what I need.
    LVL 28

    Assisted Solution

    there are plenty of ways to do this, but fm post validation is a way far from perfect since clicking outside triggers it.
    I am personnaly still using my old fm4 method (I used that for barcodes entry, close to yr stuff).
    I create as many globals field as I need to get from my barcode reader.
    I create a specific layout for these and have the user to enter all of them, then validate the window (you need an extra barcode to trigger the script button) with a script which checks all globals fields contents then create the new record with them if all ok, otherwise loops back and ask the user to correct.
    why's that? because free entry is bad, but unmodifiable is almost the same with these manuels operations where you always expect errors. so you need a way to check data before creating the record and even allow to give up with no record creation, which filemaker hardy does.
    a major improvement would be to be able to do it with variables instead of global fields, but that maybe v9?!

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    FM Exporting Pictures In Container 1 897
    FM 13 Get Field Name Comments 1 245
    Filemaker xsl help please 3 53
    filemaker security 1 369
    Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
    Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now