SYSTEM NOTICE

Auto translation by AI. Be sure, accuracy, nuances and authorial intent may not be fully reflected.
見出し画像

I made a mysterious notepad

A recent trivial concern of mine is that I cannot seem to keep a stock of drafts for updating my site or my note.

First of all, site updates have been stagnant for a long time, and what makes it so annoying is that it's not automated. Even though there is an input form for daily records, it's a piece of junk that doesn't update even when I enter something. (It's always like that!) I don't know why it ended up this way, but it has this mysterious specification where I have to run a separate process to reflect the changes.
Furthermore, the big problem is that I can't save drafts, so as soon as I write something, it's reflected immediately. Well, it's not actually reflected. Also, I can't edit, and implementing that kind of thing is a huge pain.
Huh?
Why not use WordPress?
I know, right? But I'm the type who wants to build it myself. And yet, I'm also the type who gets bored halfway through and leaves it abandoned.

There is another fatal problem.
This is also just me being an idiot, but will you listen?
I've created a lot of note accounts. Well, when I say a lot, it's not that many, maybe about seven. I don't think that's stupid in itself, but here is the big problem: assume that drafts exist for each of those accounts. Switching accounts one by one to edit drafts is a real pain. See, I'm an idiot, right?
Besides, I check my main account all the time, so I can see that there are a lot of drafts and think, 'I need to write.' But I almost completely forget about the existence of drafts in my non-main accounts. So what happens? The drafts just sit there and never get updated.
Because the mechanism for switching accounts is extremely cumbersome. No, wait. You can do it with one touch in the app. But you can only link up to 5 accounts with one touch in the app. I have to update the other accounts from the browser, and switching accounts in the browser means logging in and out. It's all very troublesome, as you can surely understand.

No, I'm just an idiot, aren't I?

Quite apart from that, when I use a notepad app made by someone else, I always find that it doesn't quite scratch the itch, and there are bugs that pop up here and there that don't get fixed even when I point them out. Even if it's useful, it's incredibly stressful, isn't it? In the end, it's better to make it yourself and fix it yourself if it breaks.
So, I decided to make a notepad app as a way to practice making Windows apps.


Now, the question of where to save it comes up. For example, if you save it as a text file on Windows, you can only view it from this computer, right? That would be a problem. Because I update articles, write, and even draw on the bus, I want to be able to see them from anywhere. In fact, this computer is a company computer, haha.
Huh?
Haha.
You say that's not funny?
Setting that aside.

So, I thought it would be nice if it were connected to something like Google Drive. Then I could check it from my smartphone. It feels like it would be easier to handle if it were saved as a Google Doc.
But if things go on like this, won't a huge number of draft Google Docs end up in a folder, and I'll end up never looking at them?
I think I'm very smart. So, I decided to keep a list in a spreadsheet.
That way, I can load that list and edit it from my own notepad. You have to admit, I'm a genius.
Huh?
Anyone could think of that?
And it can be done with stupidly simple code?

Yeah, despite my enthusiasm, it was quite easy to make, so I hope you all will try it out too. It's especially recommended for those of you who have 6 or more note accounts and are in a state of confusion.
There's no one like that.

And so, with that in mind,

1. I want to make a Windows app
2. It would be convenient to have a notepad
3. I want it to be saved in Google Docs if possible
4. I want to manage the list in a sheet and eventually operate it from Slack on my smartphone

The first version of the notepad that fulfills these wishes is finished~~~!!!

A UI that is too simple and easy to understand
The spreadsheet is also simple

The wonderful thing is that it can be edited.
However.
Even though it can be edited, it's a wonderful UI design where the button at the bottom always says 'Save New'.

Nevertheless, hurray for having a place to write down my drafts for now.
It's completely plain text, but if I'm putting it on note, this is enough, so it should be fine.
Huh?
Are you asking if I'll post the code?

That's right, that's the problem.
Actually, this account was supposed to be that kind of account, but the talking part is long, which is my bad habit. In reality, I'm extremely awkward and can't talk to people, but when it comes to typing, I can do it forever.


For now, the structure is:

- Launch the notepad with Python
- Save to my own Google Drive My Drive
- The list is a Google Sheet

is how it is set up.

Actually, even if I don't create a list, there's no problem at all with the current setup if I just limit the save folder, extract the contents from there, and turn them into a list.
However, as a fantasy for what comes next, I have this idea of wanting to control this list from Slack. The thing is, although I mentioned something about note, I want to go back to the beginning and use it to update my own site.
Anyway, updating documents from a smartphone is difficult, so I think that if I were to operate it, it would be for things like publishing. I want to have a status in an arbitrary column of a spreadsheet, and have the flow be that when I trigger a change from draft to published, it updates my site. My site has a database, but you can't really operate that from a smartphone, can you? It's a hassle.
If that's the case, isn't it more realistic to be able to operate it via a spreadsheet? Since I plan to have note take on the role of a blog anyway, and considering that fixed articles will end up on my own site, I wonder if it's best to think of my site's database as a final repository, the notepad connected to Google Drive this time as notes that are still floating, and note as something that is floating but slightly caught.
I've typed in a huge amount up to this point saying, 'This has made things significantly more convenient, right?', but will the day actually come when I update this? (I am updating it, haha).

So, you're not going to write the code.
I'll break that down separately later. However, this time too, Chatty wrote almost all of it. I mainly just said I wanted to do this or that, or fought with it.


#What are you talking about

#Seeking knowledge
#Every day is like Indian summer

#Want to work efficiently


Well, if I had to say one thing, the annoying part about note is the line breaks; that's troublesome. It's also troublesome that you can't pour content in via HTML or Markdown.


Kumomisaki Town is here 🌙

いいなと思ったら応援しよう!