Form / Calendar Integrati
I'm working on developing an induction booking process that allows our team to book site induction through Smartsheets. Firstly, I intend to have a Smartsheet induction register that will include columns such as induction date, who the inductor is, requester, role, company, email address, etc. Any one who would like to book a site induction will be first required to fill in a Smartsheet induction request form and the content of the form will be quite similar to the induction register. Once the form is filled in, all the information gathered from the form will automatically be populated in the site induction register. Finally, I will integrate the schedule induction register sheet with Smartsheet calendar so that calendar can display important information from the sheet such as the no. of available spaces, venue, etc.
I have a couple of questions in order to make the steps described above to work:
1) Is it possible for the requester to be able to see the date that are available when they are the filling out the form? For example, dates that are not available are greyed out and are un-selectable and dates that are available are selectable and enter into the form when clicked. From another Smartsheet community discussion, I understand that a possible workaround would be to publish the calendar and the link to the form so that they could open the calendar and then the form. However, it would be amazing if we could let the requester see the available/unavailable dates without looking at the calendar. Is this possible?
2) How do I show in the calendar the available spaces for site induction? For e.g. the maximum no. of people that could have a site induction in one day is 25 and the total number of requesters we have received for a particular day is 22. How do I show in my calendar that there are three available spaces only?
3) Is it possible to have a different calendar Smartsheet rather than simply changing the view from grid to calendar? I would like a different calendar sheet that somehow manages to extract the key data from the Smartsheet induction register (no. of available slots, venue, etc.).