-
Write transactions
When you change data within an action, this is referred to as a write transaction. Examples of write transactions The input or modification of data Single statements of a script that change data, e.g.…
-
Tips and tricks
Learn how to boost the performance of your databases First, a checklist of common questions and advice:
What are the potential bottlenecks? A look at the process monitor helps identify areas for… -
Automatic invoice number
Use this script to automatically assign an invoice number An invoice number... must be unique and should be sequential, can consist of numbers and letters,…
-
Picture from a public URL
The following dataset is used in the example below that shows how to insert a picture into an ODT report Data { "flags": [ { "name": "France", "picture": "https://share.ninox.…
-
Password encryption
If needed, encrypt a rendered report with a password Either toggle ON the option Set password in the Ninox UI, or alternatively use a custom script and the functions printRecord or printAndSaveRecord.…
-
Formula returning a record causes type mismatch
I have a formula that returns a record. This formula works fine. But whenever I try to use the returned record in a then or else branch, I get a type mismatch. The formula field is OrderItems.…
-
Create new record in another table and transfer all fields across
Hi, I have created a table that I am using as a "kiosk" type function where external parties can enter their form details. Once they click on a button called "Sign In" I want that data to transfer…
- Answered
-
Using Ninox ChatGPT to create a search
Hi, My first shot at creating a button to search a field (RTF) to find and mark results. I have a field SEARCH for the search terms and the RTF field is NOTES.…
- Answered
-
Option A: without a custom script
Follow CamelCase and underscore notation in template Without a custom script, your template (e.g., a DOCX file) must follow the proper notation for field names.…
-
Upload a template
The first step to creating and rendering a report is to set up a new print layout in Ninox Create a new layout and import file Open a database to open a table that contains records you want to print.…
-
Create a template
Get from a document in a text editor to a printable report in Ninox Open a text editor, e.g., Microsoft Word, LibreOffice, Open Office, Google Docs, or other. Choose the type of template you want.…
-
Introduction to dynamic print layouts
Learn the basics of print customization in Ninox Availability
Print customization is available for Public and Private Cloud starting 3.7.7. Capacity The pricing page (section on Essentials) offers… -
SQL connection setup guide
Before you begin Request a license file from Ninox for your Private Cloud or On-Premises that is granted full access for one of these Enterprise features: mssqlConnections or pgConnections.…
-
Process monitor
Keep track of your Ninox activity, analyze and fix problems What the process monitor does The process monitor is a handy tool to observe what's currently happening in your workspaces.…
-
Defragment database
Optimize the structure of your database and increase its performance If you heavily work with your database, not only add but also repeatedly delete data,…
-
Tours
Get to know the Ninox assistant We use tours to interactively show you how Ninox works. The software we use for that acts as an additional "layer" on top of the app and guides you in real-time…
-
Independent tutorial
Explore printing, table relations and composition, roles and rights management, triggers, and connecting to Integromat
Note: The screenshots shown here might look a bit different from what you see… -
Intermediate tutorial
Learn how to reference tables, work with formulas, share your work, import and export data
Note: The screenshots shown here might look a bit different from what you see in your application but the… -
Tips
Use our Ninox assistant and video tutorials to learn more about using Ninox Ninox assistant (tours) If you haven’t met it yet, we would like to quickly introduce you to our Ninox assistant,…
-
Working together on databases
Invite colleagues to your workspace to collaborate with them on databases When you use Ninox in the cloud, you can collaborate with colleagues around the world on your database.…
-
Different views
Display only what you currently need. Or visualize as much as you want Views provide you with various options for displaying your data. This enables you to consider your data from different…
-
Sorting and filtering
Prepare your data to get the information you need quickly and easily You can apply standard sorting and filtering operations by clicking the respective column header.…
-
Showing or hiding table columns
It’s easy to show columns — or hide information you don’t need. This gets even more interesting when it comes to creating different views. But more about that later.…
-
Row numbers and IDs
In Ninox, there are 2 ways to number a row and/or record: The always visible row number The ID for a record (No.) Row numbers This is the row header. The row number is always displayed.…
-
Entering data
Of course, Ninox also allows you to import data, but in our example, we’ll first show you how easy it is to enter data directly into your form. There are 2 ways to do this:…