Thank you all who installed One Link Sign-up.
Thursday, April 3, 2025
Wednesday, April 2, 2025
One Link Sign-up and Comfort Attendance exception "A sheet with the name "xxx" already exists. Please enter another name."
Thank you to Lisa who contacted developer on the exception.
From Google execution log, the setup function submitted the createTemplateForm twice. The exception came from the 2nd submission.
Both add-ons have been updated to ignore the 2nd submission.
Thursday, March 13, 2025
One Link Sign-up and Comfort Attendance Google Sign In Purpose
The web app sign-in page has been updated below to clarify the purpose and scope of access:
Why Sign In?
Signing in with your Google account allows the web app owner to know who’s using it. Google controls the access and won’t share your Gmail, Drive, or other app data with this web app. Your data stays private and secure.
Friday, February 7, 2025
Pivot Expense Split template for personal income and expenses
Pivot Expense Split can now support personal income and expenses. Please find the template in the setup page.
This template has the following features:
1. Input tab supports multiple entries. After entering the transaction, ticking the checkbox will submit.
If column G (frequency) is not empty, only the amount will be cleared.
Please note that checkbox is reserved for submitting the transaction entry.
2. User can define the account, category and currency in tables for the transaction input:
If ARRAYFORMULA is not allowed, such formula containing AND or OR, user can define the formula in from first row to last reserved row in the column.
Thursday, January 23, 2025
Pivot Expense Split template for household income and expenses
Pivot Expense Split can now support household income and expenses. Please find the template in the setup page.
This template has the following features:
1. Input tab supports multiple entries. After entering the transaction, ticking the checkbox will submit.
If column J (frequency) is not empty, only the amount will be cleared.
Please note that checkbox is reserved for submitting the transaction entry.
2. User can define the account, category and currency in tables for the transaction input:
Sunday, December 1, 2024
Pivot Expense Split has been approved for publication on the Google Workspace Marketplace
Our new Google sheet add-on Pivot Expense Split has been approved by the Google Workspace Marketplace today.