Nextcloud Tables icon

Nextcloud Tables

Verwalten Sie Ihre Nextcloud Tables - Tabellen, Zeilen und Daten
Join our community

Actions31

Overview

This node enables managing columns ("Spalte") within Nextcloud Tables. Specifically, the "Spalte Erstellen" (Create Column) operation allows users to add a new column to an existing table in Nextcloud Tables. This is useful for dynamically extending the structure of tables by defining new fields with specific data types and constraints.

Common scenarios include:

  • Adding custom fields to track additional information in a collaborative table.
  • Creating columns with validation rules or default values to ensure data consistency.
  • Defining selection lists or user/group selectors to facilitate structured input.

Practical example:

  • You have a project management table and want to add a "Priority" column as a selection list with options like "High", "Medium", and "Low".
  • You need a date/time column to track deadlines with a default value of today's date.
  • You want a mandatory text column for task descriptions with a maximum length and regex validation.

Properties

Name Meaning
Tabelle Select a table from the list or enter its ID where the new column will be created.
Titel The title/name of the new column.
Beschreibung Optional description for the column.
Spalten-Typ The type of the column. Options: Text, Number, Date/Time, Selection, User/Group.
Pflichtfeld Whether this column is mandatory (required).
Text-Subtyp For Text columns: subtype can be single-line or multi-line text.
Standard-Text Default text value for new rows (only for Text columns).
Maximale Länge Maximum number of characters allowed (empty means unlimited) for Text columns.
Validierungs-Pattern Regex pattern to validate the text input (optional, for Text columns).
Standard-Zahl Default numeric value for new rows (for Number columns).
Minimum Minimum allowed value (optional, for Number columns).
Maximum Maximum allowed value (optional, for Number columns).
Dezimalstellen Number of decimal places (for Number columns).
Präfix Text prefix before the number (e.g., "€") (for Number columns).
Suffix Text suffix after the number (e.g., "kg") (for Number columns).
Standard-Datum Default date/time value in ISO 8601 format or "today" (for Date/Time columns).
Auswahl-Optionen Available options for Selection columns; multiple options can be added.
Standard-Auswahl Default selected option (must be one of the available options) for Selection columns.
Mehrfach-Auswahl Whether multiple options can be selected simultaneously (for Selection columns).
Benutzer/Gruppen-Typ For User/Group columns: select whether only users or only groups can be chosen.
Standard-Benutzer/Gruppe Default user or group selected (for User/Group columns).
Mehrfach-Auswahl Whether multiple users/groups can be selected simultaneously (for User/Group columns).

Output

The node outputs JSON data representing the newly created column's details as returned by the Nextcloud Tables API. This typically includes the column ID, title, type, and any configured properties such as default values, validation patterns, and options.

No binary data output is produced by this node.

Example output JSON snippet (conceptual):

{
  "id": "123",
  "title": "Priority",
  "type": "selection",
  "mandatory": false,
  "options": ["High", "Medium", "Low"],
  "default": "Medium"
}

Dependencies

  • Requires a valid API authentication token credential for Nextcloud Tables.
  • The node interacts with the Nextcloud Tables API endpoints to perform operations on tables and columns.
  • No additional external services are required beyond access to the Nextcloud instance hosting the Tables app.

Troubleshooting

  • Invalid Table ID: If the specified table ID does not exist or is inaccessible, the node will throw an error. Verify the table ID or select it from the list.
  • Validation Errors: Providing invalid values for properties like regex patterns or default values that do not conform to the column type may cause errors.
  • Permission Issues: Ensure the API token has sufficient permissions to modify the target table.
  • Unknown Resource or Operation: The node code throws errors if an unsupported resource or operation is specified. Confirm that "column" resource and "create" operation are selected.
  • Continue On Fail: If enabled, the node will continue processing subsequent items even if one fails, returning error messages in the output JSON.

Links and References

Discussion