-
Link a subtable to a phantom table
I've been stuck on this script since last night. I want to create a phantom table from the Quotes table and the Prices sub-table. Everything works fine,…
- Answered
-
csv export problem.
'Ver Archivo CSV' := null; let xMd := 'Busqueda por Mes'; let registros := select 'Datos Transferidos' where month(Date) = xMd; let csvContent := "Cliente,Date,Transferido Dato 1,Transferido Dato 2,…
- Answered
-
POST multipart/form-data query to external API
Hi everybody, I need to post data to an external API who accept only "Content-Type: multipart/form-data". Ninox http function seem able to send only "Content-Type: application/json".…
-
Optimize performance of scripts
do as transaction ... end | do as server ... end | do as deferred ... end Ninox executes scripts in a perpetual exchange between the browser or app and the server.…
-
Create your own functions
Create your own functions with Ninox to automate workflows according to your needs Advantages write a script once and use it throughout the database concise scripts because you only need your own…
-
Repeat conditional statements with loops
for ... in ... do ... end | for ... from ... to ... do ... end | while ... do ... end Loops allow you to automatically execute a code block multiple numbers of times in succession.…
-
OIDC SSO with Okta
Set up SSO for your Ninox server (Private Cloud or On-Premises) using OIDC and a third-party app like Okta
SSO is an Enterprise feature available on request that requires a valid license purchased… -
SAML SSO with Azure AD
Setting up SSO for your Ninox server (Private Cloud or On-Premises) using SAML and Azure Active Directory
SSO is an Enterprise feature available on request that requires a valid license purchased… -
Sort records
order by Use order by to sort an array of records by a specific field. This is useful when sorting an array first before processing it further. When you use order by in a View layout item,…
-
Creatable if and Deletable if
The Ninox 3.11 release introduces "Creatable if" and "Deletable if" — set conditions for record creation and deletion with the formula editor
Creatable if and Deletable if are available for all… -
Create and delete records
create | delete create To create a record in a specific table by script, specify the corresponding table name in a button after create. Example create Customers Result: A new,…
-
Fields
Find out more about the field types available in Ninox A field represents a location stored within a row of a table in a database. When creating a table in Ninox,…
-
Ninox languages
The following languages are supported by the Ninox app. This may be relevant when working with a specific date or time format. Specific languages supported by Ninox Abbreviation Language de German en…
-
save archive NOT IMPLEMENTED
Good day when I try to save archive as from cloud to my mac it shows up a message NOT IMPLEMENTED. how can I resolve this? Thanks
-
announced v3.14 features
Well besides the e-Invoicing, but that doesn't help me. :) The 2nd bullet point looks to incorporate a bit of Ninext. I wonder how many features will eventually be incorporated?…
-
Secure Ninox API calls
Hi, I've just started looking into the Fetch API to make calls to the Ninox server from the Ninox client side (web app). I'm a bit worried about exposing the Ninox API Key this way.…
-
Best practice: Speeding up Ninox scripts
Hi there, I'm trying to backup my bookkeeping from sevDesk; so I first filled a ninox table with all the JSON Results from the sevDesk REST API. Result is ~1900 Datasets Now I want to split my Data…
-
Sort concatenated values in table view not working
Hi, I have a parent table "Programmes" and a child table "Works" . In the "Works" table I have a number field called Order and then a field which combines the WorkTitle with the order…
- Answered
-
Dialog not working.
In the 'Trigger on new record' I have the following let title := "Serial and/or Bundle Required"; let message := "Does this new record need it's Serial Number logged? If so is it part of a Kit/Bundle?…
-
Glossary
Definitions of key terms for reference
This glossary isn't exhaustive and will be continually updated. The glossary's main purpose is for linking from other pages in the Ninox manual to quickly… -
Understand usage overview and capacity restrictions
Learn how to keep track of your available storage, number of records, API calls, and emails sent The amount of storage per license, records per database, API calls per month,…
-
Passing Dropdown Value to Another Page
Hi everyone, I'm trying to pass the value selected in a dropdown on my Dashboard page to a dropdown on my Job Setup page. Here's the setup: Dashboard Page:…
- Answered
-
Invite collaborators
Inviting members and contributors to your workspace To invite collaborators to a workspace, go to the corresponding workspace and click on the right side of the page.…
-
Manage licenses
Removing a collaborator or yourself from a workspace How do I remove a collaborator from a workspace? If you are the owner or admin of a workspace, click the name of the collaborator you want to…
-
Calculate required licenses
Know how many licenses you need to add to your subscription Owners The contractual partner of Ninox, i.e., the one who pays and manages all licenses, is called an owner.…