Hello I want to build a new form same as Leave and absence company calendar screen.
My requirement:
I have table for daily team meeting table have two fields one is worker field and the second one is date. I have button to generate data for each worker based on date range.
I want to show the user the record as column based so each worker will have one line in the form with multiple dates as the screen shot below.
the user should have the ability to change the cell under the date the cell will be enum(No/Yes) Yes means the worker attend the daily in that date and no not.
any hint please?
Thanks Martin
You could use a temporary table with a column for each date. Or create a grid with columns bound to edit methods.
Thanks. I want to go with the option grid with columns for dates. but the grid showing the data as rows how I can show it as columns?
Could we agree on that you actually want something completely different? You don't want a Gantt chart and you don't even want to a table with (multiple) rows, right?
The business requirement seems to be showing users a list of dates and allowing them to set a boolean value for each of them.
This can be achieved by many ways.
Don't immediately jump into implementation details of the first solution you can think of. Consider your options before choosing the best design for the given task.
Thank you for your reply. Yes you are right the standard form shows a Gantt chart i want to build the screen same as this chart but not chart as normal form the user can edit and save I looked into the table control but how I can define in the table what is the columns fields and what is the rows fields from my datasources
many thanks
You said you wanted the same thing as Leave and absence company calendar, but your requirements are actually very different.
The standard form shows a Gantt chart, while you want a matrix with editable checkboxes.
You could use a table control, for example. Of course, it's something that's almost impossible to make responsive - you can't expect to be able to easily work with such a table on a small tablet, for instance.
A better design for an individual user (not an overview of all users) may be simply a grid with two columns (the date and the value).
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,817
Most Valuable Professional
nmaenpaa
101,156