Tips for making a weekly planner

[calida82]

as the title suggests I need to create a weekly planning agenda. I made one with access and I thought I'd proceed in the same way but if anyone has already made one and would like to give some advice it would be appreciated. I was thinking of doing that. a single table containing the date, time and memo text of the appointment in a launch form I place a text field with today's date and six browse modules (one for each day of the week except Sunday) in iframe mode. each module has in its select the condition that the first module shows the appointments of today's date, the second those of today's date + 1 the third today +2 and so on...
It might work?
are the fields of the browse form single-line only or can multiline be set as well?

[steven]

calida82,

Could you show us what you have done in Access?

It will help with suggestions.


Steven

[kev1n]

Your plan will definitely work that way. But I am not sure if it is performant, because each iframe is loaded separately and there can be some delay in loading. And yes, you can Set it to multiline using css.

[calida82]

calida82,

Could you show us what you have done in Access?

It will help with suggestions.


Steven

PLANNIG ACCESS.jpg

this is my plannig in access you can't see all the days because my notebook screen is small

ACCESS-2.jpg

clicking on the day opens a popup where you can insert/modify/cancel the appointment

[steven]

calida82,

I agree with kev1n, If you can get it working fast enough.

We would love you to share it with the rest of the nuBuilder community as a Template.

It would be very helpful.

Templates have been discussed recently here... viewtopic.php?t=12076.


Steven

[kev1n]

1 Browse is probably also sufficient. The columns can be dynamically selected in the BB event with PHP.

[calida82]

calida82,

I agree with kev1n, If you can get it working fast enough.

We would love you to share it with the rest of the nuBuilder community as a Template.

It would be very helpful.

Templates have been discussed recently here... viewtopic.php?t=12076.


Steven

I'm working on it for half an hour in the evening. I know little about both php and javascript so I won't be very fast but as soon as I'm done I can share it, if it can help someone else I'll do it gladly

[calida82]

1 Browse is probably also sufficient. The columns can be dynamically selected in the BB event with PHP.

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?

[steven]

calida82,

How many appointment slots are needed each day?


Steven

[calida82]

10 maximum 15