One Link Sign-up web app set up procedures

For the first time to set up a web app on your sign-up Google sheet, Google has quite a number of steps to protect you and to secure your sheet. Once complete, you can re-use the sheet for future sign-up without all the steps.

Please be patient to follow the steps below. If you have any queries, please email spcsoft.galaxy@gmail.com for support. 

1. On Google drive, click the + New button.

2. If One Link Sign-up is not yet installed, go to Google Workspace Marketplace to install it.

3. Click the Google Sheets item to open an Untitled spreadsheet.

 

4.Click Extensions, move the mouse to One Link Sign-up and click the Set up web app function.

5. Select a template

6. Wait for the sidebar to display

7. Follow the steps in sidebar to input your web app sign-up page title and press the Enter key.

8. If Step2 is displayed, do the following:

    (a) click the Enable button.

    (b) Click the Google Apps Script API bar.

    (c) Review the Google message. Hold cursor on the blue dot moving it to the right.

    (d) Click the Create button.

9. You are almost done! For the scripts which you have just created to sign-up sheet, Google requires you to authorize it for web access.

    (a) Click the Authorize button to open up your sign-up sheet in new window.

    (b) On the new window, wait for the 1L Sign-up custom menu to display.

    (c) Click the 1L Sign-up > Authorize.

    

    (d) Review the Google message and click OK.

    

    (e) Choose your account

        

    

    (f) Google verified the scripts in add-on but not the scripts in your sign-up sheet. Review the Google message which is on your sign-up sheet and click Advanced.

    

    (g) Review the Google message and click Go to xxx (unsafe) where xxx is your sheet. 

        

    (h)  The scripts inside your sign-up sheet will update the sign-up sheet and use external service to allow web access. Review the Google message and click Continue.

    (i) Review the Google message and click Allow.

10. Back in the new window, click the Deploy function to deploy your authorized web app scripts to internet.       

      

11.  Click the Open button to open the host's sign-up web page and bookmark this host's link for re-entry. 

    

Congratulations! You have finished all the setup steps to create a web app on a sign-up sheet that you can invite people to sign up online. 

The steps below are for testing the web app online sign-up.

1. On the host's sign-up web page, sign in from your account.

    

2. From the host view, click the Open one link sign-up page button.

3. The sign-up page from one link is displayed. Bookmark this link for testing sign-up. 

4. After testing, modify the demo sign-up sheet data and send the saved link to invite sign-up. Enjoy your sign-up on Google sheet.

One Link Sign-up basic template and template selection

 A basic template is added for user who just needs a simple sign-up sheet. 

A new selection table is added for user to select the most appropriate template to start with and customize the sign-up sheet further as needed.

 

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 published to 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.