How to hide table columns, but show them in edit/add dialog?

Hello,

I'm using a DataGrid to display a model (Account) that has a large number of fields. I've hidden some of the columns by specifying "visible=false", so that the table fits on the screen. However, I want users to be able to edit ALL fields, even if they're not visible on the main table. I also want users to have control over all fields when adding a new row. I'm using "mode=Dialog" for my edit settings.

To be clear, I do NOT want to create two custom templates (for the edit and add dialogs respectively), because that's unmaintainable, and I'm happy with the default Syncfusion dialog styling. I'm looking for an automatic way to do this, or at least one with the minimal amount of code.

Thanks,

DerekB

Hi Derek, 

Greetings from Syncfusion support. 

We can achieve your requirement using the dialog template edit mode in Grid. 

Refer the below documentation for further details. 

Link: https://ej2.syncfusion.com/aspnetcore/documentation/grid/edit/?no-cache=1#dialoginline-template 

Please let us know if you need further assistance on this. 

Regards, 

Thavasianand S. 

Hi Thavasianand,

As I said, I don't want to create templates. First I have to specify all the columns manually for the main table, because data annotations aren't supported, and now I have to do it again for two templates (edit and add)? That's a lot of code duplication. Isn't there any other way to do this? I only need two or three extra fields in my edit / add dialogs compared to the main table, so I would like to be able to simply add the columns (or maybe mark them as visible?) for those dialogs, instead of having to specify each and every field in my entity.

Thanks,

DerekB

Hi Derekb, 

 

You can achieve this requirement by simply change that particular columns visible property value in while perform the edit action. Please refer the following code snippet, 

 

 

In this code we have changed the visible property value simultaneously while perform CRUD action in Grid. We have prepared the sample based on this requirement and you can download that sample from the below link, 

 

Documentation: https://ej2.syncfusion.com/javascript/documentation/api/grid/#actionbegin 

                               https://ej2.syncfusion.com/javascript/documentation/api/grid/column/#visible 

 

Sample               : http://www.syncfusion.com/downloads/support/directtrac/general/ze/EJ2Grid2099419390.zip 

 

                                    

Please get back to us for further assistance. 

 

Regards, 

Pavithra S.