Calendar View & Booking

stuartr
stuartr ✭✭✭✭✭✭
edited 12/09/19 in Smartsheet Basics

Hi - our company is looking to hire out a hospitality box in London for a 12-month period that hosts events all year round. We would like internal employees to be able to view the event calendar and to book slots for a specific date where they can then invite their own external customers as well as internal guests. In the calendar view we need to be able to see the event name and the number of remaining spaces available in the box on that day (ideally without clicking through to open the row/form details below - its an "extra click" after all :-) ).

I am aware that we could create a dashboard with calendar on the left and a booking form on the right, but are there any other ways of supporting this? Is there any way of making the calendar view interactive (i.e.clicking on the event and date in the calendar itself to open up the booking form and advising of remaining numbers so that they dont try and book for more guests than can be accommodated). Any help would be appreciated.

Comments

  • Alejandra
    Alejandra Employee

    Hi stuartr,

    Since the bar in Calendar View only displays information from the Primary Column, you could consider using the JOIN function (in the Primary Column) in order to display the event name and to the number of remaining spaces available.

    To do this, you'll want to create a new column to store the event name. You'll also want to have the event name and the number of remaining spaces in adjacent columns.

    If the event name and the number of spaces remaining are not in adjacent columns, you could also just use + (the plus sign) to concatenate text like this:

    =[Event Name]@row + [Remaining Spaces Available]@row

    Also, there currently isn't a way to create an action when selecting a taskbar in Calendar view. When you have a moment, submit a Product Enhancement Request to let our Product team know that you'd like to have this functionality in Smartsheet.