Fishbowl Advanced error

Fishbowl: Cannot modify custom field with existing data

Q: Why does Fishbowl say "There are already records with data stored using the original type. Try creating a new custom field and inactivate this one."?

The custom field you're trying to modify contains data in existing records, which prevents the change. Create a new custom field with your desired configuration and inactivate the old one.

Warning✕

There are already records with data stored using the original type. Try creating a new custom field and inactivate this one.

Simulated popup

Custom FieldsCustom Fields

What it means

When a custom field contains data in records, Fishbowl prevents you from changing its type to avoid data conflicts. This is a data-integrity guard. The error message suggests creating a new field with your desired type and inactivating the old one.

What to check

Confirm you’re attempting to change the field’s data type (not renaming or other properties)
Verify which records have data in this field
Decide whether you need to preserve the old data or accept starting fresh with the new field
If migrating, plan whether to manually copy data to the new field or leave historical values unchanged