Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Locking down a specific field

Featured Replies

  • Newbies

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

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)

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

Create an account or sign in to comment

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.