🔦 Feature: Support use of Rollup's with in formula

[dstala]

Please confirm if feature request does NOT exists already ?

• I confirm there is no existing issue for this

Describe the usecase for the feature

https://community.nocodb.com/t/reference-rollup-fields-in-functions-inside-formula-columns/917

Suggested Solution

Support use of rollup fields within formula field

Additional Context

No response

[dstala]

from discourse

I am trying to create a custom CRM using nocodb. I currently have two tables →

Leads → A table containing all leads and has fields like name, contact details etc.
Interactions → A table containing all the interactions with Leads and has fields like interaction-notes, date of interaction, mode of interaction etc.
One lead can have multiple interactions so I have a one to many relationship from Lead to Interactions Database.
To find out the latest interaction between for a lead, I use a rollup with Max Function. This is the field called LastInteractionDate.

Now, I am trying to find the time since last interaction with the lead and Today to calculate a field called RottingTime
The formula I wanted to have for RottingTime is DATETIME_DIFF(NOW(),{LastInteractionDate}).
This is where I encountered the above error.

My goal is to send followup reminders based on the value of RottingTime.