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

Need help with creating a record of dates from one table to another

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

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.