One Link Sign-up is a Google sheet add-on. It provides a web app front-end on your sign-up sheet that anyone with the web app link can sign up, maintain his/her sign-ups online. This add-on is configurable and your sign-up sheet is customizable. Signers are authenicated by Google sign-in.
This add-on will display a sidebar to guide the initial one-time web app set-up.
Frequently asked questions
What is One link sign-up?
One link sign-up is a Google add-on. It runs on your Google sign-up sheet where you keep all the data. At set-up time, a web app front-end is created. The web app link can be sent via email, Facebook, Twitter, blog, poster, newsletter, etc. to invite sign-up. Invitees can use the link to sign up anywhere and anytime, click a button to add the sign-up to their calendar and set up email/notification reminder, delete their own sign-ups, view other sign-ups if set up for collaboration.
How is it different from other sign-up websites?
One link sign-up is designed from volunteers' sign-up perspective to have the best viewing, sign-up and collaboration experience in one link.
Host defines access key which filters posts applicable to a social media group and send the specific 'one link' for them to sign up. Public post has name started with * which will always be included for sign-up.
For team collaboration, intra/inter team sign-up status is given to volunteers in the same link. Public post that has blank in the no. of slots field (unlimited) are excluded.
Sign-up data are resided in your Google account that you can leverage Google sheet functionalities to process them, customize the sign-up sheet and have the customization effective on the web app front-end for collecting data and tracking whatever information is needed.
It is free and there are no ads. What is the catch?
It has no plans and catches. This add-on is free for personal non-commercial use. Other users can donate if they want for ongoing support and enhancements of this add-on.
Do my invitees need to open an account?
Invitees need a Google account to authenticate his/her identity. If they don't have a Google account, they can sign up for one which is free.
Can I limit who can sign up?
You can limit the access to your web app for invitees within your domain by the following steps:
- On your sign-up sheet, select Extentions > Apps Script > Deploy > Manage deployments > edit icon (a pencil next to ?).
- On Version, select New version.
- On Who has access, select Anyone within (your domain name).
- Click the Deploy button.
Can I customize my sign-up sheet? What can be customized?
Yes, you can customize your sign-up sheet and the sign-up configuration. The following can be customized:
- Change column name which becomes field name on web app
- Add column which becomes additional custom field on web app
- Rearrange columns in Google sheet which resequences the fields on web app
- For team collaboration, configure what sign-ups can be shared intra-team and inter-team.
- For privacy, configure what sign-up data to be displayed on sign-up web page.
Can I extend the automation on sign-up activities?
Yes, in your sign-up spreadsheet > Extensions > Apps Script, there is an onSignUp (e) hook. You can add scripts to extend the automation on sign-up activities, such as sending out email confirmations, update on waiting list, etc. Please feel free to contact developer if you need sample scripts and deployment steps.
Can I set up waiting list?
Yes, you can set the slot (s), the no. in waiting list (w) and list label as (s+w label), such as 2+1 👨🚒standby. If label is not defined, it will be ⏳waiting list.
When someone deletes his/her sign-up, those in the waiting list will move up automatically. Both the deleted sign-up and the sign-up no longer in waiting list will be recorded in Log sheet for onSignUpLog (e) to process.
How does it work?
Host adds a New > Google sheets> Blank spreadsheet, installs this add-on, runs the custom function Set up web app, follows the sidebar instructions to create the web app link which will open up the sign-up sheet on web for creating access links and sending to invitees for online sign-up.
Invitees click on the link and authenticate themselves by Google sign-in/sign-up which is free. They can then see and sign up through the web page to the sign-up sheet.
Both host and invitees can delete sign-ups online.
Is there any reminders for my sign-up invitees?
For your peace of mind, One link sign-up add-on does not ask for authority to send email from your Google account. At sign-up confirmation, an Add to calendar button is provided for invitees to add to his/her calendar where he/she can set notification/email reminders.
If needed, your sign-up spreadsheet > Extensions > Apps Script has the authority to send email. You can create time trigger and scripts to read data from your sheets to send out reminders. Please feel free to contact developer if you need sample scripts and deployment steps.
Who is it for? Do you have some testimonials?
Anyone who wants to automate their sign-up Google sheet and provides the online access to invitees.
No testimonial yet. Please provide yours in Google Workspace Marketplace > review so that this add-on can serve the others.
How can One link sign-up help?
If you have challenges on keeping track of sign-up through back-and-forth emails, phone calls, and voicemail, One link sign-up is quick and convenient, and will save you time and money.
Are there any limits on sign-up sheets and number of rows?
Not from One link sign-up as long as you are within the Google services quotas.
How do I edit a sign-up sheet?
Just edit as in your other Google sheets.
How to delete a sign-up?
Host can edit the sign-up sheet directly or delete any sign-ups through the web app. Invitees can delete his/her sign-ups only.
Is there a sign up template I can use?
Yes, when you run the set up web app, enter the keyword 'event', 'class', 'serving' or 'potuck' to your spreadsheet name. Template will be populated accordingly for your trial. You can change the name to anything afterward.
How to install?
- Open a new Google Untitled spreadsheet.
- Go to Google Workspace Marketplace to install this add-on. After Installation, your sheet menu Extensions will have this add-on menu One Link Sign-up . If not, please re-open your sheet.
- From the menu, select Set up web app and follow the steps displayed on sidebar to complete the set-up. Based on the key words ('serving', 'potluck','class') in your sign-up spreadsheet name, demo data will be populated for your trial. The demo templates have below:
- Class enrolment with waiting list
- Sunday serving schedule
- Potluck with signer's inputs
- Event or roster
How to use?
- From the add-on menu > Set up web app, click the button Open to sign up and view your sign-up page.
- On the field Select, enter '*' to select all posts. Otherwise, use the following to search/filter posts for a destinated group:
- - is exclude. For example, '-abc' means excluding posts that have 'abc'.
- | is or condition. For example, 'abc|xyz' means posts that are having 'abc' or 'xyz'.
- ' ' is quoted words. For example, 'abc xyz', means posts that are having the words 'abc xyz'.
- Click the button Submit.
- Click the button Open one link sign-up page to view the sign-up page.
- Use the browser Share this page to copy or send the sign-up page to the destinated group.
- Repeat the above steps if you have other targetted groups.
- Try the demo data first. When you have tried all, you can customise the sheets and test further. If everything goes well, replace the demo data with your real data in Sign-up and Post sheets. Create one link, share it to your groups and start having their online sign-ups.
Support Post install tip Privacy policy Terms of service
No comments:
Post a Comment