Notice that in the "days" database I create a rollup of distance of workouts database and then a formula field with the sum of that rollup. I share with you a page with a sample of how I would do your workouts database in Notion. What I do is, every sunday, manually create the day entries for the coming week and relating them to the week in the week database. Than you can do with the master database what you want, tracking habits, workouts, journaling etc. What you can do, if you really wanna stick with Notion, is creating a master database of days and relating them to weeks. You can't formulaically create relations between tables, you need to add every entry to the relation. No, Notion can't do this as far as I know. I'm wondering if there is a more programatic approach as I have utilized in Coda. Having to create a relation column and then a separate "rollup" column to do something with it is very confusing to me. It requires a user to select them manually with a mouse-click in a Relation column, right? I do not see a way to formulaically/programmatically relate any two rows from different databases that have matching dates.
Something like a column in Employees that uses the following formula: Position = Postions.NameĪ better example is having two databases, and each have a Date column. What I would expect instead is to create a formula column that references the other database. Imagine a database of 1,000 employees and a multi-select column where I have to grab a few Positions out of a list of hundreds for each employe. I have to create a Relation column and then manually select a Position.
#Notion relational database how to
What I cannot figure out is how to formulaically link these databases.
In the Employees table I have a single-select property where the tag matches one of the named positions in Positions. I have two tables, one named "Employees" and the other name "Positions". I'm sure it's just that I'm missing something I would love the help.
#Notion relational database full
I'd like to make the full switch but I'm a heavy user of databases and I'm stuck on a really basic issue. I'm comfortable making some fancy stuff in Coda, but I prefer some aspects of Notion.
0 kommentar(er)
