Jump to content
Sign in to follow this  
dscott23

Locking down a specific field

Recommended Posts

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

Share this post


Link to post
Share on other sites

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)

Share this post


Link to post
Share on other sites

You should be using the file's security settings in order to deny users' editing privileges for a field.

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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