This is something that I’d easily do with a sheet. Given that my experience with databases is limited, I would like to know what you recommend, it’ll probably have to be done with an automation, but I honestly don’t know what.
Let’s say I have 3 channels, based on the channel, the upload frequency for new videos changes. Sometimes, I have less or more time to edit, which forces me to change my upload frequency on the go.
My assistant needs to know when he has to upload. This is “Last Publish Date” + “Duration”, the duration is automatically pulled from the first table.
Now, I know that it’s not possible to have a formula in the column that says “Take previous row’s publish date and add this rows duration”, but that’s actually what I’m looking for -> incrementing a given column.
I will be glad to support you to build the tool, but I have the feeling that I do not understand the procedure.
Would you mind to work out a more complete overview to make the steps required more clear?
Your upload procedure and what does the " videos ready for upload" mean? I assume you need a base with videos, that includes their upload/publishing status, type (channel)?
In the " upload schedule" you need most probably the actual upload date?
I assume that you want a “publishing frequency” as the audience expects for example every Sunday to watch the new episode?
