Tagged: calendar integration
This topic contains 3 replies, has 2 voices, and was last updated by Dennis @ PerfectForms 7 years, 5 months ago.
- AuthorPosts
- September 6, 2013 at 8:30 am #6738
I’ve been asked to work on a form that allows the user to reserve dates and times. Ideally, I’d like to be able to present the user with a calendar that shows all the reserved times so they can choose from what’s available. Has anyone tried integrating with or connecting to Google Calendar or something similar? Or even doing it all in PerfectForms? I could keep track of the dates and times in a database but I’m wondering if there’s a calendar app that could do it for me, and just hook PF into it.
September 6, 2013 at 9:52 am #6742We 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.
September 16, 2013 at 2:47 pm #6763Thanks for the info, Dennis.
What’s the purpose of having the “Time Slot” form open a new instance? Why not just do it all in the one instance?
September 16, 2013 at 3:01 pm #6765It 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.
- AuthorPosts
You must be logged in to reply to this topic.