This is more than one suggestion, but all under one banner of “Formula fields are not great”. This is also specifically the experience of building formula/calculated fields in Data Management or for some objects their layout configurators, though there are honorable mentions from other areas.
- Along the same lines as this post, I should be able to add Formula Fields to the Company object in Data Management when I can do it from Customer Data>Company>+Field. Oddly, you can add formula fields to CTAs but I seem to get an error saving them.
- The actual formula build process is bad. Really bad. As just one example, which prompted this, is the Concat function.
- Delimiter values can only be selected from a dropdown of 5 values, there’s no custom option. To get around this, I had to do this jank:
- You can nest functions, but not very many and it’s quite clunky when you do.
- For concat values, you cannot manually add in just a space. You get an error.
- If any of your string values are null (e.g., you selected a field with no data) then the contact doesn’t work. That section just seems to get ignored.
- You can’t determine how many things you concatenate very easily - you can nest things but again, only so far and it’s not at all intuitive and you need an even number.
- Delimiter values can only be selected from a dropdown of 5 values, there’s no custom option. To get around this, I had to do this jank:
- Also the below text isn’t really relevant to all data types:
and flat out doesn’t work for String fields. Even for number fields you have to start a function first. The wording is at best confusing and at worst totally wrong in my experience.
-
You can’t access lookups when creating fields, unlike in reports. This makes sense, since you’re not pulling in the related object data the same way as when you open reports but while I’m making demands I might as well mention that it would be nice to have :)
-
The UI doesn’t even match Data Management and Customer Data>Company or CTA>Custom Field, even though the functionality appears to be largely the same. They’re also still called Calculated fields.
-
Speaking of UI mismatch, the experience of adding a formula field in Report builder was updated, and also doesn’t match the other two previously mentioned areas. The functionality here is largely the same (same problems) though you can get to lookup fields if you expend the lookup first.
-
Notably, Horizon Rules has the most up to date Formula Field experience, that matches nowhere else in the platform it seems.
