writing a script that will find record based on a specific user

[LeStew]

Hi All~

My latest dilemma involves writing a script that will find all the records that were created by a specific user.

Basically it breaks down like this:

User logs into the database.

User wants to know what POs (records in this case) they've made and are still active (Y/N radio button).

User runs script that pulls in all records that match these criteria.

I can do all that. Easy with one user and one user ID. My issue is that in the script, how do I make a find step that will read the current user?

many thanks!

I've attached a file with the script I'm trying to make work. This is just a work file. NOT PRETTY!

POs test.fp7.zip

oh and since it's user specific I had to make each one password protected. the login and passwords are sb/sb once there you can make your own user/password

[bcooney]

Does each user have a separate account? If so, then all you need is a field in the PO "CreatedBy" that auto-enter the current user account name. With each PO "stamped," simply search for POs where CreatedBy = Get (AccountName).

[LeStew]

Does each user have a separate account? If so, then all you need is a field in the PO "CreatedBy" that auto-enter the current user account name. With each PO "stamped," simply search for POs where CreatedBy = Get (AccountName).

ok... I have that and it seems not to be working. Will the Get (AccountName) pull in the name of the account that is logged in? for example if the account SB is logged in and i run the script that Finds Records based on "POs::PO_Requester: [Get (AccountName)]"

Thanks again for all the help!

[LeStew]

in other words....

http://t.co/Dis6RFp

that's a screen shot of what I'm fighting.....

[dansmith65]

Before the Perform Find script step, set a variable with a calculation of Get( AccountName ). Then you can enter that variable name in the Criteria field in your screenshot.

[LeStew]

thanks again for the help!

But I think I'm missing a step

Here's what I have

http://twitpic.com/65resn

then

http://twitpic.com/65rg81

Please oh please tell me the errors of my filemaker ways!!!

[comment]

Does this work for you?

POs test2.zip

[LeStew]

YES!!!!

Thank YOU SO MUCH!!! i've been fighting with that all day! I now get beer.

[comment]

I now get beer.

Is that how it works?