Ninox scripting

Ninox Scripting Skill

This skill provides expert knowledge for scripting in Ninox databases, preventing hallucinations and enforcing strict rules. Use when writing, debugging, or explaining Ninox scripts (NX).

Critical Rules

Follow these rules strictly to avoid hallucinations (inventing non-existent functions):

1. ALWAYS read references/function-whitelist.md before writing code. If a function is not in this list, DO NOT USE IT unless you verify it yourself in the official documentation.
2. ALWAYS read references/forbidden-patterns.md to avoid common errors (e.g., using JS array methods like map, filter, etc., which do NOT exist in Ninox).
3. ASK FOR CONTEXT: If field names, table names, or relations are unclear, ASK instead of guessing. See references/context-queries.md.
4. CONSULT ALL RULES: Review all relevant documents in the references/ directory before writing code. See Resources section below for all available rule documents.

Datenbankstruktur verstehen

Wenn du Ninox-Code schreiben sollst und die Tabellenstruktur unklar ist:

1. Bitte den Nutzer um den API-Export oder die manuelle Strukturbeschreibung
2. Lies references/export-guide.md für die Anleitung, die du dem Nutzer geben kannst
3. Frag NIEMALS nach Feldnamen durch Raten – das führt zu Halluzinationen

Verwende diese Prompt-Vorlage, um den Nutzer zu einer guten Beschreibung anzuleiten:

Damit ich den korrekten Code schreiben kann, brauche ich die genaue Datenbankstruktur.
Bitte nenne mir:
1. Den genauen Tabellennamen (mit Leerzeichen/Sonderzeichen)
2. Die Feldnamen mit Typen (Text, Zahl, Datum, Relation...)
3. Welche Tabellen zusammenhängen (Relationen)
4. Den Trigger-Kontext (wo läuft das Script? onChange auf Feld X? Button in Tabelle Y?)

Oder nutze die Anleitung in references/export-guide.md für einen API-Export.

Resources

Core Rules

• Strict Rules - Critical documentation compliance rules
• Function Whitelist - All documented Ninox functions
• Forbidden Patterns - Common errors to avoid
• Common Mistakes - Best practices and common pitfalls
• Context Queries - When to ask instead of guessing
• Relations and Loops - Correct usage of relations and for-loops
• Performance Rules - Optimization guidelines
• Undocumented Features - Working but undocumented features
• Style Guide - Coding standards

Documentation

• Functions - All documented Ninox functions

• Performance Guide - Performance optimizations

• API - HTTP and REST API (full reference)

• HTTP Requests - Making HTTP requests from NX scripts

• Tables - Database table concepts

• Triggers - All trigger types, contexts, and limitations

• Datetime Functions - Date/time functions, formatting, arithmetic

• Types - Type system, conversion, null handling

• Database Schema - Schema structure and field types

• Export Guide - How to export database structure for AI analysis

• Globals - Global functions: teamId, user functions, sendEmail, ninoxApp, openPage, execution blocks

• Changelog - Script-relevant version history and new functions by version

Examples

• Basic Select - Basic select statements
• Aggregate Functions - Using aggregate functions instead of loops
• Select Optimization - Optimizing select queries
• Transaction Pattern - Using transaction blocks
• Count with Filter - Undocumented count() with filter pattern
• Select with Brackets - Undocumented bracket syntax