Google Workspace Marketplace
Schedule session rosters from the registration information from a Google Form™. Automatically schedule sessions rosters choosing from multiple available activities. Checks room capacity.
개발자:
정보 업데이트:2025년 7월 15일
호환 기기:
7만+
개요
Planning a fun day or event with multiple activity options over multiple sessions? For example a school having a fun day with a rotation of activities. This Add-on collects NO user data. NO PII. Take the registration information from a Google Form™ and automatically generate session rosters. 

This Google Sheets™ Add-on is for the Form Responses from a Google Form™ with exactly one Multiple Choice Grid type question. Activity options are provided in the rows of the Multiple Choice Grid question. Column options allow the participant to rank their activity choices. For example, 1st choice, 2nd, 3rd.

In the Google Sheet™ with the Form Responses as the first tab, use the Extensions menu to select Scheduler by Alice Keeler. Setup the schedule. This will add a sheet with a grid of the activity choices and number of sessions. Fill in the room capacity for each activity and session. 

After participants have completed the registration/interest form, run sessions using Scheduler by Alice Keeler to automatically assign participants to an activity based on the availability of room in the session activity and preferred choice of the participant. 

Scheduler by Alice Keeler cycles through the activity list looking for participants 1st choice and if there is room in that activity assigns them to the session roster. It then cycles through looking for 2nd choice, then 3rd, etc.. until the participants are assigned a session activity. 

Due to room availability and participant choice selections some sessions slots are not assigned to a participant. Scheduler by Alice Keeler allows you to easily review which sessions still have room and assign to individuals. Option for mass assigning remaining participant slots to sessions that have room.

Create a schedule per participant in a Google Doc™ and email them their schedule of activities. 

Create a spreadsheet. per activity with a tab for each session and the list of participants in that session. 

BONUS FEATURE: for ANY Google Form™ get a list of who did NOT fill out the Google Form. Add a sheet to your Form responses spreadsheet that contains the email addresses of who you expect to fill out the Form. 

Check out more of her Add-ons at http://alicekeeler.com/codedbyalice
추가정보
가격유료 기능을 포함한 무료
개발자
비사업자
지원
개인정보처리방침
서비스 약관
Scheduler 🗓️ by AliceKeeler에서 아래에 표시된 권한을 요청합니다. 자세히 알아보기
Scheduler 🗓️ by AliceKeeler에서 Google 계정에 액세스해야 함
이렇게 하면 Scheduler 🗓️ by AliceKeeler에서 다음 작업을 할 수 있습니다.
모든 Google Docs 문서 확인, 수정, 생성, 삭제
모든 Google Sheets 스프레드시트 확인, 수정, 생성, 삭제
Google 애플리케이션 내 메시지 및 사이드바에 외부 웹 콘텐츠를 표시하고 실행합니다.
외부 서비스에 연결
부재중에 이 애플리케이션을 실행하도록 허용
내 이메일 주소로 이메일 보내기
기본 Google 계정의 이메일 주소 확인
개인정보(공개로 설정한 개인정보 포함) 보기
리뷰
언어:
정렬 기준:
Google에서는 리뷰나 평점을 확인하지 않습니다. 리뷰에 대해 자세히 알아보기
댓글 없음
검색
검색어 지우기
검색 닫기
Google 앱
기본 메뉴