Announcements
No record found.
Hi,
I want to add a few columns in the grid of my form at runtime. I am creating an inquiry form, in which on the basis of the user's selected values, I need to filter results. I need to show all sizes of the dimension group attached to the item. There can be more or fewer sizes present in the item, and then I need to create that number of columns in my form and then add their values in total. Below is the picture for illustration.
I want to add a few columns in the grid of my form at runtime. I am creating an inquiry form, in which on the basis of the user's selected values, I need to filter results. I need to show all sizes of the dimension group attached to the item. There can be more or fewer sizes present in the item, and then I need to create that number of columns in my form and then add their values in total.
Hi partner,
Please check computed columns:
docs.microsoft.com/.../data-entity-computed-columns-virtual-fields
In this case I think you can consider to add all the field to the grid but then have the logic in form's code to hide or show the fields based on your number of sizes for the items.
To hide a column in X++, you can try something like this:
MyTable_ds.object(fieldNum(MyTable, MyField)).visible(false);
Regards,
The best approach likely is creating a matrix report instead of using a form. If you want interactive filtering, Power BI will be better than SSRS.
If you want to use a form and you need a dynamic number of columns, I can think of two solutions:
Below are two options :
1) Check if you can create report to achieve this.
2) If report is not an option then go with Table control. we have achieved something like this in one of the implementation using table control.
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 608
André Arnaud de Cal... 591 Super User 2026 Season 1
CP04-islander 430
