Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

How can I go to a portal row based on the content of one of it's fields?


This topic is 4551 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I have a portal that contains a list of unique dates. How can I create a script that scrolls to the portal row that contain the current date? Can I do this without a looping script?

Posted

You may be able to calculate the portal row number as =

Let ( [

indexValues = List ( Child::Datefield ) ;

searchValue = Get ( CurentDate )

] ;

ValueCount ( Left ( indexValues ; Position ( ¶ & indexValues & ¶ ; ¶ & searchValue & ¶ ; 1 ; 1 ) ) )

)

Note that this is a text comparison; if the date is not entered in exactly the same format as used by the file (including leading zeros), it will fail.

It is also assumed that the portal does not have a sort order of its own.

This topic is 4551 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.