Posts

How I Replaced Evernote with Google Drive (Part II): App Script Code

In the first part of this article , I explored my decision to free up from Evernote to a custom solution using Google Drive. I set up a simple workflow with Google Sheets to organize tasks, categorize projects, and link other Google Docs and Sheets. Using conditional formatting and custom columns to visually manage priorities, due dates, and tags, worked well but still required manual effort. Here Google Apps Script came handy to automate tasks like creating files, adding links, and setting calendar events, creating a powerful solution only with Google Drive. In this update, I’ll include the overall explanation of the App Script code used to automate tasks for the workflow I used to finally replace Evernote with Google Drive. Parameters To configure the script without altering code directly, there is a 'Parameters' sheet where some configuration will be performed. Column “A” has the name of the parameter to be referenced in the parameters array (see Utilities section).  Column

Changing the World One Sheet at a Time
The use of technology to save the planet

Technology not only transforms the way we work but can also drive solutions for real-world problems, even those that seem unchangeable as we are too used to them. In this article, I’ll share how a technology solution based on smartcards helped improve the operations of an agricultural support company by reducing paper usage and facilitating resources distribution in rural areas. Myself a Software Engineer Throughout my career, as a Software Engineer, I’ve had the opportunity to work in several industries, developing software solutions that not only optimize processes but also improve people’s lives, having also the opportunity to travel to other countries and meet other cultures. Today, we see software and technology everywhere, transforming the world around us, and I have been part of that change. One interesting project I worked on took place in a company that supported farmers in managing their crops. In this company, agronomists who supervised the harvests, filled out paper forms

How I Replaced Evernote with Google Drive: A Simple Workflow for Managing Notes

Image
For years, I relied on Evernote to keep my notes organized and manage my to-dos. But with recent limitations on the free plan and frustrating sync issues, I knew it was time for a change. After trying out several other apps, I landed on a surprising solution: Google Drive. Why I Needed an Evernote Alternative I used Evernote in a straightforward way—mostly plain text notes organized into projects. But I ran into two major issues: recurring sync errors and new restrictions on the free version, which meant I couldn’t create or sync new notes the way I used to. How I Used Evernote In Evernote, I organized my notes into notebooks (which I treated like projects) and included the following elements: Title : Often with a date in the format YYYYMMDD for sorting. Note content : My to-dos or details related to the project. I also used tags to organize notes based on: Priority (P1 to P5) Location (Home, Work) Timeframe (Today, This Week, This Month, No Date) Evaluating Evernote Alternatives Wh

The story of how I invented Google Maps

This is how I [ almost ] invented Google Maps. The untold story of an application that could have been... I really hate political campaigns. Don't you? TV ads, radio spots, verbal attacks, political dirty war, and recently, even physical attacks (if not worst). But above all, visual and physical pollution all around the city streets . Am I wrong? Maybe it would be different if each political party cleaned the city of posters, garbage and billboards, but it seems not like that... They usually leave all the cleaning responsibility to the mayor in turn. How do they spend their budget? Idea Origins Plato said: our need will be the real creator . Around 1997 there were state elections in Nuevo León, Northern Mexican state ,  and it happened that the city was filled with billboards, posters and other physical publicity. Keep in mind in '97 there were no social networks and advertising was really different. Faced with this problem and as a good Computer’s Engineer as I am, I came up w

My Backup script for Mac

Recently I bought an external disk of 1 terabyte. This comes to replace my old 250 MB disk. The fists thing I made was to format the disk and create 1 partition to store all the information. As I wanted to use the disk with Mac and PC, I formatted it as NTFS. I also acquire a Mac utility to support writing to NTFS. The disk worked fine until I tried to use backup tools for Mac. Most of the backup tools for Mac require a disk formatted in Mac format. But in my case it is NTFS. A solution might be to create 2 partitions, one for Mac and one for PC, but the one of Mac might not be available in PC. Still I want the compatibility with both systems. My backup requirements for Mac were easy: Back up only data files Maintain only the image at the time the backup is made Do not backup OS and Apps. In case of failure, those can be restored from the installation disk and packages. I was about to format the disk with the 2 partitions when I realize I already had 500MB of information in the