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.
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)
Subreddit
Post Details
- Posted
- 1 year ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/Notion/comm...