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 using the excel add in docid\ csq1t zq9n61xwwnkacza or the api overview docid\ pnvqvxpt9ezj2kwt3lv49 the expanded grid 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 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 upload row edits 1\ prepare your upload table 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 2\ select the table to modify in the assets dashboard once your upload table is ready, navigate to the existing table in the assets dashboard and select it 3\ select upload > new rows/row edits click the upload button in the top right of the asset nav window and select upload new rows/row edits from the dropdown 4\ click the "browse" button to select the excel file with your table 5\ upload 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