Sort by account name when opened

[Bill_misc_IT]

I have a database that multiple employees use to submit their expense reports. I'm trying to write script to only show the records for the employee who logs in:

Get (Account Name)

Find records: name=Account Name

Not sure the best way to do this, so an employee doesn't see everyone else's expenses?

Thx

[Highbury]

Hi,

How about setting the 'find' script to run at startup? (File/File Options/then the Open/Close tab where you can set any script to run at startup or closedown).

[Bill_misc_IT]

That's what I'm trying to do, but can't figure our how to make a find request that searches based on get function? Here's my example:

Perform Find[Restore]

Find records when:

Employee name: Get(Account Name)

How do I insert functions or calculations in the find request criteria? It only appears to allow fixed values or boolean symbols?

[mr_vodka]

Enter Find Mode []

Set Field [name; Get(AccountName)]

Perform Find []

[bcooney]

To answer your question about Find, you can set fields in find mode by scripting (pseudo-code)

Go to Layout Find

Enter Find Mode

Set Field or Fields

Perform Find

Go to layout List View

However, protecting one user from seeing a record created or "belonging" to another user is typically handled by privilege set record access. For example, users can view a record if the AccountCreated field = Get (AccountName). This supposes that you have the AccountCreated field set to auotenter the Get(AccountName).

[Bill_misc_IT]

Thanks