Hey All,

 

At my company, we ship on twice weekly schedule. Therefore we usually know our shipping dates well in advance. Our shipping guy inputs the shipping dates into a FileMaker table so that the salesmen can assign their shipments to a particular Shipping ID, to ship their sale tomorrow or, if they like, next week or next month. So basically the "Shipping ID" table is 2 fields, shipDate and shipID. We've got past, present, and future dates in there. 

 

On a layout used by the shipping dept, I have a portal which lists all the ship dates in descending order by date. To see what's shipping for a particular Ship ID, the shipping guy scrolls to the ship date he's interested in and clicks on it in the portal. The shipping IDs closest to the current date are highlighted in yellow so they stand out. 

 

What I'd like to do is save the shipping guy a second or two by scrolling the portal to the active Shipping ID when he enters the layout... so... how would I go about figuring out which portal row to go to in the script step? I can't think of any way that doesn't involve switching layout and doing finds and sorts... Ideally I'd like the OnLayoutEnter triggered script to quickly locate the row and go to it without needing to leave the layout. Any ideas?

 

Thanks

 

 

Figured it out, here's how I did it:

I made sure the relationship sort matched the portal sort. I used the List() function to load the list of shipping dates into a variable. I looped the List with GetValue to find the date closest to CurrentDate, then I just used my list pointer as my row number to go to, added a couple of rows so it'll scroll my desired record to the middle of the portal instead of it only showing on the last row.