Chinese New Year Gathering - Visitor Tracker

Covid-19 restriction means this year's CNY gathering is going to be especially tough in terms of tracking who's coming and fairly allocating the slots to family and friends.

In light, the Immortalize team has decided to share the excel sheet that we use to manage our CNY visiting with you. Simply follow the instructions below to use or download the template to share with your loved ones!  

Step 1: Download the form

Step 2: Use the form to manage your household visiting or put it on google sheet for a group of people to sign up.

 

How to use the form?

1. Insert your guest's name

CNY 1.PNG
 

2. As you add the name, "Taken slots" will increase and"Remaining slots" will decrease. When "Remaining slots" reaches zero, the cell will turn red to alert you that there's no availability for the day. 

CNY 1.PNG

How to add to google sheets and share it with people? 

2. Create a new blank sheet

CNY 2.PNG
 

3. Click on File -> Open -> Upload and open our template that you have downloaded. 

CNY 3.PNG
CNY 4.PNG

4. Click on "Share". 

CNY 5.PNG

5. To keep the spreadsheet private, add emails of those whom you want to share with.

CNY 6.PNG

6. To allow anyone who has the link to book their slots, click on "Change to anyone with the link", copy link and share it with the right people. You can set permission such that anyone with the link is be able to view, comment or edit.

CNY 6.PNG
CNY 7.PNG