Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 14, 2024 10:25 PM - edited Feb 14, 2024 10:28 PM
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)
Feb 15, 2024 01:19 AM
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
Feb 20, 2024 12:50 AM
Thanks! I will look into it more!