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.

Find using Global or Calculated fields

Featured Replies

Is there away to perform a Find Script in a database (or database table) using a global field or a calculated field that stores the result of the global field?

Well just do it, but it's going to be an unindexed search ...you have formulated your question too vaguely, I dare say that the reply largely depends on what you really want to achieve, is it a search in records with invoices due???

--sd

  • Author

I've a database that contains the names of a few users, each one of them has an ID a passe and fields that define some actions he or she can do (some of them run external programs). I've a password dialog in which the user must enter the ID & the password, (which I store in global fields). Then I would like to disply his/her related information on the screen in a dialog using the information from the fields after I localised him/her using the information I've in the global fields.

Why store the password in a global field when a correct login knows of a name to display with Get(UserName) which in an unstored field can act as primary key for a GTRR(SO) :) This is pretty easy to establish, but you can also restrict which records a user can access via the setting of the privileges.

--sd

  • Author

There are too many users who are going to use the application, on the same machines. I can never tell who will they be, the application has quit a few databases and it will be a tendious task to add and remove each time the Get(AccountName) or Get(userName). for that reason I've created a user's list with the names, passes etc..and I'm switching layouts by giving Consult or Rights rights. for that reason I would like to enter the application with a non FileMaker password (user ID/Name +a pass)

But, ehrmm....I dissagree!

http://www.filemaker.com/help/ScriptsRef-231.html

--sd

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.