Form Approvals
November 2, 2022
When first setting up the add-on, we recommend have it create events when "form submissions are received" so events are created immediately.
If you don't capture an End Date, the add-on allows you to use formulated columns also. So, to do this you simply need to add a column to your spreadsheet that calculates the End Time (by adding 30 mins or 1 hour to the Start Time) using the ARRAYFORMULA. Then, use this formulated column for the End Time within the add-on. For example, your formula would look similar to =ARRAYFORMULA(IF(D2:D<>"",D2:D+TIME(0,30,0),""))
Regards,
Morgan