Hey @lightkensei ! I'm also a bit of a frag head, so you're in good hands here 🙂
What you're asking is very possible. I'm envisioning you'll have two tables. The first will be for perfumes (name, price, date purchased etc). And the 2nd will be for dates. And yes, through Linked Records, you can have both multiple perfumes for each date, and multiple dates for each perfume. Recorded a quick Loom video to show you how to get setup.
Screenshots of setup:
Hey @lightkensei ! I'm also a bit of a frag head, so you're in good hands here 🙂
What you're asking is very possible. I'm envisioning you'll have two tables. The first will be for perfumes (name, price, date purchased etc). And the 2nd will be for dates. And yes, through Linked Records, you can have both multiple perfumes for each date, and multiple dates for each perfume. Recorded a quick Loom video to show you how to get setup.
Screenshots of setup:
Hi! Thank you so much, @Arthur_Tutt! That was incredibly helpful, especially the video. I'm setting up that second table now. I knew there had to be a simple(ish) explanation 😊. If I run into any weird bumps I will post again, but for now it seems you've answered my question.
Hi @Arthur_Tutt, thanks so much for this explanation, this is very close to the question I was going to ask and the challenge I'm facing.
To continue with the fragrances metaphor, what I need to do in addition to what you described is to create a calendar view with multiple dates in one field. Is this possible? When I try, Airtable only wants to populate a calendar with a Date field, as opposed to a lookup field which we are using in this example.
The other thing which I am trying to figure out is how to generate a count for how many times a fragrance appears in the table. Is this possible to do as well? Thanks for any guidance you can provide.
