Matrix grid

2
I have an entity which registers dates and hours spent on these dates on projects. I would like to show the days of the week on colum level header and the projects as row headers, the cells should be data-entrieable. As far as i know, this is a matrix. It looks like someone did a similar request https://community.mendix.com/questions/2331/Question-about-datagrid-functionality-revisited and I am nuisant whether there is a control or some trick, I would love to have the link
asked
3 answers
2

Hi Johan,

Here are two pictures, one of the Time Writing form and one of the datamodel for Work, the module for Time Writing.

Is this the info you are looking for?

Ciao

Toon

answered
3

Hi Johan,

I created the sort of Matrix you are looking for to register time spend on tasks in a project. The basis is the normal grid with editable columns for the days.

The table behind the grid consists of project and task columns and day columns, monday to sunday.

Of course, this table is not good for other purposes than the registration of work hours, as the registered hours are spread over a number of columns. I use this table as a temporary table, just for registration purposes. On commit the hours are registered in another table that holds the work hours per day, task and project.

A long answer to say, no, I don't think a Matrix widget exists, but there are ways to work around that.

Cheers. Toon Verschoor

answered
0

Sounds good Toon, am I right you did it by altering the entity model into separate attributes for monday, tuesday etecetera? so you denormalized it to create a matrix effect?

answered