I recently upgraded to the newest Data Grid Web version (2.22.0) and I'm seeing the message Please Fill Out This Field message for blank columns marked mandatory (outlined in red) as was referenced in the release notes. But when I mark the fields in the associated structure as non-mandatory and refresh references and republish, the "mandatory" message is not going away. I primarily use grids for reporting and not data entry, so I would like to have this message be suppressed. What is the recommended way of doing that? Is there some other setting I need to look at?
Hi @Lennie Sutton
As you can see by the release notes, Wijmo Flexgrid made some changes that created some side effects and changes in terms of behavior:
This can fit your use case.
Other than that, there's also an issue that will be fixed in a patch release that will be released between today and tomorrow.
As a workaround, you can try to add the value isRequired: false in the AdvancedFormat property of the Column block.
isRequired: false
AdvancedFormat
Hope it helps.
Cheers,GM
Changing the structure attribute to non-mandatory did not prevent the "Please Fill out this field" on fields where null text values were present. Updating to 2.22.1 did not change the behavior. However, your suggestion regarding adding isRequired: false to any fields where a null value may appear does resolve the display issue. Thank you!
Best regards,
Lennie
@Lennie Sutton could you share a sample oml with your use case so we can analyse it?
Thank you!
GM,
Here is a sample. I've observed that the red boxes only go away when I set Editable and Allow Delete to true. (Attribute 2 column) In my case, I have all my columns in the data grid with these values set to False as I'm using it for reporting. Even though my structure has all the columns set to mandatory = No and I've added the "isRequired: false", the red boxes persist when the Editable and Allow Delete are set to false. Version 2.21.5 and before does not have this issue.
LS
Thanks for sharing the example that we'll analyze. Those conditions you mentioned are aligned with the changes introduced by Wijmo Flexgrid, which are noted in the release notes (we can try to add more details in the release notes).
Hi, @Gonçalo Martins ,
Thank you for analyzing this issue!
After some experimentation, I found that updating Allow Delete = True (leaving Editable=False) was enough to remove the red boxes from blank/null fields in the data grid. The mandatory indicator on the structure's attribute seemed to have no bearing on the display. If isRequired: true in the AdvancedFormat section of the attribute, then the red boxes do appear, but if it is false or not present, then the red boxes go away (as long as Allow Delete = True). So I will change our standard procedure of making non-editable columns also non-deletable to set their Allow Delete attribute to True since this gives us the desired user experience and doesn't appear to adversely affect how we want the user to interact with the grid.
Does this rationale match how you see this new behavior in the current version of the data grid module?
Best regards,LS
Sorry about the late reply but that's exactly the case you described. That aligns with what we discovered from the changes introduced by Wijmo Flexgrid.
Best Regards and thanks for the collaboration,GM