Editing Table Data
You can edit Table data from the Expanded Grid view, using the Excel Add-In, or using the API. Below, we'll walk through using the Row Editor in the Expanded Grid, which is good for editing individual rows one at a time. If you need to edit a lot of data efficiently, we suggest using the Excel Add-In or the API.
- You can get to the Expanded Grid view, by selecting a Table or View in the Assets Dashboard, then clicking the Expand button, or Edit->Data.
- Edit->Data will only be available if you've selected a table you have Owner or Write access to.
- You cannot edit data on Views, you must edit the data at the source Table.
Right-click any row header in the expanded grid view to view more grid options
The Row Editor is a Panel window for editing Data and Files within individual rows.
- You can expand the Row Editor by clicking the Row Editor button in the Top Right corner of the Expanded Grid.
- After expanding the Row Editor, select the row you want to edit in the grid. The values in the row editor will update to the selected row.
- Use the Edit button at the top of the Row Editor panel to edit the values in that row.
- The Delete button will delete the entire row.
- The New button will create a new row with empty values, which you can then fill using the Row Editor.
- Actions made using the Row editor will not be saved unless you click the Save button at the bottom of the panel.
When uploading row edits for an existing table, your upload table needs to match the structure of the Hunni table you are modifying, including the "Hunni Id" column in Column A.
- First row should match the column names for values you are editing
- You do not need to include every column in the table. You can edit data for one or many columns individually, as long as you have a Hunni Id in the first column and the column names are correct.
- First column should include the "Hunni Id" column with the IDs of the rows you wish to edit.
- You can use this same upload process to add new table rows, by leaving the Hunni ID coumn blank.
- Make sure your upload table data matches the column types of the table you are uploading to. You can check the column types by selecting the table, then clicking Edit->Structure/Details.
Once your upload table is ready, Navigate to the existing table in the Assets dashboard and select it.
Click the Upload button in the top right of the Asset Nav window and select Upload New Rows/Row Edits from the dropdown.
After selecting your file, the new rows will be added to the table. If you recieved an error, double check your table layout to make sure it matches the