Link to record linking to different fields as different entries?

[natheniel]

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)

[TheTimeSavingCo]

Hmm, you could try:
1. Create an automation that'll create X records every time a new record gets created in your original table, where X denotes the number of tasks, and each record will have the "Action" type set
2. Create a formula field that will output the appropriate date based on the "Action", with the data pulled via lookup fields

I'm not too sure what you mean about wanting the information to be dynamic though, sorry if I've misunderstood!

Link to base

[natheniel]

Thanks! I will look into it more!