One Link Sign-up adding to pesonal calendar

On the sign-up confirmation page, a new button Add to calendar is provided for signer to update his/her calendar and to set up email/notification reminder.

Sign up example:

1. Sign up Chairperson by a tick.

2. Sign-up confirmation with a Add to calendar button.

3. Add to calendar options.

4. Add to Google calendar.

Delete sign-up example:

1. Delete sign-up by a tick.

 

2. Delete sign-up confirmation.

One Link Sign-up has been approved for publication on the Google Workspace Marketplace

A new Google sheet add-on One Link Sign-up has been published. The aim of this add-on is to give signers the best convenience. 

From this add-on, host can filter posts for his/her social media group, such as WhatsApp group, to create a one link and share the one link page with the groups. 

From the one link, signers can sign up and maintain their sign-ups online. Signers are authenticated by Google sign-in and their sign-ups are with the host's Google sheet and their privacy on sign-ups are protected. 

This add-on was submitted to Google Workspace Marketplace for review on Nov 24, 2023 and got approved on Dec 4, 2023.

To-do List Plugin customization for color coding such as tasks due in 1 week, 2 weeks, etc

 1. Click on the Date column to select the whole column.

2. Right click on the selected column to select "Conditional formatting".

3. Click "+ Add another rule".

4. On Format rules, select "Date is between".

5. Enter the formula below for due in a week and click Done.

6. Date is color coded

If you want to color code the task column, it can be code by Custom formula =AND(A2>Today(), A2 <Today()+6) to below:

Have fun on conditional formatting! 

Freedom Data Import demo on importing data from internet data table

Another demo sheet with examples to get all currency exchange rates, major currency exchange rates and specific currency exchange rate is added to the 'Try demo" function. It demonstrated how to get data from an internet table, filter the required data, to a table or to a cell.

Freedom Data Import new function "Try demo"

 A new function "Try demo" is added to menu. User can copy an Expense summary demo sheet and data sheet to try out.

Freedom Data Import system flow diagram

The download count on "Freedom Data Import" has over 100. Thank you to all your download. I created a gif banner to expain how it works.

To-do List Plugin template creation

When user select the plugin function from menu on a blank sheet, the add-on will ask if user want to have a template. If yes, a template will be created with instructions for user to trial.

To-do List Plugin checking updates on adjacent rows

Besides refreshing the row that has been edited, the add-on will also look for 20 rows above and 20 rows below for any updates.

To-do List Plugin Frequency Code

The To-Do List plugin supports the following frequency codes:

• d – Daily (excluding weekends)

• 1d – Daily (including weekends)

• nd – Every n days, where n is a number

• w – Weekly

• nw – Every n weeks, where n is a number

• m – Monthly (see Note 1)

• nm – Every n months, where n is a number

• y – Yearly (see Note 1)

Note 1:
If the current date is within 3 days of the end of the month, the next due date will preserve the same distance from month-end.

• For example, if the date is April 28, 2023 and the frequency is m, the next date will be May 29, 2023.

• If the date is April 27, 2023, the next date will be May 27, 2023.

First donor

I felt like a street performer who is looking forward for people to appreciate my work and pay for it. First donor finally came and donated $2 in Ko-fi using buy-a-coffee . Thank you to Aaron. Since PayPal deducted 38 cents, I added the payment link to Stripe.  

To-do List Plug-in User Defined Sorting

If a user wants to add a column to group their to-do list and sort by that group instead of the default sorting by status and date, they can follow the steps below:

1. Add the column, such as column E, and label it Group.

2. Run the Extensions > To-do List Plugin > Configure plug

3. Enter the Sort by column, such as E,C,A to sort by the Group, Status and Date.

4. Click the Submit button to update the sorting. The to-do list will be refreshed automatically, displaying the list according to the entered sort columns:

5. If a user wants to move the columns around, they can update the column letters in Configuration.

To-do List Plugin system flow diagram

Another banner is created for "To-do list plugin" to show how the plugin works.