Recalculate records to update fields [tough]

[awayand]

I have two text fields, that are supposed to auto-fill themselves with a calculated, not looked-up value. However, those fields are empty after I imported some data. What can I do now to automatically update all those fields? I'm really stumped. Any help appreciated!

[EddyB]

Hi

Click on the first field and select replace contents from the FM menus.

Choose replace with calculated result.

Enter your calculation in here and click replace.

All records will be updated.

Repeat on your second field.

Ed.

[awayand]

Thanks! Is there a way to do this using a script step/function?

Neat trick. If I can do this in a script, I can make sure the field is always updated...

[EddyB]

Hi,

Just use the Replace Contents Script Step:

Replace Contents [No Dialog, "Field1", "Your1stCalculation"]

Replace Contents [No Dialog, "Field2", "Your2ndCalculation"]

You shouldn't need to do this though unless you are planning on importing data all the time. I think that is the only time a calculated field may be missed.

Ed.