Hi,
I am currently using a ComplexTableField to edit data that will be saved in a sparse matrix (E-A-V Model) and it works fine, but it not an optimal user interface for the editor, considering they will be adding a lot of data.
I would like to change the interface to allow multiple lines to be edited at one time (inline editing) and all entries save at one time with one Save button. I will also have to use a custom query to load the data (because not all values exist) and will need to override the writing of the data to the database to preserve the minimal data required for the EAV model.
In the attached image, there is a "Value" column. That is the column that needs to be editable and a 'Save' button associated with it.
Is there a way to do this within the framework? Override a Field Type? Or should I write completely custom PHP code to load, render and save the data and just put it in a tab. If so, are there examples of that I can reference?
Thanks,
Jonathan.