2 Replies Latest reply on Jan 15, 2015 7:25 AM by PavelGC

    Creating a formula



      Creating a formula



      I want to create a formula or a scritp to prevent users to change the data in some fields of my table. For example:

      I have the following fields in my table:

      Name: (empty)            List number: (empty)     Number of Essays: (empty)

      Then a new record (users can create as many records as they need to) is created in my database with the following information

      Name: John Doe         List Number: 10             Number of Essays: 4

      Users can change change the Number of Essays field any time they want in the future. However, I don't want them to change the neither the Name nor the List Number fields once the information is entered for the first time. Can anyone help me with this, please?

        • 1. Re: Creating a formula

          Unless you move the Number of Essays field into its own table linked to your current table in a one to one relationship, I don't see a way for a "formula" to control access to just two of these three fields. You can then use a formula in a lock expression that controls access to the entire record where the name and list number data is recorded.

          Here's a simple interface design method you might use instead:

          Put the Name and List Number fields on your layout, but set their behavior options in the Inspector's data tab to deny Browse mode access. Then have the user click a button to create a new record. This record can open a custom dialog for the name and list number of the new record. This allows the user to click the button to create new records, but eliminates their ability to edit the name and list number fields on this particular layout for an existing record.

          • 2. Re: Creating a formula

            Thanks a lot. I'll see if I am able to do it. Thanks again