AnsweredAssumed Answered

Find Record Number by Field Data/sort order.

Question asked by KerryMiller on Aug 11, 2015
Latest reply on Aug 11, 2015 by philmodjunk


Find Record Number by Field Data/sort order.


I'm looking to add a conditional Go To Record script that is based on field data.

For this I have a few things set up:

A global value of what our current Live "Season" is (a date number calculated by converting an abstract date into a numerical one)

All Records have a field with the Release Season (similar method, abstract date converted to numerical date)

I'm looking to find the lowest Record Number for a given season based on the current sort order.

I know how it would work, but my scripting skills are not the best:

Sort Records

Get lowest Record Number whose Release Season field matches Live Season Global Value.