Hello fellow Airtablers! (maybe there’s a better name…?)
I staff designers onto projects and I want to create a “Supply Grid” where it shows when a designer is next available, for how long (# of weeks) and what they are off to next after those weeks. Something like this:
Many thanks to help from @Mike_Pennisi and @Alexey_Gusev (thank you both!) I was able to create records that help indicate when a designer is available each week (labeled “Open Space”). So essentially, my Airtable Table looks kind of like this (a much simplified version):
Where I Need Your Help:
Using this data, I want to automatically create the “Supply Grid” (Right now i’m doing this all manually).
I’m imaging the steps being something like:
From the list of open space records for each designer, identify the open space record with the earliest start date and have that be the “Available Starting” date for the Supply Grid for that designer
Identify the # of open space records in a row until it hits a record that’s not an Open Space (this will show the # of weeks available) // or identify the open space record with the latest date to help determine the “Available for” # of weeks.
Use the “Status” for the non-Open Space record as the “Until (Event)” value to inform the reader what the designer is up to after their availability (identify if they stop being available due to vacation or due to being locked on something else)
Would love this to be an automatic live-update situation but welcome any/all ideas. Thank you!