Date and time in Web Form Builder -...

User 2982483 Photo


Registered User
43 posts

Eric, this is great and very much what I want.

At my end it worked although it throws out a couple of errors that you may already be aware of: "Your form could not be submitted for the following reason(s):" and ""Select an available Time" doesn't have a valid value."

Maybe there could a separate read only calendar to represent the booked dates or a pop up if the dates are taken, thinking out loud here. Can the db be checked before hitting the submit with say 'check dates' button.
These thoughts are probably making this a nightmare task.

Anyway, again your time on this is much appreciated.
User 187934 Photo


Senior Advisor
19,984 posts

I fixed the validation problem. The form.cfg.php has to be altered because of the dynamically created values in the Time select.
The calendar can be altered to only show dates that have times available.
Can you tell me a day or time schedule that you want?
Which days are open for scheduling?
What is the time range for appointments during each day?
How long for each appointment?
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2982483 Photo


Registered User
43 posts

Hi Eric, OK so Monday to Friday and times will be hourly and only between 9.00am and 6.00pm with the possibility of a break between 12.00 and 1.00pm (Lunch).

Thanks again.
User 187934 Photo


Senior Advisor
19,984 posts

Made adjustments to scripts based on your thinking out loud.:lol:
Current dates and times in database.
Select 05-30 and there's no times available because all hours are booked.
2022-05-27|11:00
2022-04-25|09:00
2022-05-01|14:00
2022-05-03|13:00
2022-05-30|09:00
2022-05-30|10:00
2022-05-30|11:00
2022-05-30|13:00
2022-05-30|14:00
2022-05-30|15:00
2022-05-30|16:00
2022-05-30|17:00

Weekends disabled
No appointments at 12:00
https://ericrohloff.com/coffeecup/ccfor … me-picker/
If you go to Sept, Oct, and Nov you'll see a few dates disabled. I added another database to add manually disabled dates.
Take a look and see if there are more adjustments needed.
Holidays?
Manual Block of days?
Manual Block of appointment times?
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2982483 Photo


Registered User
43 posts

Really great this Eric.

You preempted my next question with your last three questions and yes there will be a need to add unforeseen appointments either by teacher or student, and manual blocks of appointments is a must.

This is most definitely what I wanted when first posting and I can't thank you enough for the time you've put in, it's really appreciated.

User 187934 Photo


Senior Advisor
19,984 posts

Will unforeseen appointments still be on the hour? If the unforeseen appointment is not on the hour, we need to think of a way to handle the request by the teacher or student. Blocking is not an issue when the teacher can submit a separate form to the blocking database table.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2982483 Photo


Registered User
43 posts

OK, I think that we will stick with 'on the hour' . I'm sure the teacher will be happy with that. Keeps things simple and uncomplicated.

Thanks.
User 187934 Photo


Senior Advisor
19,984 posts

I'm almost there. My host is down at the moment. I'm putting in some validation scripts. I'll have a test example as soon as they come back online.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2982483 Photo


Registered User
43 posts

You are a star, thank you so much for all the time and effort Eric.
User 187934 Photo


Senior Advisor
19,984 posts

I'm having a Form Builder bug issue. I opened a support topic but I'm also trying to hack my way around it.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com

Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.