Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 29 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Link to record linking to different fields as different entries?

Topic Labels: Base design Views
764 2
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!