Calculated fields columns are great for quick simple formulas. They are fast, instant, and always up to date. But what if you need to clear the value of the column as part of the calculation? Customer has sites, sites have assets in various categories (hardware, software, etc). The other day I’ve had a requirement to […]
Tip #1349: Calculated field from related record
When Marius Agur Hagelund Lind poked me with this tip I was like, duuuude, who doesn’t know that? Turns out, not a single person in my family knew that so here it is. All yours, Marius Here’s an oldie but goodie. Did you know that you can use related records to calculate a field value?Well […]
Tip #571: Unable to publish solution with calculated fields
If you attempt to publish a solution containing an entity with calculated fields, you may receive the following error message: Field foo_calculated cannot be created or updated because field foo_used_in_condition_or_formula contains an additional formula that uses a parent record. The wording is misleading and confusing because field foo_used_in_condition_or_formula is not a calculated field at all. […]