claviz-database-forms

CRUD functionality for PostgreSQL and MSSQL database tables in Claviz.

Setup

To create tables or forms for databases, you need to create separate functions:

• A function with executePostgreSqlQuery (case-insensitive) in its name for PostgreSQL.
• A function with executeMssqlQuery (case-insensitive) in its name for MSSQL.

These functions must accept a query parameter and return an array of objects for the executed query. You can then use them as the Execute query function option in tables or forms.

You can also create a validator function and use it in tables or forms. This function must accept the following parameters:

• values — an object containing the current user input.
• isExisting — a boolean indicating whether the row already exists in the database table.

You also need to add clavizAdminUsername and clavizAdminPassword to KeyVault.

Required packages

• numeral
• exceljs

Changelog

0.0.16 (09.06.2026)

• Replace write-excel-file with exceljs for XLSX export.
• Export Link fields as clickable hyperlinks in XLSX files.

0.0.15 (02.06.2026)

• Add Dynamic field type to dbTable.
• Expose onCellButtonClick from dbTable for button cells rendered via dynamic fields.

0.0.14 (21.05.2026)

• Add Link field type to dbTable.
• Render links as clickable unstyled text and open them in a new tab.
• Add optional Label field to use custom link text; fall back to the URL when not set.

0.0.13 (30.03.2025)

• Fix duplicate updatedColumnName assignment in merge for PostgreSQL and MSSQL.

0.0.12 (27.03.2025)

• Preview only first 100 rows for XLSX upload.

0.0.11 (25.03.2025)

• Fix Error: formatcan only be used onDate, Numberor"Formula" cells when downloading XLSX in table by casting numerical-type values to Numeric.

0.0.10 (16.08.2025)

• Add autocomplete to text type field. Can be filled via options.

0.0.9 (07.08.2025)

• Fix table search not working for PostgreSQL if there is a date field.
• Add support for toolbar items in table.

0.0.8 (04.08.2025)

• Fix checkbox styling in form - locate them on one line if there are multiple checkboxes.

0.0.7 (23.07.2025)

• Add style option for field in table.

0.0.6 (21.07.2025)

• Expose orderClause in Configuration form.
• Make UTC/local option for Updated timestamp column.
• Form checkbox styling fix.

0.0.5 (17.07.2025)

• Add onInit, onValueChange hooks to form.

0.0.4 (04.07.2025)

• Add ability to disable field in form.

0.0.3 (04.07.2025)

• Normalize date fields to UTC in form.

0.0.2 (01.07.2025)

• Fix $meta missing in dbTable.

0.0.1 (30.06.2025)

• Initial release.