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.
Thanks for the idea. I¹ve started the process, and have a login table with
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.
Gordon Database Consulting, LLC
Member, Filemaker Business Alliance
13418 Saddle Hill Drive
Little Rock, Arkansas 72212
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.