Blocking out multiple hours after input

[Kevin_Higley]

I have a form that takes a time input, and I would like to “block out” 2 hours of time from that input.
So, if the user inputs “9:30”, I want the Calendar to show 9:30 to 11:30. Right now it just show up as 9:30-10:00 (30 minutes), I think…

[Marc_Dillon]

You see how Calendar Views have these selections for indicating which column to use as your calendar event ranges?

You just need to add a second column that is the first column, plus 2 hours, and set that for the End Time

[Kevin_Higley]

Thanks for that suggestion. I added a second column in the data source sheet, but that column is not showing as a selection to “set for the End time”…I am very new to this AppSheet stuff (only been on it for 2 days…). So I am not sure just what to do.
Thanks for your input

[Kevin_Higley · Accepted solution]

Figured it out. Not sure if that is what I was supposed to do, but I went to the data table, made the new column “show” able, and then “save”. Then wen to the calendar view, and it was “selectable”, then went back to the data table, and unchecked “show”. Now it seems to show just as I wanted…

Thanks again.

[Marc_Dillon]

Kevin_Higley:

made the new column “show” able, and then “save”. Then wen to the calendar view, and it was “selectable”, then went back to the data table, and unchecked “show”. Now it seems to show just as I wanted…

You got it. Appsheet doesn’t allow you to use hidden columns for certain things, but it DOES allow you to hide a column once it is set in one of those spots. Just a weird little quirk.