Coming soon - Get a detailed view of why an account is flagged as spam!
view details

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

3
New to Notion and wondering at the best way to set up a shared dates<->item property
Post Flair (click to view more posts with a particular flair)
Post Body

I'm compiling database of items that have multiple dates associated with them. For example's sake, lets say it's a database of birds. Each itme is a unique bird, and I want to record each time I see a specific bird.

I'd like to have each item/bird to have the following properties:

1) the first date I saw the bird

2) the last date I saw the bird

3) every date the bird was spotted (I assume this must be recorded in a different database and brought into the main one through a rollup/relation (something I barely understand at the moment but I'm game to learn!)

4) number of times a bird was spotted

Birds can of course share dates and maybe sometimes I want to see all birds that were seen on x date.

#1, #2, #4 are pretty straightforward but I'm not sure what the best way is to go about #3. How best to set up the secondary database and how to effectively "assign" dates to birds or birds to dates the most efficient and functional way.

Please help! (and let me know if I need to clarify)

Author
Account Strength
100%
Account Age
6 years
Verified Email
Yes
Verified Flair
No
Total Karma
39,619
Link Karma
2,380
Comment Karma
36,821
Profile updated: 1 day ago
Posts updated: 10 months ago

Subreddit

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.
Posted
1 year ago