🔦 Feature: Allow rollup also for linked formula fields

[Jean28518]

Please confirm if feature request does NOT exist already ?

• [X] I confirm there is no existing issue for this

Describe the usecase for the feature

• Assume we have a warehouse system with two tables: articles and warehouse movement
• The article table has a link (Has Many) to warehouse movements
• The warehouse movements table has a checkmark: (Fulfilled)
• I created a formula in warehouse movement which wether shows the amount of the article movement or 0 (current warehouse effect)
• I want to calculate the current amount in the warehouse of an article (but only the fulfilled warehouse movements). (Rollup in articles, Link to that formula field (current warehouse effect)

Suggested Solution

There are two solutions to address this problem:

• Allow the rollup feature also for linked function fields
• Or maybe an even nicer feature would be allow setting filters to a rollup field, which checks e.g. if the linked field is true. I guess this is described here, but I can't chinese: (#4899)

Additional Context

With such a feature nocodb tables could become so much more functionality. In my opinion the current implementation of the rollup field is a good start but it could have much more potential :)

(And yes, this example is simplyfied. There are many, much more complex real world examples I could imagine.)

[EngiBenchi]

Yes this one is high on my list as well. I even made a small example for it. imagine a list with people and there day of birth than you can calculate there age: And you want to have some demographics: As for now you can't use the calculated value in the rollup field [Age]. I had to use the copied value [Age2]