KLXM Studio – Home
Get in touch

Running a website · Advanced · 1:57 min

Creating a data table

A four-step assistant (type, template, basic settings, insert), then conditions and calendar under “Felder & Einstellungen”.

No sound, with subtitles German and English captionsText of what is spoken in a video, shown in sync. On the web usually a WebVTT file; captions help deaf people and anyone watching without sound.developer.mozilla.org (opens in a new tab) – switch them on and off with “CC” in the player. The video is hosted on this server and only loads when you press play. The steps below are the full text of the video.

Goal

You build your own table (here “courses”) with detail pages, conditional fields and a calendar.

Prerequisites

  • Permission “change tables and fields” and the feature “create tables and fields yourself”.

Step by step

Transcript: every step matches one subtitle in the video.

  1. Data › “+ Neue Tabelle oder Formular” (new table or form): your own content such as courses, products or jobs – a four-step assistant.
  2. 1. Type: e.g. “Inhalte auf der Website” (content on the website) – or form, requests, registration, internal list, external source.
  3. 2. Template: news, team, products, events … with matching fields – or “Leer beginnen” (start empty).
  4. 3. Basic settings: name and singular, then fields – enter a label, choose the type, “Hinzufügen” (add).
  5. On the website: overview as a list, a detail page per entry and its address, e.g. /kurse.
  6. 4. Insert: create a new page with the list or add the “Datenliste” (data list) blockBuilding block of a page, such as text, image, gallery, map or form. You put pages together from blocks; each block has fields for its content and options for its display. to an existing page – or later.
  7. Fine-tuning under “Felder & Einstellungen” (fields & settings) – areas on the left: general, fields, on the website, search, calendar …
  8. Conditions: show “Link zum Raum” only when “Online-Kurs” = yes.
  9. Calendar: tick “Als Kalender nutzen” (use as calendar) and choose the “Beginn” field – then “Speichern” (save).
  10. Now the table has a calendar view, repetitions and an iCal subscription – in the menu on the left under data.

Tips & pitfalls

Tip

Templates on the data page (news, team, events …) save time.

Tip

With AI: ✦ Felder vorschlagen (suggest fields) or KLXM AI › table generator.

Watch out

The short name cannot be changed later (database, APIApplication programming interface: programs use it to exchange data without the user interface – for example to take over entries from another system.en.wikipedia.org (opens in a new tab)).

Watch out

Calendar fields can only be chosen after creating the table – new fields are not selectable there before saving.

Watch out

For confidential details (health data), create an encrypted inbox instead of a content table (type of table).