Scheduling Parent Conferences using #Google Forms #gtasyd

Can you make a way to let parents schedule conferences and know which time slots are available but not make the name of the student or parent visible?

Answer: One solution is to create a Google Form with the possible appointment times. From the spreadsheet where the parent appointments are gathered create a pivot table that counts the number of appointments per time slot. Unfortunately you can not share this pivot table since the sheet with all of the student names and parent names are visible in that spreadsheet. You will need to create a 2nd spreadsheet that uses the formula =importrange( to import in the pivot table. Make this 2nd spreadsheet visible. You may want to create a page on a Google Site with 2 column layout which has the 2nd spreadsheet showing the imported pivot table and the Google Form to sign up for the parent conference on the right side.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s