The Discord Stream Theme today on the 7Bloodfire server was "Writing Sprints" though my personal focus was on writing code, lol! The Notion system I'm building out got a new addition, which might be useful to a lot of you who are building social media platforms.
I created a Social Media Growth page and database that includes code that lets the user know how long since the last time they rebranded their social media and websites, and when they last updated their number of followers. It also tracks those numbers and lets you tag the next increment goal so you can celebrate every single milestone.
(I'm a chronic check-and-re-checker of stats, so this tool lets me chill out and set an ideal date to check back and realistically look at how to achieve hitting platform milestones. That means I focus on what matters instead of letting my ADHD run me into another stress whirlwind.)
Below, I'll discuss and show how I implemented the social media growth page and database into the Intentions and Resolutions pages created during yesterday's Year of Renewal Discord Stream. I'll also share the code. (To read up on what got developed yesterday, click here.)
Notice the linked icons listed along the top of this picture. I added them to the toggle containing the Social Media Growth database. The emojis there match the entries' icons.
The properties (column titles) that get set up next include:
3 checkbox columns titled 📅Checked This Week, 📫Update Stats Later, 🟩Focus Item
1 text spacer column with a black square ⬛ in every row (serves as a visual section divider). Setting the filter to only show entries with that black box right now will mean that every new entry will auto-populate it.
1 "Select" property titled Tag?. The options listed for it include: Membership, Newsletter, Social Media, Forum.
The title column (title however you wish, as every entry is for your various social media and sites' names
2 "Select" properties titled Follower Milestones and Next Milestone! This is easier to create if you just make one first, then duplicate the entire list, because the options for both will be the same. Here are the options and their colors:
NOTE: I wrote "Followers" at the end of every single entry on mine.
Also, green represents major milestones.
When the 1st list is done, THEN duplicate = much easier.
2 "Number" properties titled Actual and Year Joined. The first here is for the actual number of followers, while the tags on the columns before it are rounded values.
1 "Select" property, with a ton of years listed in it. All the old are colored light gray, and this year is colored green. This makes the current year very easy to see among the other entries. All the future colors can be one color, or colored in 5-year groupings.
1 text spacer column with a blue square 🟦 in every row. (Same purpose and filter settings as before. This marks the beginning of the formula columns.)
3 formula columns titled Years Since Last Edited, Weeks Since Last Edited, Days Since Last Edited.
1 more blue spacer text column, which separates the previous three formula columns from the final formula column for months titled Months Since Last Edited, as well as a "Last Edited" property column titled Last edited time. (The last one you can change to a regular date entry column, which would be more helpful if you prefer manual entry for something like that.) Also remember to filter the database to always have the blue square in that new spacer column, just like both of the other spacer columns.
---
Now what? Well, here's the code for the four formula columns!
Code for "Years ...": dateBetween(prop("Last edited time"), now(), "years")
Code for "Weeks ...": if(prop("Years Since Last Edited") > 0, subtract(dateBetween(prop("Last edited time"), now(), "weeks"), multiply(prop("Years Since Last Edited"), 52)), dateBetween(prop("Last edited time"), now(), "weeks"))
Code for "Days ...": if(prop("Weeks Since Last Edited") > 0, subtract(dateBetween(prop("Last edited time"), now(), "days"), multiply(prop("Weeks Since Last Edited"), 7)), dateBetween(prop("Last edited time"), now(), "days"))
Code for "Months ...": if(prop("Years Since Last Edited") > 0, subtract(dateBetween(prop("Last edited time"), now(), "months"), multiply(prop("Years Since Last Edited"), 12)), dateBetween(prop("Last edited time"), now(), "months"))
A note on the Months and Weeks columns: I've designed these two to be reliant on the Years column, not each other. That means you pick which one you'd rather see. I booted my Months column to the end because I prefer Weeks. So I can see how many years, weeks, and days. Then glance over to see roughly the months count.
Make sure you add a filter for this first table view. Filter the table by 📅Checked This Week, but don't make a selection for checked or unchecked yet. Do that later during your stats reviews so it serves as a to-do list and shows only what's left to do until the filter is cleared & the boxes reset to blanks.
Once I had this set up, I duplicated this view and renamed the new one "Focus Tbl." This one has all the properties still shown on it but set to filter the property 🟩Focus Item as checked.
Finally, after that, I duplicated the Focus Tbl view to a new view called "Focus (no extras)." The picture shows which fields are visible. The rest are hidden. No new filters needed. This is the simple view of the table.
On this view, I did move the black box filter column over in front of the Last edited date column. But I hid both of the blue filter box columns.
Extra tip! I've got a bonus tip on squishing the columns beyond their normal "squish limit" lol. Turn the property into a checkbox property (doesn't matter if there is still text or code in it, it'll stay). Then squish the property to make it thinner. When you're happy with that column, turn it back into the property it had been before. All the options, text, code, or even dates you'd entered before will still be there.
So that's the walk-through. You can rename your columns after the coding is done.
Now you can create a long list of social media platforms you're trying to grow, but de-select the ones that aren't the major focus right now. You'll easily see which social media needs updated.
Subscribe to my YouTube channel 7Bloodfire Art and Story for more topics on Notion, and writer-related stuff (which includes everything from tips on the craft, to productivity and systems designs).
Comments