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 sorting sequence configuration

 User can define additional columns as needed. For example, user can add a column for priority. The "Configure plug" function is now having a field "Sort by column letter(s)" for user to sort as required.

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.  

Welcome

Welcome to my SPCsoft Galaxy home page! 

I graduated from computer science and found my passion on software development. I use Google script which is free to automate my day-to-day tasks. Rather than just myself using, I hope that my software can benefit the others. I put in effort and pay the costs to publish my scripts as add-ons to the Google Workspace Marketplace.

I produced my first add-on "To-do list plugin", followed by "My Report Runner". Both are verified by Google Workspace Marketplace for user installation. 

To promote the add-ons for simple, proficient and creative living, I set up this blog. I would appreciate your comments and your sharing of valuable user experience of my add-ons in this blog. 

I also set up donation links so that users can give their appreciation to cover my costs.

To-do List Plugin system flow diagram

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