Hello everyone,
I’m looking to build a car service reservation form using ChronoForms and would like to know if it's possible to implement a feature where clients can select a specific date and time for their service appointment, and once chosen, that date and time is no longer available for other clients.
The idea is that when a client selects a date and time for the service, it should be checked against a database to ensure that the slot is not already booked. If the slot is already taken, the client should be notified and prompted to select another available time.
Can ChronoForms handle this type of functionality with custom validation or other integrations? What would be the best way to approach this setup, possibly involving custom PHP, AJAX, or database interactions?
Any insights or examples would be greatly appreciated!
Thanks in advance!
Hi Sirdna,It is without doubts possible. I have build an ERP for a shop with chronoform...(cash desk, purchases, sales, inventory, eshop, clients, payments, accounting, etc...) for one of my clients.
But you need to consider updates of chronoform versions as it could be quite painfull to transfert from one version to the other, unless at least untill Max improves that aspect.
Cheers
Hi
Sure you can, you need a database table for time slots, maybe 2 columns one for date and one for times, and another column for "taken", 1 or 0
Then on your form page submit a "Read data" action to check if the slot matching the selected date and time is taken or not, if taken then use a "Reload" action to reload the page, and if not then use a "Save data" action and set it as taken
You would not need AJAX for this if you do it the way I explained, and PHP may not be needed too
But you will need to create and fill the slots table, this can be done using ChronoMyAdmin easily from the Joomla admin area
