3 Replies Latest reply on Aug 15, 2014 7:16 PM by Malcolm

    Password re-set

    user447

      I need the password to be changed after every 25 log-ins. How can I get FileMaker to tell me it's been opened by that user 25 times?

        • 1. Re: Password re-set
          Malcolm

          I need the password to be changed after every 25 log-ins.  How can I get FileMaker to tell me it's been opened by that user 25 times?

           

          Count them (obviously) and the way to do that is to keep track of them. One way is to make a user login table and create a new record in it every time a user logs in.  When they get to 25 show them the change password dialog. If that succeeds, delete the records to “reset” the count.

           

          Malcolm

          • 2. Re: Password re-set
            user447

            HI Malcolm,

            Thanks for the idea.  I¹ve started the process, and have a login table with

            three fields:

            Creation Date

            ID_PK

            Count  (calculation of Get(TotalRecordCount)

             

            but do I need a separate table for each person who logs on?  There are four

            people in the office.  They will each need to change their password, but at

            different times, right?

            Does the login table (s) need to be related to the main table?

            If yes, would I need a field to show which user is logged on?

            Can the script that tells them to create a new password be automatic?

            I¹m kind of fuzzy in this area......

             

            Thanks so much.

             

            -Jane

             

             

            --

            Jane Gordon

            Gordon Database Consulting, LLC

            Member, Filemaker Business Alliance

            13418 Saddle Hill Drive

            Little Rock, Arkansas  72212

            jgordon23@sbcglobal.net

            501.258.1966

            • 3. Re: Password re-set
              Malcolm

              You only need one table, have one field which is used to store the account name of the person who has logged in. You simply do a search on that field  using the current account name and see how many records are found.

               

              Malcolm