Skip to main content

Internal Table 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
  • 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.

For custom (JSON) datasources, see Internal Custom Datasources.

To share a datasource with non-Wallboard users via a link, see Shared Datasource Editor.

Table - Datasource Editor

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

Worksheets and Actions

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.

Flush Worksheet (2.1)

You can clear all row data in a worksheet while preserving the column structure.

  • Useful for resetting data without recreating the table
  • Access this option from the worksheet actions

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.

Adding Columns and Rows

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

Column Types

When creating or editing a column, you can select from the following value types:

TypeDescription
StringSingle-line text
TextMulti-line text
NumberNumeric values
BooleanTrue/false checkbox
ColorColor picker (hex value)
URLClickable links
DateDate picker (2.1)
TimeTime picker (2.1)
DatetimeCombined date and time picker (2.1)
SchedulingInterval-based scheduling with day/hour rules (2.1)
DropdownFixed value list, configured via Dropdown Manager (2.1)
File pickerSelect a file from the media library
Folder pickerSelect a folder from the media library
Please note, changing the type of a column will reset the existing values in that column.

Row Actions

  • Insert above / Insert below: Add new rows at different positions.
  • Duplicate: Duplicate a row by clicking the button.
  • Remove: Remove a row by clicking the button.

img_1.png

Row Locking (2.1)

You can lock individual rows to prevent accidental modification or deletion.

  • Lock or unlock rows via the row actions menu
  • Locked rows display a lock icon and cannot be modified or removed
  • Any user with EDIT permission on the datasource can lock and unlock rows
  • Use case: protect template rows, recurring events, or reference data that should not be changed

Column Actions

The icon next to the column header will open a dropdown with the following options:

Edit Column

Clicking the icon or double-clicking on the column header allows you to rename the column and select a different value type.

img.png

Insert Left / Insert Right

Add new columns at different positions. When you do this, you have to name your column and select a type for it.

Duplicate Column

Duplicate a column by clicking the button and entering a new column name.

img_2.png

Move Left / Move Right

Move columns to different positions. You can also relocate columns by dragging and dropping them 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 Column

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

Column Locking (2.1)

You can lock individual columns to prevent their values from being edited.

  • Lock or unlock columns via the column settings menu
  • Locked columns show a lock icon on the column header
  • Values in locked columns cannot be edited by users

Column Sorting (2.1)

Sort table data by any column in ascending or descending order.

  • Select the sort option from the column settings menu
  • Sorting is applied to the current worksheet view

Column Hide/Collapse (2.1)

Temporarily hide columns from the table view to reduce clutter.

  • Hide columns via the column settings menu
  • Hidden columns can be shown again from the column settings

For columns of type Dropdown, you can define a fixed list of allowed values.

  • When a dropdown list is configured, freetext input is disabled — only values from the list can be selected
  • Manage dropdown options from the column settings menu
  • Dropdown values are stored in the datasource configuration