Page 1 of 3
Tips for making a weekly planner
Posted: Sat Sep 02, 2023 11:47 pm
by 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?
Re: tips for making weekly planner
Posted: Sun Sep 03, 2023 4:28 am
by steven
calida82,
Could you show us what you have done in Access?
It will help with suggestions.
Steven
Re: tips for making weekly planner
Posted: Sun Sep 03, 2023 8:07 am
by 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.
Re: tips for making weekly planner
Posted: Sun Sep 03, 2023 11:12 pm
by calida82
steven wrote: ↑Sun Sep 03, 2023 4:28 am
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
Re: tips for making weekly planner
Posted: Tue Sep 05, 2023 5:40 am
by 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
Re: tips for making weekly planner
Posted: Tue Sep 05, 2023 8:29 am
by kev1n
1 Browse is probably also sufficient. The columns can be dynamically selected in the BB event with PHP.
Re: tips for making weekly planner
Posted: Wed Sep 06, 2023 11:54 pm
by calida82
steven wrote: ↑Tue Sep 05, 2023 5:40 am
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
Re: tips for making weekly planner
Posted: Wed Sep 06, 2023 11:59 pm
by calida82
kev1n wrote: ↑Tue Sep 05, 2023 8:29 am
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?
Re: tips for making weekly planner
Posted: Thu Sep 07, 2023 5:02 am
by steven
calida82,
How many appointment slots are needed each day?
Steven
Re: tips for making weekly planner
Posted: Thu Sep 07, 2023 6:40 am
by calida82
10 maximum 15