Good evening everyone.
Today question should be simple enough.
I need to navigate a user to a table, find all the records his his name on it, but then bring him to a specific record based on a variable.
Right now I bring him to the specific record (based on the variable). But I want to bring him to ALL his record and then move him to the specific record within original creation order. That way he can scroll backwards and forward without having to do a new find each time.
My thought is to bring him to found set and then loop through the record until he reaches the right one, but this could easily be several hundred records so I wanted to asked if there was a better solution.
Here's one method:
- create a summary field type List of: for the field that identifies the desired record.
- after you've found the user's records, use Go to Record [ by calculation ], using this formula:
Let ( [
theList = YourTable::theNewSummaryField ;
theRecord = Char(13) & $yourVariable & Char(13) ;
thePosition = Position ( Char(13) & theList & Char(13) ; theRecord ; 1 ; 1 )
] ;
ValueCount ( Left ( theList ; thePosition ) )
)
If you like, replace Char(13) with the pilcrow (CR symbol) from the operator list.