X++ code to set the fields group dynamically in form

(0) Share

Report

Posted on by Community Member

Hi All,

1. I have created a form myForm of a tempTable myTable which have 130 fields and 20 fields groups with different fields.

2. Now added all the fields groups in the grid and want 18 fields group to be dynamically visible based on value of one field in the form.

Please guide me to achieve this functionality.

Thanks in Advance!!

Aimon Fatima

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Martin Dráb 239,660 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I wonder how many fields you'll have there, but even if just a single field in each group, eighteen fields sounds like too much for a sigle grid to be useful. I think you should review if your design really leads to good user experiences.

You can call visible() method on individual form fields, which is a very common technique. I assume you could also set AutoDeclaration = Yes on those groups in the grid and call their visible() methods instead of doing it for individual fields. Simply try it to know it for sure.

Was this reply helpful? Yes No
André Arnaud de Cal... 305,394 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Aimon,

I do agree with Martin. Are you intending to have potentially all 130 fields visible on the grid at once? Can you tell a bit more about the business requirement here? Is it to display e.g. transactional data for reporting purposes?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Yes Martin, I have set AutoDeclaration = Yes for all fields groups and I have different no. of fields in the field group.

Okay, the requirement is myForm is called from a parent form mainForm where it has a field "A" which is a Lookup of tableA which have 7 enum fields A1,A2,A3,A4,A5,A6,A7 with value All, Half and one. 12 fields for ALL, 6 for half and 1 field for one should be visible according to the selected enum value.

So for 7 enum fields with 3 different scenario which make total of 121 fields and have 18 different fields group with all scenario separately.

eg: created 3 different FieldGroups of A1 for 12 fields , 6 fields and 1 fields, and same for all other fields

On form only 1 scenario will be fulfilled, so for that case I have to call corresponding field groups which I have created for that combination at time.

Was this reply helpful? Yes No
Gao Lu Wang 194 on at

Like (0)

Report
Copy link

Link copied!

Hi Aimon,

If my understanding is right, you need to put 7*3=21 field groups in the grid. In the extreme scenario you have to make 12*7=84 fields to display in the grid.

As Martin and André mentioned, the grid should not hold too many fields. I think it really has bad affect on the performance .

Customer may no need to see all fields in the grid,can most fields be put in detail form than the list?

Was this reply helpful? Yes No