Pivot Expense Split: Posting Unlimited Offline Transactions

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 expenses when your device came back online.

Now, Pivot Expense Split uses smart installable triggers that run one after another until all your 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 authorization which has been approved by Google today.

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 Calendar View

Getting Started

1. Get the Template if you haven't done it
   Download a copy from:
   👉 https://ko-fi.com/s/221bf4dca6

2. Install the To-do List Plugin
   From the Google Workspace Marketplace:
   👉 https://workspace.google.com/marketplace/app/todo_list_plugin/1001006504533

3. Set Up Your Copy

• Open your copied spreadsheet and move to where you like

4. 

• Rename it as you like.

• Go to File > Settings and update the Locale to match your region.

• Go to Extensions > To-do List Plugin > Plug in to initialize.

📩 Need Help?
Feel free to contact us at spcsoft.solutions@gmail.com for any questions.