troubleshooting Question

Filemaker, Filemaker Pro , 8.5

Avatar of afbaer
afbaer asked on
FileMaker Pro
8 Comments1 Solution958 ViewsLast Modified:
I have a layout which lists details of work shifts in date order. The list is continuously growing and rather than scroll down to the current date each time I open the layout, I want it to open it as close to today as possible. I first find records which are marked as "Fillin" shifts and that occur before todays date. I then count those, perform a new find to include all "Fillin" records, sort them by date and go to the found count record. The problem is that as I add more and more records, the layout opens further and further ahead of todays date. Can anyone tell me why, or suggest a better way to achieve my goal?

I have the following scrip:
New Window [Name: "Shifts" Height etc]
Go To Layout ["Fillins" (Shifts)]
Show/Hide Status Area
Perform Find [Specified Find Requests: Find Records; Criteria: Shifts::Fillin: "=1"
   Find Records; Criteria: Shifts::StartDate: "<=//"]
Set Variable [$Count; Value:Get(FoundCount)]
Show All Records
Peform Find [Specified Find Requests: Find Records; Criteria: Shifts::Fillin: "=1"]
Sort Records [Specified Sort Order: Shifts::StartDate; ascending
   Shifts::Customer; Ascending]
   [Restore; No dialog]
Go to Record/Request/Page [$Count]
   [No dialog]

 I am working in a Windows XP environment.

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 8 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros