I wanted to check best practice about Custom Fields. If you add a field to the Customization Project, publish the Customization Project, remove the field, and then publish again, then I think the field is deleted from the database. What happens if you unpublish the customization project, does the field get deleted too? Does the project check if any values are in the column being deleted from the database? Do I need to Export and Import to make sure I don’t loose the custom field data.
I know that you have to unpublish customizations before upgrading versions so I don’t want to lose custom field data. Also, as this is a SaaS environment, who does the unpublish/publish when the upgrade is done automatically?
If you have a number of tenants and the customization project is on an old tenant that then gets deleted, can you load the Customization Project to the current tenant so you can manage the Custom Field, and should you do this before or after the other tenant is deleted? Is it ok to have the same Customization Project on all tenants or is that confusing?
If someone can point me at some documentation about the lifecycle of Custom Fields and what happens in these scenarios it would be much appreciated. Many thanks.
