Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Create new form to have the design as table

(0) ShareShare
ReportReport
Posted on by 55

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

  • yousefsuli Profile Picture
    yousefsuli 55 on at
    RE: Create new form to have the design as table

    Thanks Martin

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 230,817 Most Valuable Professional on at
    RE: Create new form to have the design as table

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

  • yousefsuli Profile Picture
    yousefsuli 55 on at
    RE: Create new form to have the design as table

    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?

  • Martin Dráb Profile Picture
    Martin Dráb 230,817 Most Valuable Professional on at
    RE: Create new form to have the design as table

    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.

  • yousefsuli Profile Picture
    yousefsuli 55 on at
    RE: Create new form to have the design as table

    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

  • Martin Dráb Profile Picture
    Martin Dráb 230,817 Most Valuable Professional on at
    RE: Create new form to have the design as table

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,817 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans