To-do List Plugin template creation

When user select the plugin function from menu on a blank sheet, the add-on will ask if user want to have a template. If yes, a template will be created with instructions for user to trial.

To-do List Plugin checking updates on adjacent rows

Besides refreshing the row that has been edited, the add-on will also look for 20 rows above and 20 rows below for any updates.

To-do List Plugin Frequency Code

The To-Do List plugin supports the following frequency codes:

• d – Daily (excluding weekends)

• 1d – Daily (including weekends)

• nd – Every n days, where n is a number

• w – Weekly

• nw – Every n weeks, where n is a number

• m – Monthly (see Note 1)

• nm – Every n months, where n is a number

• y – Yearly (see Note 1)

Note 1:
If the current date is within 3 days of the end of the month, the next due date will preserve the same distance from month-end.

• For example, if the date is April 28, 2023 and the frequency is m, the next date will be May 29, 2023.

• If the date is April 27, 2023, the next date will be May 27, 2023.

First donor

I felt like a street performer who is looking forward for people to appreciate my work and pay for it. First donor finally came and donated $2 in Ko-fi using buy-a-coffee . Thank you to Aaron. Since PayPal deducted 38 cents, I added the payment link to Stripe.  

To-do List Plug-in User Defined Sorting

If a user wants to add a column to group their to-do list and sort by that group instead of the default sorting by status and date, they can follow the steps below:

1. Add the column, such as column E, and label it Group.

2. Run the Extensions > To-do List Plugin > Configure plug

3. Enter the Sort by column, such as E,C,A to sort by the Group, Status and Date.

4. Click the Submit button to update the sorting. The to-do list will be refreshed automatically, displaying the list according to the entered sort columns:

5. If a user wants to move the columns around, they can update the column letters in Configuration.

To-do List Plugin system flow diagram

Another banner is created for "To-do list plugin" to show how the plugin works.

Welcome

Welcome to my SPCsoft Galaxy home page! 

I graduated from computer science and found my passion on software development. I use Google script which is free to automate my day-to-day tasks. Rather than just myself using, I hope that my software can benefit the others. I put in effort and pay the costs to publish my scripts as add-ons to the Google Workspace Marketplace.

I produced my first add-on "To-do list plugin", followed by "My Report Runner". Both are verified by Google Workspace Marketplace for user installation. 

To promote the add-ons for simple, proficient and creative living, I set up this blog. I would appreciate your comments and your sharing of valuable user experience of my add-ons in this blog. 

I also set up donation links so that users can give their appreciation to cover my costs.