
Announcements
I have an overly simple microsoft forms questionnaire that I will add more to once I have it working. Right now it is simply a text form for your name, a date selection, a start time selection with options (9AM, 10AM, 11AM, 12PM, 1PM) and end time with options (10AM, 11AM, 12PM, 1PM, 2PM). Its used for requesting scheduling for an event. I am not sure if this is even the right way to handle using gather the time data.
I am having 2 problems. One is that when a new response is submitted, it is adding it to my calendar on the wrong day, always tomorrow no matter what I put in. I think I found a fix for that but I can't test it correctly because of my second problem. It is putting in the start time and end time ok though.
My second problem is that whenever I submit a new response, it is resending an earlier response to my calendar rather than a new one. Sometimes it was adding the new one and the original one as I was testing the logic of how automate works as I tweaked it. I only need them to to be added to the calendar one time, and if there is an issue with the time/date a user on my end will change it manually in the calendar. I am curious as to why it would do that. Am I not referencing the submitted new data?
I am also wondering if it is possible for myself or another user to view their requested time slot/date, and approve it before its actually added to the calendar? We wont get very many of these so it is manageable if its not the case.