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:
Get lowest Record Number whose Release Season field matches Live Season Global Value.