Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Locking down a specific field


This topic is 4460 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

I've read a couple of posts about locking down specific records, what I need to do is lock down a specific field so that it cannot be edited. I figured out HOW to do this and it works fine, using a couple of scripts.

My issue is: When I set the field up and select none of the field entry options, this allows no editing of the field. My scripts add data/information into the field without issue. The problem is once you uncheck all of the field entry options, it eliminates the vertical scroll bar so we can not see the information in the field once it fills the window on the layout.

Attached is a sample file that hopefully illustrates my situation. Two fields Note_Entry and Note_View. User types into Note_Entry then clicks in Save and the data moves from Note_Entry to Note_View.

I need to set up Note_View so that someone cannot go back and change add or delete a previous note.

Thanks.

Tried to attach my sample DB, but was denied:

Stripped for testing Fixed.fmp12

You aren't permitted to upload this kind of file

Posted

You need to ZIP your file to attach it

and witht out seeing your database, what I do is create a lock field and for the field i want to lock,

under validation by calc..

isempty(lockfield)

This topic is 4460 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.