3 Replies Latest reply on May 1, 2014 6:44 AM by donnyl

    Prevent record editing when a field matches X value?

    donnyl

      Is it possible to prevent record editing when a field matches X value? For instance, a field named "Status". When the Status field contains "completed" is it possible to prevent editiing ANY field in that record from that point forward? For some reason, having a hard time figuring this one out.

        • 1. Re: Prevent record editing when a field matches X value?
          coherentkris

          check security settings in manage>>security>>privelege sets>>edit privelege set>>records>>custom priveleges>>edit>>limited. That is where you can restrict editing of a record based on the result of a calculation. You can also perform restriction using interface elements i.e hiding controls from users or performing calculated validations using script triggers and such but their are important issues to consider when using interface based pseudo security devices/methods.

          1 of 1 people found this helpful
          • 2. Re: Prevent record editing when a field matches X value?
            rrrichie

            Different solutions possible :-)

             

            One way is in the field definition enter an validation formula in the validation tab.  For the user not so nice though cause he first can edit and then when leaving the field the error is shown.  You can display a custom message though.

             

            Another is a layout trigger script.  In layout mode/layout settings you can attach a script to fire / trigger on different events.  You could for example use the keystroke one.  Call a script which checks the status field and return a false or true if editing is allowed.

             

            Yet another is via privileges.  Custom Privileges, there you can select the table and with the limited option enter a calculation based on the status field.

            1 of 1 people found this helpful
            • 3. Re: Prevent record editing when a field matches X value?
              donnyl

              Thanks guys. I'll check these out. Appreciate the direction.