Setup Automation Where New Status Assigns Date/Time From A Preset Rolling Schedule

[jvogelis]

Hey there! I've got a cool idea to streamline our database for easier use.

Here's a Video Demo: Database Automation for Content Publishing 🤖 | Loom

Currently, I have a content database filled with records from a form, and I've set up automation to fill out most of the fields. I'm exploring ways to automatically assign a publish date based on a rolling schedule I can pre-set. I'm looking to avoid manually setting dates and want the system to add content to the schedule automatically. 

I'm not sure if I need to create a formula for this or another table to reference back to. Let me know your thoughts Airtable community!

[Sachin_191]

That sounds like an awesome idea for automating your content publishing schedule!  

You can achieve this by using a combination of formulas and automations

You could use a formula to calculate the next available publish date based on the latest entry.

You could trigger an automation that, when a new record is added, assigns the next available date based on this rolling schedule. The automation can use a script or link to another table that tracks the publishing slots.

Alternatively, you could create a second table that lists all future dates for publishing and link new content entries to the next available date.

Combining these approaches will give you a seamless, hands-off publishing schedule! Let me know if you need help with specifics!

[jvogelis]

Cool ideas! I'm not the best with code...if I wanted to have a table clients can edit as their publishing schedule, what could the automation or script look like built out, so that new records or a checkmark record is checked and the date from the rolling schedules automatically assigned to that record?