Need a form to send employees for availability
I'm having trouble creating a form that we we will send all 6 employees that will display all our new upcoming events and they can choose which ones they can attend. When I send the form to employee #1, I don't want the other employees to see what they have chosen. I do need their results to automatically come into the sheet that has the events listed. Once I receive all responses, I will be able to see each event and each employee that can attend.
Is this possible? All I see in Forms is all the fields from the sheet are listed for them too fill out, not choose from a list of events. I'm lost!!
Answers
-
Hi @RCC Admin
The best way is to use a multiple-dropdown list, but parsing the result can be a bit tricky.
So, I advise you to use a sheet like this.
Then, summarizing the survey result is straightforward, as shown in the Sheet Summary fields.
Form Image
Form settings.
-
It's a bit tricky, but the form that lets your employee choose from a list of events is like this.
You need to set the Event column to a multiple-dropdown list.
Then, a sheet to summarize the result is like this.
-
Thank you. This was helpful. I followed the info and it works pretty well except for a couple of issues: the Event Name has to be the full name of the event or the employee won't know the details. It has to show the event date, name and time. I don't see any other way to give that info on the form. It works well for events with very short names, but the longer ones won't fit correctly. Maybe I need a different form layout or something?
Also, the email that the employee receives after submission that shows what they choose, is not readable. To copies all the events flushed together over on the left side so that the info appears scrambled and unreadable.
Any suggestions?
-
Try a multi-select dropdown column with the various options entered in the column properties instead of separate columns for each option.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives