One Link Sign-up: 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.

Add-ons have been updated to ignore the 2nd submission.

SPCsoft Sign-in: Purpose of Sign-in

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.

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:

3. On the Splits tab, user can add additional columns at the end using ARRAYFORMULA on the first row for the whole column.

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. 

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:

Comfort Attendance: Take Attendance Faster with Linked Attendees

For group of attendees coming together, Comfort Attendance displayed them in a row so that greeter can take attendance for all of them quickly.

When an attendee brings in guests, greeter can use the + icon on the left hand side of the attendee to input guests.

It will display a guest form for entering the guest names. An example below is entering Bessie Slater:

When guests are submitted, they will be linked to the attendee, such as Bessie Slater being displayed with Anthony and Kimbery. Bessie is added the bottom linked with Anthony and Kimbery as in below:

Anthony and Bessie will be updated as present automatically. 

Next time, greeter may not remember Bessie. Greeter can look up Anthony's row and recall Bessie to check them in together.

 

Pivot Expense Split: Publication Approved on the Google Workspace Marketplace

Our new Google sheet add-on Pivot Expense Split has been approved by the Google Workspace Marketplace today. 

We will provide more templates. Please leave comment on what template that you want first.

Personal Investor Lab: Now Support Cryptocurrency

CoinMarketCap API is supported to retrieve the market price. History can be retrieved from Google Finance or Yahoo Finance. To track cryptocurrency, please follow the steps below:

1. Configure the lab - enter the crypto link, select CoinMarketCap and enter your API key. 

2.  On the Dashboard sheet, enter the cryptocurrency ticker used by Google Finance formula. 

3. Select the cryptocurrency cell and run the Renew dashboard function from custom menu. The history will be saved in the Cache sheet.

4. Change the ticker to CoinMarketCap format and input the currency name.

5. Enter cryptocurrency to Activity sheet.

6. On the Dashboard sheet, select any range to run the Renew dashboard function. The Listed Holdings will show the cryptocurrency. When running the Refresh holding price function, the CoinMarketCap API prices will be retrieved and linked to the site.