

Now, in Layout Mode, create a layout that will be called whenever the first window is opened. full name, email address, etc.) to store in a Users table. In this example, I’m only capturing the username and password to log in or create a new account but you could create an entire bank of fields if you needed to capture more user information (e.g.

I named these fields user_USERNAME and user_PASSWORD but feel free to use your own naming convention. You’ll need two global fields to capture the username and password data to be passed during the Re-Login or Create Account. Our security settings are all set up and we’re ready to start building our database. Now every time the file is opened, the restricted guest account will be used. Open the File Options for the FileMaker file, turn on the Log in using: option and select Guest Account. Click the OK button and close the Security Manager. Now, in the Security Manager, activate the Guest user account (if it isn’t already active) and assign it the Restricted Access Privilege Set we just created. Open the Security Manager and click the Advanced Settings button.ĭuplicate the Privilege Set and uncheck everything under Other Privileges except Disconnect user from server when idle and click the OK button. Let’s start with the Security Settings we’ll need.

Let’s have a look at what we’ll need to make this work. With the account, Re-Login, and Create Account script steps and a bit of script scaffolding, we can build a flexible login routine that can be themed to fit the UI for any solution, and also provide useful information and feedback to the user. It could be so much better!Īs with most FileMaker problems, the solution lies in FileMaker. For countless users, this sparse (and less helpful than it could be) dialog box is their first interaction with FileMaker…īut it doesn’t have to be. Unfortunately, you only get one chance to make a first impression. One of the (many) things I love about the Claris FileMaker platform is the wide array of tools it gives developers to build beautiful, useful user interfaces.
