1 Topic by simokami (edited by simokami 2025-04-17 12:54:24)

  • Registered: 2023-12-26
  • Posts: 8

Topic: Customizable Monthly Work Schedule Table with Dynamic Row Generation

Hello MVD friends,

I'm working on creating a dynamic monthly schedule form, similar in style and layout to the Excel image attached (see below). I need your help to develop a solution (Table grid or something else ) that behaves as follows:

*What I want to build:
Dynamic row generation based on the selected month:

When I choose a month (e.g., Avril), the table should automatically generate 30 or 31 rows, depending on the month selected.

For February, it should support 28 or 29 rows (leap year logic).

The row number represents calendar days (1 to 28/30/31), and each row represents a daily work report.

*Customizable at any time:

I want to be able to add or remove rows manually.

Switching months should reset the rows accordingly, or optionally keep data.

Any help, please ?
Thanks in advance

Post's attachments

Attachment icon Sans titre 2.jpg 158.36 kb, 10 downloads since 2025-04-17 

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,897

Re: Customizable Monthly Work Schedule Table with Dynamic Row Generation

Hi,
Have a look at the attachment as an example.
First generate a range of dates on 'FormSetUp' - it can be for any length of time and doesn't have to be for a specific month.
Then on Form1, simply use the 'From' and 'To' date range to display your work schedule form (doing it this way gives you more flexibility as you could have weekly, monthly, annual schedules etc - or for whatever range of dates you require).
However, if you only ever need a ''month'' work schedule, you could simply replace the ''from'' and ''to'' date filters with a single date filter formatted as ''month/year''.
If anything is not clear, just shout.
Regards,
Derek.

Post's attachments

Attachment icon schedule form (2).zip 440.12 kb, 36 downloads since 2025-04-18