Hi,

I have a requirement to:

1. Develop a grid that allows user to display data.

2. Allow user to select values for certain columns using dropdown in the column

3. Allow user to create new rows/records that copy data from another row. Also, this grid will have checkboxes in column 1 to multiselect records for bulk update.

Is using Editable table recommended for this approach?

Thanks!

1. Develop a grid that allows user to display data.

->All tablewidgets can be used

2. Allow user to select values for certain columns using dropdown in the column

-> If you want to use this as a filter in the header column, then Tablerecords is the best option. If you want to have an edit-mode, then you can use Editable table.

3. Allow user to create new rows/records that copy data from another row. Also, this grid will have checkboxes in column 1 to multiselect records for bulk update.

-> Editable table will not do a bulk update: Each record will be updated after pressing the savebutton.


If you want to have a grid doing exactly what you describe you need to create the functionality yourself, inside a Tablerecords widget, since its not supported functionality.

Hi Anuj,

I think you can make use of Table Records Widget itself.

1. Develop a grid that allows user to display data.

Table widget with data from prepartaion as input to the SourceRecordList can be used.

Local Variable can be created and this can be assigned to the table record widget as this will be useful for the case3 mentioned by you.

2. Allow user to select values for certain columns using dropdown in the column

Static Entity Can be defined to list the values in the drop down and the addition column can be defined with Drop down widget.

3. Allow user to create new rows/records that copy data from another row. Also, this grid will have checkboxes in column 1 to multiselect records for bulk update.

On Change event can be used for example once the user clicks on a particular column. The column value will be an entity listed in the table. 

So in the onchange event u can duplicate a record and insert it to the local variable list then refresh the table container.


Hope this helps.

Ajith