Choice is equal to time on a calendar

  • 16 July 2019
  • 1 reply
  • 10 views

Needing assistance with a form, the form is for a SharePoint calendar and on the form is a choice drop-down menu for selecting vacation 1-12. I only want to use the date field only without time, is there a way when someone selects vacation 1 from the drop-down menu to have the time equal 1 am to 2 am on the SharePoint calendar and vacation 2 equal 2 am to 3 am? (ect)  and once vacation 1 is selected for the day that choice is no longer visible.

Thank you 


1 reply

Userlevel 6
Badge +22
Hi,
This is a little tricky.
The easiest way to do this would be to have all the events already in the calendar.
When a day is picked all the events for that day would show in a drop down.
The dropdown would be filtered by the day and if the event was available.
When an event is chosen it already has the times so no need to worry about that bit. The form would update the event with a user. When a new form is opened and a day picked the lookup filters on that days events and if there is a user assigned or if all events have a default user any event with that default user is displayed.

Alternative method.
You could have the drop down with the 1-12 and depending on what is selected, Calcualted value controls referencing the dropdown could calculate times and add them to the start and end date columns.
How you would filter the drop down with which vacation is available I am not sure.

Reply