[FR]: Formulas as Rollup

[arminta7]

Contact Details

sarah.arminta@me.com

Present your request

I have a Goals DB. I've been trying to figure out how to have a column which shows related Projects (files tagged #project where the goals:: field contains the current row and status:: = Active.

How can I accomplish this? I've tried a formula column, but I can't even get the basic relation to work... I tried various forms of this: ${db.dataview.pages("#project").where(p => p.goals && p.goals.path.includes(row.__file__.name))}

For which platform do you request this request??

Desktop

[RafaelGB]

Hello!

I was thinking about to include formulas as rollup option, so you can take advantage of the relation column ( it will substitute db.dataview.pages("#project") which is an expensive query and could affects the performnace) and manage your own behaviour (your where() or another js code)

This month I will be less active with the plugin due to labor issues, but I will continue uploading improvements thanks to your feedback!

[RafaelGB]

The new rollup formula expose the content of its pages

And you can manage the dataview record of every relation

function relationsCheck(pages) {
    return pages.map(p => p.file.tags)
}

module.exports = relationsCheck

[arminta7]

Fantastic! That was fast!