Create new form to have the design as table

(0) Share

Report

Posted on by yousefsuli

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?

8156.timesheet.png

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Martin Dráb 239,178 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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).

Was this reply helpful? Yes No
yousefsuli 55 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Martin Dráb 239,178 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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.

For example, you can use a grid with a row for each date.

You can just use checkbox controls, bound to edit methods.

You could use a grid with columns for dates.

You could use a table with a single row only.

You could give uses a drop dialog where they can set a value for a date, or a range of dates.

And so on.

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.

Was this reply helpful? Yes No
yousefsuli 55 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,178 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

You could use a temporary table with a column for each date. Or create a grid with columns bound to edit methods.

Was this reply helpful? Yes No
yousefsuli 55 on at

Like (0)

Report
Copy link

Link copied!

Thanks Martin

Was this reply helpful? Yes No