Need help with creating a record of dates from one table to another
Hi guys!
I have a table called “Production Stage” (reference below), with lots of dates which can be quite tricky to look at. So I created another table “Project Breakdown” with a simpler view and only have Start & End date.
I need to fill up the dates in Project Breakdown by linking it from the Production Stage, but by linking it, it creates a record for the entire line (vertically) instead of just in its specific category.
For example, a date was created for “Drug Bust Pre-Production End” in Production Stage, and I want it to appear in Project Breakdown but only under “Drug Bust - Pre-Prod End”. I hope this made sense.
Is there any automation that can help with this? Would appreciate the suggestions in advance!
Production Stage
Project Breakdown Table
Hi Mae, I’ve set something up here that I think does what you’re looking for
The idea is to make an automation that will create one record per project phase (Development, pre-production, etc), and then use the SWITCH() function to set up which phase’s start and end date to display
Let me know if you have any questions
