Solved

Going directly to that user's record after logging in

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Toggle button 2 141
Advertising design for my own Purpose 5 64
filemaker security information 1 33
Job Transaction Field totals 6 40
Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
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…
This video discusses moving either the default database or any database to a new volume.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

708 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

12 Experts available now in Live!

Get 1:1 Help Now