Skip to content
Skills Library
Other · Analysis

softsync-tables

/softsync-tables

Read the workspace structure — tables, fields, choices and groups — and add or change tables. Use before any other SoftSync task to learn what the workspace holds, or when the user wants a new table or field.

Licence
MIT
Last repository change
19.10.2026

Assessment and security

100/ 100Class: good
Format25 / 25
Frontmatter with name and description, valid name, description up to 1,024 characters, name matching the folder.
Discoverability25 / 25
Description explains when to use the skill, has a reasonable length and uses third person.
Content35 / 35
At least 150 words and at most 500 lines, headings, step lists, examples or code.
Hygiene15 / 15
No placeholders such as TODO, no Windows paths, with a licence.
Riskno signals detected in the scan
Files in this package
1
Scripts
0
HTML comments
1
URLs in SKILL.md
0
Deprecation

No signals detected. Repository changed on 19.10.2026, without references to retired models or APIs.

Licence

MIT, open: use and modify while retaining author attribution.

What to check before installing
  • SKILL.md zawiera komentarze HTML (1). Nie widać ich w podglądzie Markdown, a model je czyta.

What it does and when to use it

Read the workspace structure — tables, fields, choices and groups — and add or change tables. Use before any other SoftSync task to learn what the workspace holds, or when the user wants a new table or field.

Original author description

Read the workspace structure — tables, fields, choices and groups — and add or change tables. Use before any other SoftSync task to learn what the workspace holds, or when the user wants a new table or field.

How it works

  1. Reading the structure
  2. Changing the structure
  3. Numbered fields
  4. Rules
Original SKILL.md headings · 26 lines, 378 words
SKILL.md preview
---
name: softsync-tables
description: "Read the workspace structure — tables, fields, choices and groups — and add or change tables. Use before any other SoftSync task to learn what the workspace holds, or when the user wants a new table or field."
---

<!-- Generated from the SoftSync API skills. Edit them there and re-export. -->

# Tables

## Reading the structure
`describe_workspace_schema` returns every table you can see with its fields, field kinds and options, plus the groups you can access. Call it before any other workspace tool.

- A choice field lists `options.choices`, each with a `value` (what you send) and a `label` (what the user sees). Always send the value.
- A relation field's `options.tableId` names the table it links to.
- A text or number field whose `options.source.type` is `sequence` is numbered by the app (ticket or invoice numbers). It gets its value on create and cannot be written; leave it out of `record_creation` and `update_record`.
- A field whose `options.source.type` is `formula` is calculated by the app from `options.source.expression` and cannot be written; leave it out of record writes. One that is `formula-default` is filled from its formula when left empty, and a value you send replaces it until it is cleared.
- Every table also has `__system_created_at`, `__system_updated_at` and `__system_created_by`.

## Changing the structure
- `upsert_table`: create a table or add and change its fields. Needs the Admin or Editor role.
- A calculated field is any field with `options.source` = `{ "type": "formula", "expression": "ROUND({Qty} * {Unit price}, 2)" }` (or `formula-default` for a starting value people can change). Fields are written in braces by display name; a linked field goes through its link field, e.g. `{Deal}.{Currency}` or `SUM({Order lines}.{Amount})`. Excel-style functions work (`IF`, `ROUND`, `SUMIFS`, `LOOKUP`, `NETWORKDAYS`, `PMT`…). Supported on text, number, date, select and multi-select fields. A broken formula is rejected with the reason; totals over linked records update a moment after the save, and changing a formula recalculates existing records in the background.
- `delete_table`: removes a table and every record in it. There is no Bin for tables. Admin only; confirm with the user first.

## Numbered fields
`get_field_counter` shows the number the next record will get; `set_field_counter` moves it, for example to start invoices at 1000. It cannot go below a number already in use.

## Rules
- Reuse an existing table or field when one fits instead of creating a near-duplicate.
- Describe the change you plan in plain words and wait for agreement before changing the structure.

Versions

The database has no other skills named softsync-tables.

Database snapshot: 13.11.2026 · package version d5e7ad0edaf0 (SHA-256 digest of the entire package)

Downloads in the last 30 days: 0 · ranking

Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.

Similar skills

  • 90softsync-workspace
    Run the workspace itself: who is in it and what they may do, its name, country and currency, and ready-made add-ons such as a service desk. Use when the user wants to invite or remove a teammate, change a role, or install an add-on.
  • 100softsync-email
    Write email templates and send them to one contact or a list, and follow or cancel the send. Use when the user wants to write, fix or send a reusable email, or check how a send is going.
  • 90Power BI Modeling
    Create and manage Power BI semantic model structure using pbi-cli -- tables, columns, measures, relationships, hierarchies, calculation groups, and date/calendar tables. Invoke this skill whenever the user says "create table", "add measure", "add column", "create relationship",…
  • 100exploring-tables
    Exploring any ServiceNow table: schema, field types, sample records, relationships, data patterns, a record's history (work notes, comments, field changes), and what touches a table or field (business rules, client scripts, UI policies, ACLs, script includes). Use when the user…

Feedback and reports

Your message goes to Bartosz Sokoliński. An email address is needed only for a reply. See the privacy policy.