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.

Record level access for multiple users

Featured Replies

I have a query regarding record level access on the web. I have a database in which I would like selected records open to browsing by all users, while the remaining records are viewable only by around 500 users, each with unique IDs and passwords (in the Web Security databases). Any ideas on how this can be achieved?

selected records open to browsing by all users-

mark those records by use of a field and then use that criteria to fitler them in the serch.

- mark each record (eg. field [VisibleRecord] (1,0) 1- being visible/browsable to all user

OR when a user loggs in

- mark each user record as "guest" or "admin" or "something"

- use the FMP-IF statement when constructing form for a serach based on either "user rights" or "record visibility"

(eg. [FMP-If: UserLevel.eq. admin]....construct the form

FMP-Else .....

or on the results page exclude/include the records based on "RecordVisible" field

All the best!

Create an account or sign in to comment

Important Information

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

Account

Navigation

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.