-
Problem to add sign + and -
let mySelect := (select Expenses where Year = 2025 and month('Expenses Date') = month(today())); let mySelect2 := (select Expenses where Year = 2025 and month('Expenses Date') = month(today()) - 1);…
- Answered
-
Use Ninox as a backend with an online ordering system
Hello friends, My office is planning to implement an online ordering system instead of taking orders on phone/whatsapp. Is it possible to use Ninox as a backend for an online ordering system on a…
- Answered
-
Inconsistency with 'Readable If' and 'Writable If'
I wrote a comprehensive user permissions application that validates user permissions based on: Entity > Location > Permission Using a Global Function, I wrote this:…
-
Invoice recipient
We are retrieving information from another table We know who the client of an event is. This link between the event and the company (contact person) has already been added.…
-
Invoice date
Every invoice needs a date – manually or automatically You can enter the current date manually by clicking on the Date field and select Today, or Add a default value in the Field Settings of the Date…
-
Excursus 1: Data model (M:N relationship)
A little database theory never hurts... Let's take another look at our data model to better understand what we've done. Here's how it works Go to the database Event Management. Activate editing mode .…
-
Insert sub-table
All preparations are made – We are adding the sub-table. We will now create the sub-table in which we will enter all the consumption items. The invoice will display the total amount at the end.…
-
Invoice number
An invoice always requires a unique invoice number. If you wish, you can briefly take a detour to an example use case on another page of our documentation to enter a unique invoice number.…
-
Change
How can change number to text. For example amount in invoice is 5000usd . I will see text too in down invoice. Five thousand dollars
-
Deleting Images from the app and the server! (update)
I am going to rework all my "Image File Handling" - Scripts Although these all work okay - we now have a Ninox approach with a new Function that has been introduced in the last main update called…
-
How to use setItem in a button?
I'm having difficulty using setItem to modify a JSON in a text field with a button. I have a text field called json. It has a simple json object which is created with another button.…
- Answered
-
Error -> Delete a file in an image field
Environment: Ninox App for Mac version 3.14.3: Local Error message: "TypeError: i is not a function. (In 'i()', 'i' is undefined)" TestImage_Local https://youtu.…
Retired 
Retraité
-
Finance and Libraries - Building A Complete ERP/CRM Solution From The Ground Up this coming Thursday, February 13th at 12:00pm EST
Building a complete ERP/CRM solution from the ground up: This week - Thursday, February 13th Finance and Libraries 12:00pm EST/ 5:00pm GMT/ 6:00pm CET FREE REGISTRATION: https://us02web.zoom.…
-
do as deferred
@Fred Hi Fred, Isaw that. For those looking for solutions. If you work with Dashboards on the Main screen you can apply something like "Calculate my Stats but do it in the background" and then refer…
-
Sort by Nb Numerical Size
let data := [ "{'food': 'bread', 'Nb': 3} {'food': 'apple', 'Nb': 7} {'food': 'rice', 'Nb': 1} {'food': 'banana', 'Nb': 5} {'food': 'milk', 'Nb': 9} " ]; let sortedData := (data) order by Nb;…
- Answered
-
Field from newest (sub)record
Dear experts Can anyone help me? I am trying to budget and plan my revenue and have a table "Customers" and a sub-table "Years" in the sub-table Years I have a field "Total revenue" of this customer…
- Answered
-
Hide multiple elements at once
Hello friends, I am trying to hide two or more form elements (text boxes) from within the "Display field only if" setting of one of the elements. How can I achieve this ??…
-
Performance Issues on Ninox – Has Anyone Experienced This?
Hi everyone, I'm experiencing some performance issues with Ninox and wanted to see if anyone else has had similar experiences and found a solution. Compared to when I first started using it,…
-
Help with a bit of code
Hi, I have some code on a button that generates 4 bookings a year, currently it generates bookings for: 1st March, 1st June, 1st September, 1st December What can I change in the code below so that it…
-
Setting up fields - Part 1
We assign automations to fields We have created the new table Invoices; now we will assign small "tasks" to the fields. This way, we automate some processes.…
-
Getting started
We will show you an example of how to create a composition We are still in our example: The event was successful, and champagne was toasted to the 80th birthday of the senior CEO.…
-
Extra: Customize number format
Select the appropriate number format using Quick Formatting We need to tell the number field to display the values as a price with currency and two decimal places.…
-
Subtables
A subtable (composition) creates closer relationships between tables. When we want to write an invoice for consumption after a successful event, the invoice will likely consist of various items.…
-
1:N relationship
This type of relationship, where 1 record from one table can be assigned to many (N) records from another table, is called a 1:N relationship (i.e., 1 to N relationship).…
