In a thread from last year it was mentioned that (if I understand correctly) it was not possible to filter a rollup function using the contents of a formula column in the linked table.
Has this been implemented yet by any chance?
Unfortunately I’m not having any luck with it. I can filter the rollup (sum) by a checkbox column for example, but not by formula columns containing text, numbers or boolean values.
After my original post, I did actually figure out a formula that seems to work and doesn’t require any of the Sold... columns in the Products table at all: rollup("Products", "Price", "sum", "countlinks('Buyer') > 0")
But I’d still like to know why I can’t use the formula columns in the rollup condition
Hi, it seems to me that you didn’t know we have a “link formula” column type that does exactly what you need? Just because we have “link formula”, we have removed the linking calculations from the formula column!
I have reproduced your base and have fulfilled the tasks simply by using the link formula columns:
(the column types are not the intended end result, just for demonstration)
I was wondering if it’s possible to have 2 columns that link to other tables, but so that the selections available in the second column depend on what was chosen in the first column.
Let’s say I have dozens of product categories (too many to create a view for each one) and lots of products in each category.
Maybe there are even multiple products with very similar or identical names that belong to different categories.
What I imagined is: When adding a new invoice, I would first select a product category in the Column “Category” (for example Widgets). In the next column, I need to enter the product that was sold.
But instead of being presented with all possible products to choose from (Widgets, Sprockets, and everything else), I’d only like to see Widgets. I’ve already selected that category, so all products belonging to other categories are irrelevant.
Is there any way to achieve this? I’ve searched the forum and the docs, but I was unable to find anything like that.
When I enter a new invoice, I select the product category in the “Category” column.
What I’m missing though is the next step: I’d like to have a column “Products”, where I can select the product that was sold.
But the products I get to choose from should be limited to the children (products) of the parent (category), as defined by being linked to that category via the “Category/new“ column in the Products table.
That’s what I mean by “dynamic” cascade. The hierarchy of parents and children would be built by links between tables, so you wouldn’t have to define those relations manually.