Tips for making a weekly planner

[steven]

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

[kev1n]

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?

ezgif.com-video-to-gif.gif

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

[kev1n]

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.

nubuilder_weekly_calendar.zip

[steven]

kev1n,

That looks great and would make a good template.


Steven

[calida82]

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

[kev1n]

Give me some time to make some improvements.

[kev1n]

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

[calida82]

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!

[kev1n]

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

[kev1n]

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