Inline editing
Edit your data directly from lists
Detail lists can be used for more than just finding and exporting data. You can also use them to directly change your data.
Note that you can’t edit summary lists because they display aggregated data such as average number of products in orders.
Switching to edit mode
To enable editing, open list sidebar, and click on Edit Values panel. You will see list of all editable columns. Select columns that you want to edit, and than click inside your list and start modifying the data.
Changed values are highlighted - green color indicates that value has been changed, red color means you have entered invalid value (for example you have entered non-numerical value to numerical column)
Batching updates
For performance and security reasons, individual changes are not applied immediately. We use batching model instead. Every edit is added to a pending changes batch. This batch can be submitted as a whole, or you can choose to revert the changes.
You will find basic information about batch in Edit Values panel. Note that number of changes displayed here doesn’t have to correspond with number of highlighted cells in list. This discrepancies can be caused, for example, by navigating to different list page, or by changing list parameters and refreshing the list.
Editable columns
Unfortunately not all columns are editable. Generally, list column can be based on any expression, for example product.name + ': ' + product.id
. Obviously, editing such column isn’t possible, as it is a projection of two column. Another example is column with expression now()
. This column always contain current date, and this information is not stored in any database table.
In order for column to be editable it must meet following conditions:
- column is based on simple field expression, for example
product.name
orcategory.description
- field used in field expression must be editable
- see list of fields in each collection to find out what fields are editable
- all custom fields are editable