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.

Double feature: external record access calc that calls layout // importing a custom menu

Featured Replies

The issues with UI/data separation just keep popping up as I go along!

In my integrated file I had privileges set for record access (deletion in particular) that referred to the layout the user was in (layout that is now in the UI file). With separated UI/data, the privileges calling on layout names or layout tables are no longer protecting my records.

For example:

--> I do not want to prevent deletion entirely in that layout, and I do not want to permit it entirely either.

--> I want to permit deletion when child_table::field <>"√"

--> I want to allow deletion of records (including child records that are √) when the parent related record is deleted.

So my "delete" privilege was set to limit calc: NOT(get(layoutname)="layouts of child table" and child_table::field= "√")

I guess the calls to get(layoutname) now refer to the external data file's layouts (which are hidden). If I force the external file to go to a layout by the same name, then it works again... very convoluted and a route I'd rather not employ.

If using layout names is not best practice for record privileges, does anyone know a better way to achieve this type of record access level -- bearing in mind that I don't have fmp advanced so I can't create custom menus? (I would just disable delete and create, and replace all while I'm at it). I am limited to fmp 9 as that is what our office is equipped with.

However - if it comes to that (fmp advanced)-- if I can find someone who has it, could I just create the menu and then return to fmp 9 (not advanced) to pursue the work?

I'd be most grateful for any pointers. Thanks!

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.