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 need also add clavizAdminUsername and clavizAdminPassword to KeyVault.

Required packages

• numeral

Changelog

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.