Hi new here, hopefully this wasn't asked before. Please link me to it if it was.
Let's say I am managing a fruit plantation. Each fruit needs to be planted and harvested.
I have already a table like so, where the Fruit field is linked to another table (eg. Basic info about the fruit: colour, size, etc)
Fruit | Planting date | Harvesting date |
Apple | 1 Jan | 2 Feb |
Orange | 15 Jan | 1 Feb |
Is it possible to create a table (or a view?) that somehow links to the previous two tables? I saw some previous post on how to make a static table with automation, but I want the information to be dynamic if possible.
Fruit | Action | Date |
Apple | Planting | 1 Jan |
Orange | Planting | 15 Jan |
Orange | Harvesting | 1 Feb |
Apple | Harvesting | 2 Feb |
(Ultimately, I like to see what I need to do each week. So I will be using formulas and Group to create a view for each week. I know how to do it from this newly envisioned table above, but I don't know how to get to it.)
Thanks so much in advance!
(edits: grammar)