Sugar Q1 2023 (12.3) introduces the ability to designate Dropdown fields as calculated fields in Admin > Studio! Just enable the Calculated Value checkbox for the field and enter your formula. It's as simple as that! As a side note, be sure to double-check your formula to ensure that the dropdown value is a valid option in the dropdown list, as Sugar does not validate the results. So, if the dropdown list has values "A, B, C" and the formula results in a value of "1", then the field will appear blank. |
Make sure that you have notifications turned on for Quick Tips for more great tips like this!