3 Replies Latest reply on Jun 9, 2017 12:28 AM by user28271

Find a series and then navigating to a specific record

user28271 Jun 8, 2017 5:01 PM

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.

1. Re: Find a series and then navigating to a specific record

erolst Jun 8, 2017 5:24 PM (in response to user28271)

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.
Like Show 0 Likes(0)

Actions
2. Re: Find a series and then navigating to a specific record

philmodjunk Jun 8, 2017 8:42 PM (in response to user28271)

You might also use Go To Related Records with a self join that uses a global field to jump to a specific record within your found set.
Like Show 0 Likes(0)

Actions
3. Re: Find a series and then navigating to a specific record

user28271 Jun 9, 2017 12:28 AM (in response to philmodjunk)

thanks
Like Show 0 Likes(0)

Actions

Go to original post