# Configure cell editing

### Create a new column

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.

<figure><img src="/files/aZ6NfHszstT0hZ74fj3A" alt=""><figcaption></figcaption></figure>

### Edit an existing column

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.

<figure><img src="/files/H4oX7gmzoGk7H1TsQkfw" alt=""><figcaption></figcaption></figure>

Below we explain the difference between a new and existing column&#x20;

<table data-card-size="large" data-view="cards"><thead><tr><th></th><th></th><th></th></tr></thead><tbody><tr><td><strong>New Column</strong></td><td><ul><li>Not part of your Dataset<br></li><li>New values are null / empty<br></li><li>On edit it stores the data in WriteBackExtreme.<br></li><li>On display it only shows the data from WriteBackExtreme.<br></li><li>On clear WriteBackExtreme value, we set the cell to null in WriteBackExtreme</li></ul></td><td></td></tr><tr><td><strong>Existing Column</strong></td><td><ul><li>Already part of your Dataset<br></li><li>We use the values from the Dataset<br></li><li>On edit it stores the data in WriteBackExtreme<br></li><li>On display it joins data from WriteBackExtreme into the SuperTables column.<br></li><li>On clear WriteBackExtreme value, we show the original datasheet value.</li><li>Existing data is never overwritten.</li></ul></td><td></td></tr></tbody></table>

### Column overview

<figure><img src="/files/esR7GJLc1BnjaVoAxlfw" alt=""><figcaption></figcaption></figure>

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.&#x20;

**Visibility:** Toggle the visibility at the start of each row to show the data in SuperTables.

**Editable:**  Toggle the editable switch per column to determine which column should be editable

**Store Columns:** Use this option to append additional data alongside edits. For instance, if a user wants to add a remark to a cell and store additional information, such as sales or order dates, in the database, this button is useful.

**Merge Cells:** When importing a column from a sheet, the user can choose to keep it as a new column or merge it with an existing one. A merged column allows users to edit cells that overlap with existing data. If merging is off, it is treated as a separate column.

{% hint style="info" %}
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**
{% endhint %}

#### Column types

* Single Line Text
* Multi-Line Text
* Number
* Decimal
* Boolean
* Dropdown Select
* Date
* Date & Time


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.infotopics.com/inputtables/getting-started/configure-cell-editing.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.