June 8, 201213 yr 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?
June 8, 201213 yr 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.
Create an account or sign in to comment