To-do List Plugin Enhancement: Capture Tasks Quickly, Organize Them Later

Sometimes, a task suddenly comes to mind, and you just want a place to jot down its description quickly, perhaps on your phone. You may not have a date, priority, or other details in mind at that moment.

As a user shared, she often enters task descriptions as they come to mind and go through the list later in the day to add dates, priorities, and other details.

In response to this feedback, the Configuration has been enhanced with an option to switch off Auto-fill date for new row.

When this option is unchecked, the following behaviors apply:

1. No automatic date carry-over for new row

The date from the previous task will not be carried over to a new row. You can simply enter the task description and leave the date blank.

2. A scratch area at the top for new tasks without dates

Undated rows at the top become a scratch area for capturing tasks that need further attention. Sorting starts from the rows below the last undated row. 

3. Complete task details at your own pace

Later, when you have time to organize your tasks, you can add dates, priorities, or other details, whether the task is at the top or in the middle of the scratch area.

The sorting boundary will remain unchanged, so your updates will not be disrupted by sorting. Only when the updated rows become connected to the sorted range will the sorting range expanded upward.

In summary, this enhancement gives you two working areas in your to-do list: a scratch area at the top for quickly capturing tasks as they come to mind, and a sorted area below for tasks that are organized.Capture first, organize later — at your own pace.

To-do List Plugin: Smart Refresh Enhancement to Support Multiple To-do Tables

Smart Refresh in the To-do List Plugin has been enhanced to support multiple to-do tables, allowing you to organise your tasks into separate sheets, such as Personal, Work, and Teammates.

To create an additional to-do table, follow these steps:

1. Right-click the to-do sheet tab and select Duplicate.

2. Rename the duplicated sheet.

3. The configuration will be applied to the new to-do table automatically. All tables share the same configuration.

4. Run the Configure plug function to adjust the Smart Refresh settings, including the refresh idle and warning times.

When to-do table is first updated, a Smart Refresh menu will appear on the screen. You can move it to a convenient empty corner. The timer displays the remaining seconds until the next refresh. Click Now to initiate the refresh.

One Link Sign-up: Migration from Sheets to Tables

One Link Sign-Up has now been migrated from Sheets to Google Tables. All your data can be kept in a single sheet, while you can still store your own notes outside the tables in the same spreadsheet.

The web app setup has also been simplified, so you can get a basic sign-up web app up and running in about 2 minutes.

Try the link below to copy a template and follow a few simple steps to give the add-on a try. I hope you find it useful!

https://docs.google.com/spreadsheets/d/1YacmNGZZy9wmpoRoTsIEGxrtjiGN_k-SFpuBvlxcLoc/edit?gid=1873387799#gid=1873387799/copy

Comfort Attendance - Reminder for User to Add Attendance Column

When all available date columns in the Attendance sheet have been filled, Comfort Attendance Web App cannot find a column with a date of today or later. It will display the following error message:

Date column with a date of today or later was not found for updating attendance. Please check your Attendance sheet and configuration.

For a better user experience, Comfort Attendance Web App will display the very last column of the Attendance sheet. When you see the attendance which has been taken in the last available column, you will be reminded to add a new date column at the end of the Attendance sheet.

Comfort Attendance: QR Code Migration

Google web apps have disabled camera access for newly created web apps. As a result, a newly created web app will not be able to open the camera.

Comfort Attendance has been enhanced to open the QR code scanner in a separate window, and the QR code scanner is now working properly.

A demo is available here:

https://spcsoft.pages.dev/gso?mne=CFA&fid=10L1aPxv5KHdK5i44wWKGY3bRrdfcPN8m4j4Hq1ov_O0&key=MTBMMWFQQVQ=

The new QR code scanner can be opened by clicking the circled icon below on the demo web app:

The new scanner provides status update selection and information:

Personal Investor Lab: User Deployed Web App

Personal Investor Lab can run as a library, allowing users to create a simple Apps Script project that uses the library. Once the script is deployed as a web app, its URL can be entered in the Personal Investor Lab configuration.

With the user's authorization to access Spreadsheets and Drive, the user's web app can copy charts to alert reports, save the reports to the folder where the spreadsheet running the add-on is located and can be used to resume at timeout in addition to the trigger.

How to Set Up the User Script

1. In your spreadsheet, click Extensions > Apps Script.
2. In the left-hand menu, click Libraries +.
3. In the Script ID field, enter id obtained from spcsoft.solutions@gmail.com
   
4. Click Look up.
5. Click Add.
6. Replace the existing code with the following:

function doGet(e) {
  return SPCsoftGateway.doGet(e);
}

function doPost(e) {
  return SPCsoftGateway.doPost(e);
}

7. Click the + (Add a service ) next to Services and add Google Sheet API.
8. Click the blue Deploy button in the upper-right corner.
9. Click New deployment.
10. Click Select type > Web app > Execute as: Me (user) Who has access: Only myself
11. Click Deploy.
12. Under Web app URL, click the Copy icon, then paste the URL into the Personal Investor Lab configuration.

To-do List Plugin - Support Multiple To-do Sheets

To-do List Plugin has been enhanced to support multiple to-do sheets. This allows you to categorise the to-do list with teammate, personal and work, etc in separate sheets.

Please follow the steps below:

1. Click on the to-do sheet tab and duplicate the sheet.

    

2. Change the sheet name.

3. Run the Configure function to enter to-do sheet names, separated by commas.

4. Make sure all to-do sheets have the same format and configuration. 

5. The Plug in, Configure plug and Unplug functions will run on all defined to-do sheets.

6. The Refresh function will run on the active to-do sheet only.

7. The log will include the to-do sheet name in front of each task.