nuBuilder Forum

calida82,

Thanks.

Can you tell me a bit more?

Who is it for exactly?
How many other tables like clients or practitioners need to be used? - Sorry, I only speak English.

What period do you need to see on the screen at a time?
What information needs to be kept for each slot?
I'm guessing they are half-hour slots.

Can you tell us everything you need?

Otherwise, it's hard to know how to help.


Steven

calida82 wrote: ↑Wed Sep 06, 2023 11:59 pm how would you make this with just one form browse? can you explain it better? would each row be a day of the week and the appointments would be horizontal instead of vertical?

Something like this? In my opinion, achieving this won't be a swift endeavor; it will require a substantial proficiency in SQL, PHP, and JavaScript.

I've created a proof of concept. The code is a bit messy and could certainly be optimised, but it's primarily a showcase to demonstrate that it can be done and how.

kev1n,

That looks great and would make a good template.


Steven

Kev1n this is awesome!!maybe you could share a sql backup here so I can download it

Give me some time to make some improvements.

While you wait, please let me know if you are missing any features or would like to see any changes.

It's all great and the approach to the problem is brilliant, just a small change... to display the date next to the day of the week. Only from the number of the week you always have to do the calculation and have a calendar nearby to understand which date corresponds to the day of the week.... one last thing, perhaps the most important, when you publish the code, I recommend many comments so as to understand how it works!

I've added the day of the week and commented the code. I will still need to tweak a few things.

Question: Where do you specify the duration of an appointment?