1 Reply Latest reply on Feb 4, 2015 3:06 PM by philmodjunk

    Locking or preventing old data from being modified in a tex field ("notes")  but still being able to...

    RobertT

      Summary

      Locking or preventing old data from being modified in a tex field ("notes")  but still being able to input new data

      Product

      FileMaker Pro

      Version

      12

      Operating system version

      Mac

      Description of the issue

      I working to design a medical database. using Filemaker PRO version 12.  I've created a portal for medical record notes along with a time stamp and user that inputed.  My difficulty is figuring out how to define a calculation or way to prevent in the "notes"  field to prevent previous modification or deletion, but to be able to input new notes at a current or later date.

      PS:  I am new at the program if you have any suggestions on best videos/books/software would be great
      Thanks

      Robert

      Expected result

      Ive learned about scripts on exit, but cannot figure what steps.  Also I learned about admin security features.