-
But now need not place weekends
if 'Plan Start' != null and 'Date Rev 0' != null then let dates := 'Date Rev 0' - 'Plan Start'; let 'step' := dates / 4; 'Date Rev Int' := 'Plan Start' + 'step'; 'Date Rev A' :…
- Answered
-
Modularity glossary
For users testing modularity v2 in Ninox 3.17 beta on Private Cloud 1. Core concepts Domain modeling Designing tables, fields, and scripts to match real-world entities in a single business domain.…
-
CSV Import Wizard
Hello everyone, Since a lot of our community members are interested in ways to automate the import of a CSV file, I decided to put together a complete working example database to show how to do it.…
-
Fields for Form use, not needed in "record"
This might be a simple answer, but on my slide-over default form for a table, is EVERY field stored with the "record"? It appears to me that formula fields probably are not "stored",…
- Answered
-
Need a formula between week to place on (%Semana Plan)
Need a formula to calculate, the % Semana Plan, the the difference between the current week and the previous one.
- Answered
-
Control the focus of a field
I have a text field that takes data from a scanner and runs a script when modified. I would like the focus to go back to that field automatically, ready for another scan. Is it possible?
- Answered
-
Split PDF pages
Hello, is there any way in ninox to spilt a multipage PDF in single pages? I know, there is a possibility with Zapier and pdf.co, but this is not possible for data protection reasons.…
-
Problem in my DB WorkOrder
@Fred Hi Fred, I have a problem that I don't know how to solve. I have a simple Engineering Workorders database. I can have several WorkOrders. Each workorder has several activities with their hours…
-
Create barcode for every new import
Hello In our chemical laboratory we use NiNOx for every sample that is coming in the lab. Each sample is getting a unique numeric code. I would like to automatically generate (if possible) a barcode…
-
Problème avec loadFileAsBase64(Photo)
Bonjour, je n'arrive pas à faire fonctionner : let photoData := null; if Photo != null then photoData := loadFileAsBase64(Photo) end; J'ai la roue qui tourne sans fin avec une photo de 60ko… La…
-
Break up transaction brackets
Ninox offers possibilities to break the transaction context with the instruction do as deferred. Let's assume that an external system is to be informed when an invoice status changes.…
-
Transactions
All triggers on data creation or change, and all scripts within do as transaction or do as server, run within a transaction that either executes fully or does not execute at all if it terminates.…
-
Buttons
Ninox scripts triggered by buttons (or when a formula field is clicked) run in the context of the client and not as a transaction. This means that Ninox executes command by command separately,…
-
Table views
The performance of table views is influenced by three factors: the complexity of the query (filter) the number of rows to be loaded the data loaded per row Ninox calculates views in the following…
-
Best Practices
The following best practices are key recommendations that have proven particularly effective when working with Ninox. They address common pitfalls such as inefficient data access,…
-
arcRider charts for Ninox: pie & donut
arcCustomChartCircle Widget – Visualize Pie and Donut Charts in Ninox The arcCustomChartCircle widget enables the visualization of circular charts (pie and donut charts) directly within your Ninox…
-
Create a view based on contains
Hi all, I have a table "Guidance" and in that table I have a multiple choice field named "keywords". Now I want in another table to create a view based on a textfield "keyword selection" - my idea…
- Answered
-
setting up user instructions for using a table
Hi - I have two staging tables in my database, each of which is setup to import a .csv file and (with a scripted button) process that imported data into permanent tables.…
-
How to Iteratively Add Items to a New Array
I'm new to Ninox (less than a month of use), so if this is common knowledge I apologize. However, I feel compelled to post this because of the incredibly steep learning curve of Ninox.…
-
Passing a field name (string) as a function parameter
I'm searching the forum but I can't find an answer to this question. I've defined a function like this very simple example: function updateField(iField:text, iValue:text, iRedord:…
- Answered
-
How to Unlock PDF With PDF Unlocker ?
I have a pdf file i need to unlocked how can i unlock my pdf pleasss help me
-
When to create a child/sub table.
It has been mentioned in this forum about when to create a child/sub table. One way is if you find your self adding a prefix or suffix to your fields that store similar data.…
-
Send quote to a client direct rather than attach A pdf
I must be getting lazy ! At the moment I can send clients a pdf quote from the system no problem - this relies on a printout being saved to an image field and then when i click the field i download…
-
Reminders in Ninox
Hello friends, I am planning to write a personal bills management app. I wanted to ask whether is it possible to set/create app reminders in Ninox that customers can choose to flash a few days before…
-
Bug obtaining a value from a JSON object
I'm trying to use parseCSV to retrieve specific values from a CSV file. After using the parseCSV function with the firstLineIsHeader option set to TRUE, I can retrieve the content of the first item:…
- Answered