Going to Current Date in portal...

[Protour Travel]

Hi everyone,

 

I am writing an opening script which will go to a certain tab control which contains a portal. This portal contains dates from 2+ years ago and also dates until the end of this year.

 

What I want to do is upon opening, go to the portal row that contains the current date as the first portal row. I have played around with calculations to no avail.

 

I have tried setting a $CurrentDate variable upon starting the script and then setting that field in the portal but i get a dialog box that says "go to record [734976] out of 10.

When I press enter I get an error that the number is too high. When I change that number to 10 or less, it carries me to a different portal in a different tab in the same layout.

 

I am using Object Names for the tabs and portals.

[David Jondreau]

One way would be to use a custom function, like Bruce Robertson's PositionValue() to find the portal row number to navigate to. Something like:

 

Set Variable [ $portal.row ; PositionValue ( List ( relatedTable::Dates ) ; Get ( CurrentDate ) ) ]

Go to Portal Row[ $portal.row ]

 

Assuming you're sorting on the relationship level and not the portal level.