Configure Cell Editing
Last updated
Last updated
Every column you want to be editable in SuperTables needs to be configured in the InputTables tab of the configuration. To create a new column,
New Column:
Click on 'Create Column'.
Select your column type.
Give the column a name.
Click on 'Create'.
Your new column is added to SuperTables and is ready to be used.
With InputTables you can also edit existing columns in your SuperTables. For example to change a category, update a Type or change a due date. This data is stored in the WriteBackExtreme table and joined back to SuperTables. InputTables never overwrite existing data.
Edit an existing column:
Click on 'Add Existing Columns'.
Select the column(s) you want to become editable.
Change the column type(s).
Click on 'Add columns'.
Your column is now editable in SuperTables and ready to be used.
Below we explain the difference between a new and existing column
New Column
Not part of your Dataset
New values are null / empty
On edit it stores the data in WriteBackExtreme.
On display it only shows the data from WriteBackExtreme.
On clear WriteBackExtreme value, we set the cell to null in WriteBackExtreme
Existing Column
Already part of your Dataset
We use the values from the Dataset
On edit it stores the data in WriteBackExtreme
On display it joins data from WriteBackExtreme into the SuperTables column.
On clear WriteBackExtreme value, we show the original datasheet value.
Existing data is never overwritten.
Make sure to toggle the 'visibility' (eye icon) or 'should merge' (merge icon) at the start of each row to show the data in SuperTables. Then you can toggle the editable switch per column to determine which column should be editable.
You can connect to the same schema from different dashboards. In one dashboard a column could only be visible, where in the other dashboard you can edit the data.
Make sure to use the same primary key column in both dashboards and that they are available in the datasheet
Single Line Text
Multi Line Text
Number
Decimal
Boolean
Dropdown Select
Date
Date & Time
