Solved

Going directly to that user's record after logging in

Posted on 2011-09-21
3
363 Views
Last Modified: 2012-05-12
I have a simple one although it is causing me headaches.  I have a Human Resources Filemaker database that user's log on to through External LDAP synching.  I would like the system to take them directly to their record so they don't have to go to FIND type in their Last name or ID or something in their record and perform a find for their record.  

Please advise.
0
Comment
Question by:SFSDIT
3 Comments
 
LVL 24

Accepted Solution

by:
Will Loving earned 200 total points
ID: 36578214
Assuming that the login name is recorded somewhere in their user record or can be matched against it, a short script that runs on startup can probably do what you want. It might look something like this:

Enter Find Mode []
Set Field [ AccountName ; Get ( AccountName ) ]
Perform Find []
If [ Get ( FoundCount ) = 0 ]
   Custom Dialog [ "User not recognized." ; "OK" ]
End If

The Get ( AccountName ) function would normally get the Account name that the user logged in under. I don't have an LDAP server to test if it would still work in that circumstance but it might. Also, in  the above script, I assumed the presence of a field called "AccountName" which you would perform the Find on. If the user is logging in with their Last Name or an ID, then you might use that instead. However you do it, you need to have a field in the FM database that corresponds to the account they are logging in under.

You could also just begin the script with an Input dialog asking for their name and then search the name field, automating the process they are doing manually. You would run the dialog, capture the name to a field and then continue one with Enter Find Mode and use the entered value instead of Get ( AccountName ).
0
 
LVL 9

Assisted Solution

by:jvaldes
jvaldes earned 50 total points
ID: 36578537
You may want to use the script to set the value of a global "g_CurrentUsername" and use that value setting in your application design to always create user specific environment where the user could set user specific parameters "Environmental Parameters" and include other settings in the startup script.

In order to run the script automatically at login select File>>File Options choose Open/Close and check "Preform Script" and choose the script
0
 

Author Closing Comment

by:SFSDIT
ID: 36584248
Great, thanks a bunch!!  My users are now happy they don't have to search.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now