Question

I'm working on creating several simultaneous cross-country driving routes that span the course of 3 weeks. I have separate databases for Teams, Venues, Weeks, and Routes, and have most of the relations set up, but I'm wondering if there is a more efficient way to go about the Routes set up. (FIY in my experimenting, I may have created unneeded relations...whoops)

In my Venues table, I have 3 columns with checkboxes that indicate which week that venue will be visited, as well as a relation to the Weeks table and Team table.

However on my Routes table, I have 3 columns for the venue that will be visited each week.
Ex.
R1 Ven1 Ven2 Ven3
R2 Ven4 Ven5 Ven5

Currently, these venue columns are relations to the Venue database, but I figure there's got to be a way to automate it based on which checkboxes are checked in my Venues table...

Any help would be appreciated!
Thank you

Answer 1

You can't relate or modify another Notion property depending on a checkbox. The only property that can do something similar is a formula that shows something depending on the status of a checkbox.

Four your setup instead of 3 columns with checkboxes, you need only 1 column with a relation to the weeks database. Instead of clicking a checkbox, you will select the week for the relation.

After everything is related, you can have rollups to show associated info or columns to every relation and that can create an automatic general view as you need.