Help

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

Topic Labels: Dates & Timezones
588 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Mae_Infante
5 - Automation Enthusiast
5 - Automation Enthusiast

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
Screen Shot 2022-07-01 at 12.54.47 PM

Project Breakdown Table
Screen Shot 2022-07-01 at 12.54.38 PM

1 Reply 1

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