auto-numbering lists and calculations returning questions marks...thoughts?
I use filemaker to generate scan lists for film projects and I recently encountered an error.
Normally, when I have my found set the first item on the list gets numbered 001 and then the rest follow suit, (002, 003) via the following formulation called "edl_work_EVENT_NUMBER_FORMATTED
Right ( 1000+ (If (Get(RecordNumber)=1; "1" ; GetNthRecord (edl_work_EVENT_NUMBER_FORMATTED;Get (RecordNumber)-1)+1)) ; 3 )
storage options are set to recalculate as needed.
Anyway, about 100 or so events into a list like this, I suddenly start getting question marks instead of numbers.
Any thoughts as to why?
As always, appreciate the great help this forum affords and am a fan of PhilModJunk especially.