Hello! I have been using Coda to plan social media content for my organisation and would like to optimise our processes. Currently, I have a master database to collect all content, but we are filtering in subpages in order to work in month views.
-
In order to create “slots” that we can then fill in as we work throughout the month, new rows are created in the master database.
-
Each “slot” (empty row) belongs a specific category (these are sourced from another table)
-
We have a specific, weekly flow for our content that follows a certain category order and we do not post on weekends.
-
I have been creating “slots” by copying and pasting our specific flow and changing the dates to be able to filter the empty slots by month view.
I am essentially looking for a better way. I do not want to copy and paste and change all the dates every month… Open to any suggestions!
Hi @Maya_Weisinger - welcome to the community!
Yes, there defo’s scope for automation here- suspect you’ll have to sorting out the logic for the edge-cases though - ie holidays.
suspect RunActions() formula in conjunction with AddRow()'will be your friend, you can leverage ‘Date()’ to skip weekends.
Not 100% sure, but try Sequence() along with Weekday() to filter out weekends for date creation.
You’ll definitely need to leverage FormulaMap() which I find super hard - it just melts my brain.
Hope that helps.
Also - Is your weekly flow is identical across all weeks, or do you vary it up?
1 Like
Hello @Maya_Weisinger ,
If you share a dummy doc, I (or someone else) can show you how to make a button with a formula to just do that.
You start with sequence (for the date from to date to), filter out the weekend days, do a ForEach (this is the newer name for FormulaMap) on your template table, filter for the current day of the week and than do another ForEach to make new records in your master table.
This sounds perhaps complex, but it really is pretty straightforward. There are different approaches to accomplish this, the above is the one I would probably use.
