remove calculated value from field not (entirely) working

Question

I have a field called "Install Date" in the Cases module that calculated its value from a module called Equipment with this formula:

related($e1_equipment_cases_1,"install_date_c")

I now wish to remove this relationship, and instead update this "Install Date" field in the Cases module using a Process Definition action. I have un-checked the "Calculated Value" checkbox for the field, and can now change it in the Cases module, but the field does not show up in the list of fields that can be changed in a Process Definition action. Additionally, I noticed that initially upon unchecking "Calculated Value" for the field in Studio, the "Formula" disappeard, but after saving and returing to edit fields, the "Calculated Value" checkbox is still unchecked but the "Formula" has returned and cannot be removed. Is this a bug? How to I address this issue?

Marshall Ambros · Accepted Answer

Hi Marshall , I confirmed this behavior as well, and it appears to be known defect # 81394 (you need to be a support-authorized contact to view this link). To remedy the issue, edit the extended vardef file corresponding with that field. Based on your screenshot, that file should be under the following path in your Sugar directory: ./custom/Extension/modules/Cases/Ext/Vardefs/sugarfield_install_date_c.php Once you open the file, look for and delete the line containing the formula. It should look like the following: $dictionary [ 'Case' ] [ 'fields' ] [ 'install_date_c' ] [ 'formula' ] = ' related ( < module_name > , < field_name > ) ' ; After you delete the line in that file and save your changes, log into Sugar and go to Admin > Repair > Quick Repair and Rebuild to recognize the change you made in the file. If you are hosted in SugarCloud, you need to file a support case for their team to handle this request as you do not have file-level access.