I don't think you really need a calculation, you just need a found set on your layout for table::owner = get(accountname). I'd recommend doing an OnLayoutLoad script trigger that does a find for that.
Enter Find Mode
Set Field [ table::owner ; get(accountname) ]
go to record/request/page [ first ]
That simple script will find the right records for that user, sort them (EG by date of request), then go to the top of the screen.
Thank you very much. I see as walking through debugger that the Owner field is set to the AccountName.
The Owner field is a text field for the name of the user. In a related table, their corresponding email is listed.
The email is actually what is used for the AccountName, so the find is not registering. It populates the Owner field with the email for the signed in user. I want it to list the name of the User, and make the connection that this email account belongs to the owner name.
Do I need to pull the email field into my tasks screen in order for the find to work correctly?
Sorry, that was confusing.
So I want the find to be based on the Name of the user logged in, not their Username.
Let's say I am signed in as John Smith. How can I tell Filemaker that user account firstname.lastname@example.org belongs to John Smith? When John runs the script, the find is for his name (not email), and reveals his tasks.
You said there was a related table where you have the email stored? if so add a field for the 'Signed' in name. When the user logs in capture the Signed In Name in to a global variable $$SIN, ( just don't use 666 )
Use the $$SIN in the Find script or put it into a global field if you are filtering a portal.