I changed the default values for a FieldMaker field. Is there a way to change the existing records or do I have to do it manually?
  • 04 Jun 2023
  • Contributors
  • Dark
    Light
  • PDF

I changed the default values for a FieldMaker field. Is there a way to change the existing records or do I have to do it manually?

  • Dark
    Light
  • PDF

Article summary

After we created our fields we realized the default value was poorly chosen.  We have changed the field to now fill in the correct new default for new records, but all the existing records show the old one.  How do we fix this?

Answer:
In situations like this, it is best to copy your live database into your test or demo database so you can test the fix over there first.
  1. Once the copy has finished, log into the Test database
  2. Navigate to Tools > System Utilities > Admin Utilities > Global Change
  3. In the File to Change box enter the FieldMaker table: i.e. fm_profile, fm_fund, fm_gift, etc)
  4. In the Field to Change choose the one with the problem
  5. In the Old Value enter the old default value and in the New Value enter in the correct default
  6. No filtering is necessary so the bottom section is not touched.
  7. Click Replace
  8. Examine the records.

Was this article helpful?