Authentication to recordlist

[Bryan VonDeylen]

I am using the PHP Site Assistant to allow my users to browse and edit their forms. They are authenticated against an AD external account.

I can set the Authentication to direct the user to the SearchRecords.php page, and from there the user can type in their username to find the records they need, but I would like to automate this.

I have a field in FileMaker called StaffID which is their username when logging in. I would like them to authenticate and have the PHP script to a quick find on their username and take them either to recordlist.php or browserecord.php

Each of my users has only 1 record (this year), so browserecord.php would work. Next year though, each of my users will have 2 records, so recordlist.php would be a better solution.

Problem is, I am not sure where the 'auto find' commands should be placed. Do I put them in the Authentication.php page? FMView.php page? and where?

I tried putting

$findCommand =& $fm->newFindCommand('www_Goals');

$findCommand->addFindCriterion('StaffID', $userName);

$result = $findCommand->execute();

in the function checkStoredFile() area in the CGI class after else{ but that didn't work. It actually broke the solution.

Any guidance appreciated.