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.

Edit but not Duplicate Record

Featured Replies

I have FMP Advanced 12.0,  Is it possible to set up a user account as Data Entry but without the ability of duplicating a record or copying a record.

I have FMP Advanced 12.0,  Is it possible to set up a user account as Data Entry but without the ability of duplicating a record or copying a record.

 

If you deny them the privilege to create records, they won't be able to duplicate records either. If you do want them to create new records, let them do this through a script. Not sure what you mean by "copying a record".

 

 

 

Leverage custom menus and overwrite the records>duplicate menu item with a script of your own.

http://www.filemaker.com/help/html/fmpa_custom.23.15.html

 

Custom menus are not a security measure.

My mistake for not keying in on "user account" part of the op

  • Author

Thank you for all the responses.  The problem I am having is that,  in order to save time,  users will sometimes copy a record (ctrl-D)  then just change some data fields and forget to change other data fields that should also be changed.  It causes problems internally in our office.  I guess I would like to remove access to the ctrl-d hot key and the top menu, records> duplicate record  for certain users.  Is this even possible?  

There are (at least) two things you could do:

 

1. Use auto-enters to clear the "other data fields" when a new record is created, and field validation to prevent these fields being empty. Or, if these fields need to be changed (as in being unique), just validate them as such.

 

2. Use custom menus to remove access to the Duplicate record command, as suggested earlier by Kris.

 

 

Note that neither of these is a security measure, but it sounds like what you're really after is data integrity - and field validation is often the best way to enforce it.

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.