Solved

Going directly to that user's record after logging in

Posted on 2011-09-21
3
374 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 25

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
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…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

829 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