Notion Answers

Help between Notion users


Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution

Question

1vote

How to relate properties only if they are checked in another table?

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

1 Answer

0vote

polle Points77480

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.

Please log in or register to answer this question.

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Connect