I am trying to get a summary of a single select column from a referenced table. The idea is kind of referencing cakes that can be of different types. Using a formula like this:
{ReferencedCakes.CakeType}
This displays all the single select values. So if the referenced cakes are 10 cherry crumbles and 10 cheese cakes, the cell will display 20 tags. But I would just like to get the 2 unique values here. Is this possible with a formula?
Hey despens,
is that what you want to achieve? You reference multiple values from the table “Cakes” to “Table1”.
Now you would like to remove duplicate values like I did manually in the column "Remove duplicates?
Currently, SeaTable does not provide such a function to remove the duplicates. But you could write a small JavaScript or python script and an automation will execute this script every time a row is updated.
This will require an enterprise account, but then you could accomplish your requirement.
Best regards
Christoph
Thanks Christoph, yes the screenshot shows the result I’m looking for. So I’d need a script, which is not too bad.
I like how notion handles such “rollups”: depending on the type of referenced column, it offers some standard summarization options. You can for instance display lowest, highest, or average value, earliest date, latest date, time span, unique values, etc. It’s quite useful and reduces the instances you have to deal with formulas, maybe something that SeaTable could offer as well.
Hey despens,
Right now these formulas are supported:
Still there is no possibility to remove duplicates right now.
In summary: right now you have to go with a custom script in combination with an automation.
Best regards
Christoph
This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.
Do it like thousands of other people who have used SeaTable to develop powerful processes and get their ideas and tasks done more efficiently.
