5 Replies Latest reply on May 2, 2011 11:20 AM by philmodjunk

    IWP User Logins



      IWP User Logins


      I am working on a database that will require IWP user to login to a portion of the database. The database is intended to allow attendees make appointments with vendors at a trade-show. Vendors would also be able to login and view their appointments.

      Currently, I have two tables; a vendors table and an attendees table. Each table has an email, which is the login username, and a password. The vendor or attendees login table is related to both the attendees and vendors tables through the email field. A script checks that the password matches; if so, the corresponding layout is loaded.

      Am I on the right track with this, or should I be using the usernames and passwords built into FileMaker?

        • 1. Re: IWP User Logins

          You'll have much better security if you use FileMaker's built in security rather than trying to create your own. You can use functions like Get ( AccountName ) to identify the user in your scripts.

          • 2. Re: IWP User Logins

            I've made a duplicate file to try this out. The user needs to be able to select a LOGIN button on the home screen, which triggers the login script. Currently, the login scripts is :

            ^ Re-Login []

            ^ Go to Layout ["Vendors" (Vendors)]

            ^ Go to Record/Request/Page [No dialog; Get ( AccountName ) = Vendors::BoothID]

            In the CREATE NEW USER script, the user name is set to the vendor's booth number, or  (Vendors::BoothID)

            Everything seems ok, but the script will not point the user to his/her record, it will direct the user to the first record in the found set, and not the record that adheres to the last line of the login script.

            • 3. Re: IWP User Logins

              Go To Record/Request/Page

              Is used to change the currrent record to be a different record in the current found set and you are specifying the record by it's position, not by any value in that record. You are basically saying: "go to the 1st record" or go to the 0 record (which doesn't exist). That's because your boolean expression, Get ( AccountName ) = Vendors::BoothID will either be true ( go to 1st record) or false ( go to the 0 record ) and it is evaluated that way before the Go To Record step is performed.

              Instead of using go to record, try performing a find for that user's record or records.

              Go to Layout ["Vendors" (Vendors)]
              Enter Find Mode [] //clear the pause check box
              Set Field [Vendors::BoothID ; Get ( AccountName ) ]
              Set ErrorCapture [on]
              Perform Find []

              This assumes that the account name is what is entered in BoothID--which may not be the best way to match vendors to their account names.


              • 4. Re: IWP User Logins

                Thanks again Phil!

                That seems to work very well.

                As for the Account name being the boothID, that is a placeholder until I get a little deeper into this mess.

                I am a one-man-band here so your help is much appreciated.

                We have had great success using FileMaker so far for a variety of uses. Most of my posts on here are related to the back-end system I now use to coordinate live event details, but we have also used FileMaker successfully for trade-show registration and it has served well even with 90 registration stations and 35k+ attendees in que.

                • 5. Re: IWP User Logins

                  As soon as possible, consider using a serial number ID for the BoothID and then a table where current account names are matched to the ID numbers. This will be much more flexible and allow account names to be changed without losing connctions to your vendor records.