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.

Featured Replies

  • Newbies

I am setting up a training database for my department. I need for employees to be able to log in and look at their information without being able to view others' information. I want them to be able to view their training records without being able to edit them, but I do want them to be able to edit the demographic info.

Any help would be greatly appreciated.

When you setup a Privilege Set, there is an option under the Records popup menu for Custom Privileges. In the resulting dialog, you can setup on a table by table basis whether you want people to view, edit or delete by calculation. When you popup the menu under these options, you will see a choice called Limited. The resulting dialog will be a calculation dialog where you can insert any formula to limit whether someone can see the record or not. My suggestion is to couple the calculation with an auto-enter of the Account Name. In other words, each record will contain the Account Name of the person who created the record. You can compare this field with the current account name to determine if someone can view, edit or delete the record. For example, your formula might look like this:

MYTABLE::account_name_create = Get(AccountName)

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.