emptyfill with a formula isnt working as expected.
the formula is evaluated for the current (ie, highlighted) record, then that value is is used to fill every empty cell in the designated field.
this is the code:
field modelyear
emptyfill str(val(added) - 1)
modelyear and added are both text fields where the values represent years.
if the value for added in the current record is ‘2012’, all empty cells in the modelyear field are filled with ‘2011’.
if the value for added in the current record is ‘2011’, all empty cells in the modelyear field are filled with ‘2010’.
the problem is definitely with emptyfill, not with str( or val(, as formulafill with the same formula works as expected.