I have the following columns (column types):
- Meeting Start Date (Date)
- Meeting Start Time (Time)
- Meeting Duration (Time) ?
- Meeting End Time (Time)
- Meeting End Date (Date)
- You will see that I have purposefully made Meeting Duration a time column type and not a duration column type.
- I have done so as I would like to be able use the “time selector window” or any other similar type setup to be to input duration vs needing the user to manually input the hours and or minutes and possible make a mistake.
- I however think that maybe the time column type is not the ideal choice for my use case for the following reasons:
- I will be limited to hours / minutes withing a day. Not sure how am I going to handle meetings that span over more than one day
- I think the expression I want to use in my below use case scenarios will not work if Meeting Duration is a time column type.
Below are two use case scenarios when I am entering data in my form:
Scenario 1 Meeting Start and End Date are within the same day:
- I select the date and time in Meeting Start Date & Start Time. Then for example I select 1 hour and 30 min (i.e 01:30) in Meeting Duration column and then I have an initial value expression that calculate the Meeting End Date & End Time columns factoring in the values that where added to the Meeting Start Date & Start Time columns.
Scenario : Meeting Start and End Date span over more than one day:
- In this scenario I would input Meeting Start Date and Time as well as Meeting End Date and Time and the Duration initial value would calculate the duration, but to be honest I think if the initial value used return “All Day”…it would be better option.
I also do not know if the column type I select for Meeting Duration can handle both a time format needed for Scenario 1 as well as be able to input “All Day” in Scenario 2
Any advice on how best to go about this?