laenavesse: (Default)
laenavesse ([personal profile] laenavesse) wrote in [community profile] efryndiel2023-02-05 08:29 pm

[ code ] calendar script

February
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
1
Plot With Me
2
3
State of the Game
4
5
ATP/EMP
6
7
8
9
10
11
12
13
14
Event/TDM
15
16
17
18
19
20
21
22
Reserves Open
23
24
25
26
Activity Check
27
28
March
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
1
Apps Open
2
3
CR Meme
4
5
Player Event
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
April
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
SELECT MONTH




about & instructions

This is a fully automated calendar that uses Google Sheets to generate a calendar that will fit whatever needs you have. It's a simple design, but can be customized if you know what to do (I can also help change things if needed). The main draw is being able to not only display a calendar, but also maintain it without having to dig into the code and update it manually all the time. You can color the cells and it will be the same on the code. You can also customize the calendar so that you can put unique Month headers or Days if you have custom labeled calendar. It is based off the Gregorian 7x5 (with occasional 7x6) grid, but not impossible to change to something different. This will work for any year by adjusting the Starting Day settings, and will also work for leap years.

Here are some screenshots: Spreadsheet; Preview. For a live example, I used this for [community profile] songerein here, and our spreedsheet looks like this.

To save, Make a Copy of the spreadsheet for your own use. It's already "pre-filled" with random data so you can see how it works. When you run it for the first time, you'll have to accept permissions (it's safe as everything is local to your machine). Just follow the instructions that pop up and then you'll be able to run it.
The generated code doesn't have any line breaks so it's one giant mess. Since you're c/ping everything it shouldn't matter too much, however, there is HTML Formatter and other HTML formatters that will make it less of a giant blob! Just C/P the giant blob and it will reformat into something more legible.

I have included detailed instructions on how to work the sheet. But if you have any questions or need help with modifications, just comment and I'll take a poke, even customize it for you if possible. However, I am not a professional, so my own abilities are limited.

As a side note, for those who use Tessisamess's calendar code, I have it scripted for this, as well. I just don't have a public release version since the calendar code is not mine and I feel a little awkward publicly releasing scripts for other codes. It does have credits for both Tess and myself. If you wish to have a scripted version of that code, just hit me up and I'll send it over.

A small credit code is included, but any credit goes to [personal profile] laenavesse @ [community profile] efryndiel. Although not necessary, I do accept tips on ko-fi! For this script in particular, I'd really appreciate any from those who use it since it was a beast to create. I can also do script commissions for other codes!
alorian: (Default)

[personal profile] alorian 2023-02-19 10:57 am (UTC)(link)
This is brilliant! Well done. If it's no trouble could I get the script for tess's calendar please? Should I PM you or?
alorian: (Default)

[personal profile] alorian 2023-02-20 09:25 am (UTC)(link)
Thank you so much, I really appreciate it!