![]() 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. 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. 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. You can see a couple of useful examples of how you might leverage this in your business systems below.I'm comfortable making some fancy stuff in Coda, but I prefer some aspects of Notion. This makes it easy to keep track of related information from different data sources in one place. Once you have created relations to multiple databases in Notion, you'll then be able to reference objects from both/either related databases in your main database view. Then, repeat the exact same process you used to create this relation for as many new relational database properties as you like! 6. Now that you have another database to reference, select it as the source, hit the 'Show on' toggle and hit 'Add relation. Repeat the process and link to another database If you don't already have another database to reference, it is time to create one now! You can create this anywhere in your Notion workspace-we'll be able to find it from the relational source option when setting up the new property. This will allow you to create a relation between your main database and other databases in your workspace. When selecting the type of property you would like to add, select 'Relation' as the property type. Or, if viewing it as a page, at the top of the page select 'add a property'. To do this, click the '+' icon at the top of your database's columns to add a new property. Once you have opened or created your main database, the next step is to create a new property. ![]() You can do this by typing '/database' to create a new database inline. The first step to creating relations to multiple databases in Notion is to navigate to or create your main database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |