[kleung]

Hi,

In working with spreadsheets, it is a common practice to merge some consecutive cells of a row for presenting groups of data that follow .
How can we do it similarly in grids in Dynaform?

cheers,
Karl

[ronrich]

Hello Kleung,

There is not an out-of-the-box option to merge cells, but if you are first having the grid in a form showing the data spread into different cells in a row, you could use a trigger and code the logic to loop the grid, concatenate the columns/cells in a single value with the wished format and then build the multidimensional array for a new grid that will only have the new grid structure with the merged columns/values.

You'll find some documentation on how to interact with the grid using PHP in triggers in the link below:

https://wiki.processmaker.com/3.1/Grid_Control#PHP_in_Grids

I hope that helps.

Best regards,

[kleung]

Hi Ronrich,

I'm sorry that the merging of the cells is not only on data calculation, but also for clearer presentation.
Your proposed method seems only allow data calculation.

Another view of the problem is to control the row widths of grid cells such that the selected rows of the two grids are aligned with each other. But this will lost the convenience of grid properties.
However, grid row widths alignment seems impossible in dynaform as well.

cheers,
Karl

[ronrich]

Hello Kleung,

In that case, perhaps you may want to consider using a panel and use HTML to render the data, you can also an external lib that will allow to have extra functionality on tables, perhaps the table plugin for jquery could help.

Kind regards,

[kleung]

Hi Ronrich,

Thank you for your advice.

cheers,
Karl