Keywords: Data Entry, Excel, Grid Editor, Columns.
​

The Grid Editor is a spreadsheet or grid-like editor that allows you to edit and add new Components and References. The fields that are editable are shown in the column headers. Fields that are not editable are grayed out. The grid editor can be accessed by clicking on the button at the very bottom of your screen. And by clicking on the square with the tilted arrow you are able to expand the grid editor to a full view.

On the second top row of the Grid Editor, you are presented with three buttons. From here you can show all components (removing current context filter), view and edit all columns and fields.

The grid editor will allow you to edit the children components of your current context, however, if the context component can’t have children, it will display the siblings. If your context is the Workspace, you will see the Parents. By clicking on Select Fields you are able to choose what type of fields that will be displayed on the grid editor. And by clicking on Add Fields you are able to add pre-configured fields that are not shown on Select Fields.

New fields can also be created by clicking on the Add Fields. But be aware that once a new field is created it is not possible to rename the fields. Because renaming a field would break the API schema.

The grid editor will allow you to edit the children components of your current context, however, if the context component can’t have children, it will display the siblings. If your context is the Workspace, you will see the Parents.

For References, it is the same principle as you will see Source Components first.

Choose between Components and References at the top of the editor.

Bulk Editing

If you want to change a field value on many components at the same time, you can click the corner of the cell and drag over all the rows you want to copy the value into. This works well if you sort on a specific field (clicking the column header) or by using perspectives to filter the components you want to edit.

In case of multiple users are collaborating simultaneously in Ardoq, the grid editor reflects these changes. Changes in workspaces will also be reflected in the grid editor. The final data shown in the grid editor will be based on the last changes made by the last user (the last user who saves becomes the winner 🎖)

Exporting Workspaces

There is a possibility to export the components and fields from a grid editor by clicking on the three-dot (options button) on the workspace that you would like to export. To do so, please refer to the article on export views.