Hi all, I'm trying to delete a custom field and I'...
# generalm
Merk
05/11/2023, 10:52 AMHi all, I'm trying to delete a custom field and I'm 100% sure it has no dependent records, but it gives me that error which I can't delete it, because it has dependent records. It also doesn't let me to change the Field ID as it errors You are not allowed to access this custom field. There's nothing under Sourcing & Filtering subtab 🧱
Does anyone know how to delete the custom field?
m
Michael McNamara
05/11/2023, 1:59 PMWhen it gives you the dependent record error, it should give you a link to see which dependent records are attached. Did you try that yet?
m
Merk
05/11/2023, 2:15 PMYes, the link shows no records, which I can't understand. It's a checkbox. It's not been used in any workflow, script and custom fields. So what's the dependent record?
m
MGBC
05/11/2023, 3:24 PMSometimes it could be part of some backend data that isn't referenced in these dependencies. Like in System Notes or Audit Trail. Can you just inactivate it instead of deleting?
m
Merk
05/11/2023, 3:28 PMThanks @MGBC It gives me an error of This record cannot be inactivated because it has dependent records.
It doesn't allow me to change the field's Id. It says You are not allowed to access this custom field.
m
Michael McNamara
05/11/2023, 4:10 PMCan you change its field TYPE to something else? That can usually delete all previous data that the field stored.
Michael McNamara
05/11/2023, 4:11 PMLike change it to a text field or something.
Michael McNamara
05/11/2023, 4:14 PMJust change the data type on the custom field. You will get a warning saying “Changing this custom field type will delete all data in existing records. Are you sure you want to do this?”
Michael McNamara
05/11/2023, 4:15 PMIf that doesn’t work, maybe you can try doing a mass update to records with that field and uncheck all of them. Then you might be able to delete it.
m
Merk
05/11/2023, 4:47 PMThanks @Michael McNamara I tried changing the custom field Type. Set it Non-Store Value, removed from customer and added back, but no joy. The field is new. I used Copy to Account from sandbox. It's become a mystery.
Merk
05/12/2023, 8:33 AM@Michael McNamara and @MGBC
Solution:
Change the field Type of the custom field then use in a transaction or record. Then you can delete it.
I had used Copy to Account feature and copied from sandbox, so there could be some data/dependency from the source account.
The custom fields are now deleted
m
Michael McNamara
05/12/2023, 1:33 PMAwesome! Glad you figures it out and thanks for sharing the solution!
28 Views