SPCsoft Galaxy Updates

The To-Do List plug-in was published in October 2022. As of today, it has reached over 8K users

 

We sincerely thank our users for their support. Thanks to you, we have reached 4% of our $800 fund raising goal.

To-do List Plugin: Customize Header Task Name and Color

 You can change the header task name and color to what you prefer.

Please follow the steps below:

1. From the menu Extensions > To-do List Plugin, click “Unplug.”

2. Change the header task name and color as desired (for example, as shown below).

3. From the menu Extensions > To-do List Plugin, click “Plug in.

Comfort Attendance: Enhanced Configuration Options

For one-time attendance where the column header does not contain a date, you can enter the column header in the configuration as shown below:

If you are using a Google smart table, which does not support date objects, you can also enter the column header and manually update the configuration each time you take attendance.

On the name column, you can use labels such as “Total”, etc. In the configuration, simply provide the first label that marks the end of the attendance name list.

Personal Investor Lab: Introducing the New Charts Tab 📈!

Your alerts and chart images are now automatically saved in the new Charts tab when you renew the dashboard — making it easier than ever to track and review your investment insights. The Dashboard buy and sell alerts have been linked to the charts. 

✨ Tip: To ensure charts are generated and saved, clear the “Stop showing chart when selecting more than…” setting or increase its limit.

Comfort Attendance: Zoom and Linked Attendees Optimization

When the number of attendees exceeds 100 and linked/associated attendees are displayed horizontally, the table can become quite large. On some mobile devices, this may temporarily freeze the page and require a double tap to resume interaction.

The web app has been enhanced to improve usability and performance:

• A- / A+ controls are now available to zoom out and zoom in the attendee table smoothly.

• Linked attendees are displayed only when an attendee is clicked, reducing initial layout complexity and improving responsiveness.

These improvements help maintain smooth interaction and better performance, especially on mobile devices with large attendance lists.

Comfort Attendance: New Central Web App

Comfort Attendance now supports a Central Web App alongside the User Web App, making setup faster and dramatically reducing deployment effort for casual users.

One Link Sign-up: New Central Web App

One-Link Sign-Up now supports a Central Web App alongside the User Web App, making setup faster and dramatically reducing deployment effort for casual users.

One Link Sign-up: Dashboard and Integration with Google Calendar

To demonstrate the extensibility of One Link Sign-up on Google Sheets, a new template has been created featuring a dashboard and Google Calendar integration. Additional integrations can be implemented as your requirements evolve.

A. Dashboard

It comes with a ready-to-use dashboard that you can expand at any time as your needs grow.

B. Integration with Google calendar

Ready-to-use calendar scripts are built directly into your sheet, giving you a solid foundation you can easily extend — no extra permissions needed during the add-on installation!

What’s included in the scripts:

• onSignUp (e): Automatically updates the online sign-ups to a calendar which you can share with others.

• Sync with calendar through the “1L Sign-up” custom menu: you can tabulate and filter sign-ups and sync to a shared Google calendar.

Why it’s great on the injected scripts to your sheet:

• Transparent — You sees in the scripts exactly how your calendar permission below will be used.

• Flexible — You can customize or extend the scripts.

• Powerful — You can add features like email alerts or custom menu actions further.

🛒 Get the template here: 👉 https://ko-fi.com/s/ac6f6d8d93

To-do List Plugin: Template with Smart Refresh and a Calendar View

 A new Smart To-Do List Plugin template is now available — it includes a user controlled smart refresh drop-down and a calendar view to help you control refresh and visualize your tasks!

You can easily control the refresh and see which tasks are completed and which ones are upcoming in the next few days.

🛒 Get the template here: 👉 https://ko-fi.com/s/5d3873c5de

Your purchase directly supports my work and helps me keep developing more features for you.

Seeking Your Support for SPCsoft Galaxy — Together We Can Serve More!

Starting in August 2022, I finally have had some personal free time to follow my heart. I use my technical knowledge to create and publish simple Google Sheets add-ons that support the people and communities around me.

I never imagined they would grow this much, but over time they’ve reached far more people and communities than I expected. I’m deeply grateful to everyone who has supported my vision. Your feedback and encouragement continue to inspire me to keep improving and creating.

Among them, the To-do List Plugin, One Link Sign-up and Comfort Attendance have become the most popular, with around 7K+, 2K+ and 1K+ downloads so far. It’s been amazing to see how something that started as a personal vision could help so many others. Thank you to users who spare the time that they have saved from using my add-ons to give back their encouraging reviews on the Googe Marketplace. 

The add-on blog has reached 38K views from people around the world.

And most importantly, thank you to my nine supporters on Ko-fi who helped me reach 1% of my goal to keep Serving People and Communities moving forward. Every bit of financial support means a lot and keeps me motivated to continue building and sharing more tools that make everyday tasks a little easier.

I’ll keep learning, improving, and sharing what I build — and I hope these small projects continue to grow and help more people and communities along the way.

To-do List Plugin: New Release Notice on Smart Refresh and Flexible Location

The To-do List plugin uses the onEdit trigger to refresh your to-do list. This trigger takes a few seconds to reach Google’s server before the refresh starts. During this short delay, you can continue making multiple updates to your tasks. However, you’ll need to wait for the refresh to complete before making further edits. It is not user friendly for bulk updates, you have to unplug and plug in which is also not convenient.

Because data transmission depends on Google Sheets’ network speed, there is currently no way to improve this delay. Therefore, a new Smart Refresh mode has been developed and is undergoing a pilot testing. 

---

✨ What’s New

A. Dropdown to Control Refresh

A new refresh control dropdown has been added at the top of the task header which works for desktop browser and mobile app.

It has the following options:

1. 🎬 Refresh now

Informs the server to refresh.

2. ☰ Auto refresh

Automatically refreshes whenever an edit is received from the server.

3. ☰ Smart refresh

When an edit occurs, the task header will show:

• Desktop: Refresh when idle for 20s. Select this cell to refresh now.

• Mobile: Refresh when idle for 20s. Use the above dropdown to refresh now.

After 20 seconds of inactivity (idle):

• Desktop: Idle detected – refresh in 10s! Select this cell to refresh or any cell to skip.

• Mobile: Idle detected – refresh in 10s!

After 10 more seconds (30s total idle), the server will automatically start refreshing.

• Desktop/Mobile: Refreshing ... update now not captured.

4. ☰ Manual refresh

The server will not refresh automatically — only when 🎬 Refresh now is selected.

B. Flexible to-do list location

You can now put your to-do list anywhere with other information that you are working on.

 

---

Pivot Expense Split: Posting Offline Transactions at Reconnection

Google Sheets mobile + offline mode + installable onEdit triggers is a known and tricky behavior. Here’s a breakdown of why offline to online sometimes get two triggers and sometimes none:

🔍 1. Why it happens

a. Offline edits don’t fire any triggers immediately

When offline, the app records the edits locally; installable triggers (like onEdit(e)) only run on the server.

So while offline → no trigger.

b. When reconnecting

When the mobile app resyncs: 

• Sometimes Google merges the edits into one sync event → fires one onEdit trigger per edited cell.
• Sometimes it batches multiple cell changes → causing multiple triggers (e.g., one per cell).
• Occasionally, the sync process is treated as a programmatic update (not user edit) → no onEdit at all.

This depends on:

• How long the sheet stayed offline.
• Whether the same range got multiple changes.
• Connection stability and Google server sync timing.

🧪 2. Observed patterns (tested behavior)

Scenario Offline duration Action                         Result

Short offline (few seconds) Small edit (1 cell)         Usually 1 onEdit

Long offline (many edits) Multiple cells                 Often no trigger or 2+ triggers

Reopen sheet after being         Edits in different areas    Sometimes fires all at once or none

fully closed offline

🕒 3. When sync happens automatically

Offline edits made on the mobile app are synced when all of the following conditions are true:

1. Internet connection restored

• The device must be connected to the internet (Wi-Fi or mobile data).
• Sync typically starts within a few seconds to a few minutes after the connection stabilizes.

2. Google Sheets app is active or in background

• The app must be open on the sheet, or at least allowed to run in the background.
• If the app was closed or background activity is restricted (by battery saver, etc.), sync waits until the app is reopened.

3. Google account signed in & online

• The account used for editing must still be logged in and authenticated.
• If sign-in expired (common after long offline periods), sync waits until you reauthenticate.

4. No sync conflict

• If someone else has also edited the same range while you were offline, Sheets may delay syncing until it resolves the conflict (which can cause the “Version conflict” prompt).

🔍4. Implication for add-ons or triggers

Installable triggers like onEdit, onChange, or time-based triggers see the updates only after the sync upload completes.

That’s why offline edits sometimes trigger two onEdit events, or none at all, depending on how Google merges them when reconnecting.

⚙️5.  Pivot Expense Split Enhancement

Use an onChange(e) installable trigger which fires when the structure or content of the sheet changes, even after sync. It will trigger once per batch sync instead of per cell. The following is scripted to post offline input at reconnection.

function onChange(e) {

  if (e.changeType === 'EDIT') {

    // handle sync edits here

  }

}

⚠️ It doesn’t give e.range like onEdit — only that something changed. 

Pivot Expense Split: Posting Timeout

Previously, Pivot Expense Split relied on a simple Google onEdit trigger, which only runs for up to 30 seconds. That wasn’t enough to handle offline input when device came back online.

Now, Pivot Expense Split uses installable triggers for longer runtime and will create another triggers until all offline transactions are fully posted. This means you won’t have checkboxes remain in Input tab when back to online.

The use of installable trigger requires new permission which has been reviewed and approved by Google today. When you run the add-on, Google will prompt you the new permission for your authorization.

To-do List Plugin: Logging the Date When the User Checks the Box to Mark a Task as Done

Inside the TDL log, Google’s history records the date when a task was logged. For users who want to analyze trends, it is more useful to store this date in its own column. Therefore, the date when the user checks the box to mark a task as done is now added to the log.

Please update your TDL log header as follows:

Date – the original task date
Repeat On – the updated task date based on the frequency code
Completion – the date when the user checked the box to mark the task as done

Comfort Attendance: Support for Multiple Attendance Statuses

You can configure custom statuses starting with the default Absent and Present. Additional statuses like Picked Up can be added to suit your needs.

Clicking a name will cycle through the statuses and loop back to the beginning. Alternatively, you can open a dropdown list to select a specific status.

You can fully customize the status code, label, color, and icon to fit your needs.

Each status has the following attributes, listed in quotes and separated by commas:

• Valid code on the sheet

• Label, color, and icon, which are displayed on the web app page for that status code

The web app will update Google attendance sheet and dashboard accordingly.

Setup instructions and details in Comfort Attendance Setup > Option 2.

One Link Sign-up: Enhanced Web App Setup Flow

The Set Up Web App function has been enhanced to support both Automatic and Manual deployment options.

Automatic Deployment: Quickly deploy with default settings for a fast and hassle-free setup.

Manual Deployment: For technical users who want full control over deployment configurations.

This enhancement gives you flexibility to choose the method that best fits your needs.

Comfort Attendance: Enhanced the Web App Setup Flow

The Set Up Web App function has been enhanced to support both Automatic and Manual deployment options.

Automatic Deployment: Quickly deploy with default settings for a fast and hassle-free setup.

Manual Deployment: For technical users who want full control over deployment configurations.

This enhancement gives you flexibility to choose the method that best fits your needs.

To-do List Plugin: Supports the "Format → Convert to Table" Feature

🆕 To-do List Plugin Now Supports the "Format → Convert to Table" Feature

The plugin now works seamlessly with Google Sheets' "Convert to table" format.

• You can add a new table row by clicking the ➕ icon.

• As a result, an extra blank row is no longer required.

• If you prefer not to have a blank row automatically inserted, simply uncheck "Insert task when blank is filled" in the configuration sidebar below.

To-do List Plugin: Template with a Calendar View

A new To-Do List Plugin template is now available — it includes a calendar view to help you visualize your tasks!

You can easily see which tasks are completed and which ones are upcoming in the next few days.

🛒 Get the template here: 👉 https://ko-fi.com/s/221bf4dca6

Your purchase directly supports my work and helps me keep developing more features for you.

To-do List Plugin: New User Preferences

Configuration has been enhanced to support user preferences.

If "Move completed task to log sheet" is checked, completed tasks will automatically be transferred to the log sheet.