How to Coda your Social Media?
Using tables with buttons you create a planning in seconds
In the Coda Community I came across a question on how to plan social media posts. Like often with planning, you have multiple solutions. I went for an approach that uses buttons to generate a list of dates and a calendar view.
https://twitter.com/CodaExpert/status/1435326366266834945
How to plan?
The main function here is Sequence() The trick is to make use of the third option in this function: “by”.
The ‘by’ function skips items in the list and in this case the start and end date define the limits of the list, while we need the Frequency to tell by how many we want to skip the dates. If the frequency is 1 (Instagram), none of the items is skipped, if 2, every second is skipped, if 3, every third item is taken.
When we look a bit closer at sequence and we take a range of 15 days we see the following:
Instagram is posted every day, the others less and we see the dates. The numbers in blue in the buttons tell us how many dates we have. We FormulaMap the created lists, containing in the above example 15 or 8 or 5 or 8 items, and turn each item (the CurrentValue) into a date.
The AddRow() does the rest once the button is pushed, it distributes the items over the rows and adds as many rows as we have items. To make things easier I added two more buttons, one to push all the buttons in the table and one to clear the planning by removing all the rows in the planning.
To get the calendar view working, I had to format the column TheDates as a date column. Only then the software knows how to handle the data. The Sort() function in the Table Planning takes care of the order.
I hope you enjoyed this article. If you have questions feel free to reach out. Though this article is for free, my work (including advice) won’t be, but there is always room for a chat to see what can be done. Besides you find my (for free) contributions to the Coda Community and on Twitter
My name is Christiaan Huizer and I am the owner of Huizer Automation. A company specialized in serving SME in harvesting data and keeping it aligned. I am a Coda Expert and I mainly rely on Coda, Mailjet, Zapier & Paperform to get the job done.
