Function/computed field type

[GP-S]

Scope & Context

Currently, on objects we can only add txt/number/boolean and date field.

It woould be great to add a computed field that use the value of other fields to calculate it's own value.
For instance a field calculating the estimated opportunity value following the number of employees on the company.
Or, using the same use case as illustrated in #2534, a field that count the numbe of opportunities or closed deal by referer.

A notion like approach could be inspiring :

[FelixMalfait]

Yes that would be super cool 😍

[Bonapara]

Related suggestion: #7139

[thinkbig1979]

Sorry I missed this topic when adding the feature request. I searched for a few terms, but somehow 'computed' was not one of them 😅.
Anyhow, this would be a great addition.
Twenty is so nice and well thought out, but just missing a few powerful features that would give it the edge over pretty much everything else in this space.
Keep up the great work! 💪

[eshut]

+1 here. It's the only thing stops me from using this CRM. You can see the open-source EspoCRM formulas (it's on php 🙄 and sometimes broken...), it allows to link different entities, e.g Opportunities + Accounts, so I can calculate all the related opportunity.amount to some Account and show the result in some field.

And also the missing thing here is to create different (custom) entities, where I can later also use some formulas. E.g. in data-models, after I create a new Objact(page) I expect it to have many-to-many or many-to-one, etc.. relationships to create some custom fields with links to different Objects @Bonapara

[FelixMalfait]

@eshut Thanks for sharing! there are multiple ways to do computed fields. For "cached" computed fields that are re-computed when the source value changes (it seems that's what Espo does), we will release a major feature "Workflows" in early beta end of October which should allow hacking that kind of things. It will force you to call the API in a workflow step at first but as we iterate we will make it easier to build things like that without technical knowledge

[eshut]

@FelixMalfait Wow, that sounds great. I would be happy to test this out and share my feedback on it.