Skip 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.

Lock a entire record with a script

Featured Replies

I to all!

I need some expert help!

I have a database, and i need to lock some records, (entire records), with a script,geting acess to the record again with password.

Thanks in advance for your help!

if the record is to be seen only by certain users you can set the accounts to allow only named users/those who meet certain cryteria.

more info on exactly what you need please

  • Author

Hi! The records are to be made by all users, but after that, we want to lock them to prevent accidental alterations. Thanks again for the help!

It would appear from your last post that there are only two views of a record - the new record entry view and the existing record data view.

Rather than 'lock' the records by script, why not just use the script to direct the user who wishes to view a record to a layout where the fields are not editable.

Phil

ah!

ok if we're going for a create then lock thats simple!

2 layouts

1 for creation / editing

1 for viewing.

layouts -> duplicate

then select all fields and change 'behaviour', untick the 'enter in browse mode box'

this will prevent editing on this layout, but you can still go to your create / edit page to do, well... what it says on the tin, create & edit.

that what you were after?

if your still not clear say so + ill do screenshots.

  • Author

Hi again!

We still with the same problem!

My database, is a db with 6 differents layouts, where we put information about samples. Some of that layouts have the same information, and they are to print like a document. So, when we receive a sample, one of us made a new record, where we put the information about that sample. After that, we need to introduce data in that record 3 or 4 times. It is the moment i need to lock the record to prevent acidental changes. Thats my big problem!

Thanks again in advance for any help, and sorry my confuse english!

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

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.