Integration with Google Calendar (or any other calendar)

We have recently completed an integration to Google Spreadsheets, but have no plans to build an integration with Google calendar. You could use a separate database or another form to hold reservation “slots”. There are probably a number of ways yo accomplish it, here is one idea:

Create a “Time Slot” form. Create a connection to the form. In your main form when a user requests a time slot send the day and time in the connection. If nothing is returned, you know the slot is available. When the user confirms the time slot request use a Show Form to create a new instance of the Time Slot form. Send Day, time, and any other relevant information as custom parameters. When the Time Slot form opens use Set Field objects to get the custom parameters and then submit. You could even use Set Field in other instance to clear the time slot if the user changes their mind or someone else does it for them.

It would be much harder to search for a specific combination of date and time within a single instance. They would have to all be in a table. If each instance only has those parameters/fields once they will be fast and easy to search.