Hi! New-ish to AirTable and very much appreciate your help and patience!
I am trying to create a timeline or calendar view that displays all of our acting clients' working dates for every single film/TV project that our clients are/will be working on.
For instance, I need a way to quickly view and edit the statement, "Charlie Chaplin is working on the film MODERN TIMES in NYC on 1/15-1/27, then 2/2, 2/7, 2/9, and again on 2/23-2/28." Additionally, I need to quickly display a client's working dates on a particular project to answer the question, "When is Charlie Chaplin available in Q1 and not filming MODERN TIMES?"
The problem is that I do not love the idea of creating several different start and end date fields for individual days (ex: 2/2, 2/7, 2/9) and short date ranges (ex: 2/23 -2/28). It does not seem like I can just select all the the dates a client works on from the existing date field(s), it only allows me to create a range (start date and end date fields) vs attributing several days to an existing project.
I have an "ACTIVE WORKING" master table that is organized with PROJECT TITLE as the primary field, sorted and grouped by CLIENT NAME.
What is the best way to go about trying to create a workaround? Extension, Junction Table, Rollup Field, Date Array??
Thank you!
