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.
- Author
- softsync-lab ↗
- Repository
- softsync-skills-hub ↗
- Licence
- MIT
- Last repository change
- 19.10.2026
Assessment and security
- Files in this package
- 1
- Scripts
- 0
- HTML comments
- 1
- URLs in SKILL.md
- 0
No signals detected. Repository changed on 19.10.2026, without references to retired models or APIs.
MIT, open: use and modify while retaining author attribution.
- 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
- Reading the structure
- Changing the structure
- Numbered fields
- Rules
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…