Skip to main content

Internal Datasources

Internal datasources are useful if you like manually managing your data, whether it is a restaurant menu or a table with the contact details of your colleagues.

Create Internal Datasource​

  • Navigate to Settings >> Datasources menu
  • Select
  • Click on the button next to the Datasources header.
  • Select the Datasource structure type you wish to use.
  • Fill the necessary settings fields. Learn more:. Alternative Datasource Settings
tip

If you want your datasource to be editable from contents, enable the Editable from display functionality in the datasource create/edit modal.

  • After you finished the datasource configuration, click on the Save to create the datasource
  • Or if you click Save and Open, it will navigate to the Datasource editor.

After saving, your new datasource will appear in the list. Now you can start editing your table by clicking the icon.

Table - Datasource Editor​

Double-clicking on the names allows you to rename the elements for easier navigation.

Add new worksheet​

Clicking the button next to the existent worksheet in the top-left corner allows you to add new worksheets.

  • Here you can select from presets, or create a default worksheet.
  • Double-clicking on the worksheet's name allows you to rename it for easier navigation.

Add Columns and Rows​

Clicking the Add column and Add row buttons you can add new columns and rows to your table.

Row actions​

  • Insert above and Insert below: With these actions, you can add new columns to different positions.
  • Duplicate: You can duplicate rows by clicking on the button.
  • Remove: With this action, you can remove a rows by clicking on the button.

img_1.png

Column actions​

The icon next to the header will open a dropdown, with multiple options:

Edit column​

Clicking the icon you can edit your Column or Double-clicking on the column header also allows you to rename the column and select a different value type.

img.png

Please note, changing type on column will revert the values!

Insert left and Insert right​

With these actions, you can add new columns to different positions

  • When you do this, you have to name your column and select a type for it.

Duplicate​

You can duplicate columns by clicking on the button and finalizing it by entering a new column name.

img_2.png

Move left and Move right​

With these actions, you can move your columns to different positions.

  • Also you can relocate the columns by drag and dropping it into the right place.

    Some options may not be available if you select side columns or if there are not enough columns to relocate.

Remove​

When you choose to remove a column, you must confirm the deletion in the confirmation modal.

Other Datasource Editor features​

Import from JSON​

By clicking on the on the top of the datasource editor, a modal will open where you can import other JSONs.

  • Fill the modal with the desired JSON then click on confirm.

Custom view​

In custom view you can see the whole JSON file.

Please note, in this view you cannot import JSON files, to do this please use the "Import from JSON" feature.

Custom - Datasource Editor​

In case of custom datasources, you can copy-paste the desired JSON to the editor.

Repair JSON​

In custom view you have the opportunity to repair things like:

  • quotes
  • escape characters
  • remove comments and JSONP notations
  • turn JavaScript objects into JSON
Last updated on