Don’t know why but I found myself thinking ‘I wonder if in Filemaker the ‘Replace Field Contents’ with a calculated result would allow me to use a calculated result that calculates on each record separately’.
I’m sure some of you tried it but somehow it never occurred to me.
So say you have a field called date and it contains data in the format: “mm/dd” and you wanted to add ‘/14’ to all the records.
You could write a small script, do it in Excel and re-import or create an additional calculated field
or you could hit ctrl-‘=’, select ‘Replace with calculated result:’ and type in:
GetField ( Get ( ActiveFieldName ) ) &”/14″
Nice and simple….which is what we developers are always after, right?