Better Script for Go To Portal Row
Hi. I'm trying to make an alphabet picker where you can click on a letter of the alphabet and go to the frist record in a portal that starts with that record. I've got something that works, but 1) It's EXTREMELY slow and 2) it's not smart enough to go to the previous letter in the alphabet if there are no records that start with the letter the user clicks on. Here's what I've got. Is this idea even feasible? The table has over 7,000 records in it.
Go to Object [Object Name: "Picker Portal"] /* Portal Picker is the name of the portal that shows all the records */
Go to Portal Row [Select; First]
Exit Loop If [Left(com_COMPANIES_filtered:name; 1) = Get(ScriptParameter)} */ScriptParameter is whatever letter the user clicks on */
Got to Portal Row [Select; Next; Exit after last]
If [Left(com_COMPANIES_filtered:name; 1) -/= (does not) Get(ScriptParameter)]
Go to Portal Row [First]
P.S. Is there a way to copy scripts to paste here without having to copy them by hand?