Help

Re: Link to record linking to different fields as different entries?

228 0
cancel
Showing results for 
Search instead for 
Did you mean: 
natheniel
4 - Data Explorer
4 - Data Explorer

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)

FruitPlanting dateHarvesting date
Apple1 Jan2 Feb
Orange15 Jan1 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.

FruitActionDate
ApplePlanting1 Jan
OrangePlanting15 Jan
OrangeHarvesting1 Feb
AppleHarvesting2 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)

2 Replies 2

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

Screenshot 2024-02-15 at 5.17.03 PM.png
Screenshot 2024-02-15 at 5.17.12 PM.png
I'm not too sure what you mean about wanting the information to be dynamic though, sorry if I've misunderstood!

Link to base

Thanks! I will look into it more!