I need to create a script that makes the current record the only record that appears in the found set.

I need this in order to be able to export a single record at a time, which will then be imported into another application.

Seems like creating a test field that looks up the current index #, then conducting a search on that field would work, but I can't seem to quite make it happen.

By the way, it must be a script since it will be executed in a runtime environment by other users.

Please help.

Thanks.

There are two ways of doing this:

Option 1. Create a self-join relationship based on a unique record ID and a global field. Get(RecordID) would work. Then set the global field to the record ID and Go to related record [show only related records].

Option 2. Add these steps to your script:

Show All Records

Omit Record

Show Omitted