First you need to identify what data is going into those columns. For this example, I will use a table called “Columns” but you could something like activities for time reporting.
Select the Column(s) you want to see in the grid.
Then, using my “Employees” table, show the columns I selected.
Use a decision step to determine which columns to hide/show.
Attached is the concept and flow used to accomplish this. There really is nothing dynamic about it, but it can be done, even if it is pretty hard.
Let me know your thoughts.
Dynamic Columns.flow (123.2 KB)
Clever! Thanks for sharing.
just another idea:
(some history first ) way back in the day for a certain project we wanted to display all the days of the month in a datagrid as columns (so that we can show reported hours for each day) and the problem was that number of days varied.
So our idea was to create a datagrid “template” with 31 columns and then dynamically fill in data (both column names to be days of the week and the hours as values) or leave the last columns empty (if the month has 30, 29 or 28 days)
So we were gonna do something like this (with a bit of scripting):
At the end we gave up on this idea at that project (customer didnt like how it looked in webclient, with 31 columns webclient added the scroll bar and that was too ugly for them)
but…the idea lives on
Hope this helps!
Test dynamic columns.flow (45.6 KB)