One Link Sign-up archive function

Each sign-up event has a start date. Although past events will not be displayed, they affect the response time to show outstanding events. The Archive function below will improve the performance by moving the expired sign-up records from Sign-Up sheet to the Archive sheet.

To-do List Plugin setting cell location after refresh

A new column is added at the end of the to-do list to mark the cell location after user edit. When onEdit is triggered, this column will momentarily contain an indicator '<=' to mark the row which should be located after refresh.  

One Link Sign-up templates for event, class, serving schedule and potluck

One Link Sign-up has configuration and is based on Google sheet which is also customizable. For beginner, please use the sign-up templates with sample data provided at the initial web app set-up time. Template is provided according to the key words 'Event, 'Class', 'Serving', 'Potluck' that is entered to the spreadsheet name. Current templates have below:

1.    Events - single/multiple activities

2.    Class - single/multiple classes with automated waiting list

3.    Serving schedule - recursive serving with sign-up status for collaboration

4.    Potlucks - potlucks with input fields for invitees to provide what dish will be brought

After knowing the basic, user can customize the sheet and re-configured the add-on for what are needed.

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.