-
Trigger in use
Our 3rd Invoice – With the New Price Now, change the price for Champagne to €9 in the Food & Drinks table. We change the price in the "Food & Drinks" table Now, create another invoice.…
-
Create another invoice
Our 2nd Invoice – Still at the Old Price Let's first create a new invoice with lots of champagne at the current prices. You'll see that everything works perfectly!…
-
Assign data via button
A (temporary) button does the work for us here How it works Open the Table Settings of the Invoice Items table. Add the layout field 🆗 Button. Open the Field Settings and enter the following script…
-
Trigger at field level
After we just created our first invoice, the champagne supplier informs us that they are increasing their prices. This means we also need to adjust our prices! Instead of €7.…
-
Triggers
Triggers are a cool tool for automating processes Recently, while creating the invoice, we briefly encountered a trigger when we inserted a script at the table level into the Trigger on new record to…
-
Create invoice
... and suddenly everything is so simple! All settings, formatting, and assignments are complete. Let’s create our first invoice! ℹ️ If (empty) records have already been created (this can happen due…
-
Setting up fields - Part 2
Let Ninox do the work ... To automate tasks, we store information in certain fields to assist us. How it works Go to the subtable Invoice Items. Enable edit mode 🔧 We go through the (white) fields…
-
Sub-table (overview)
We take a detailed look at the subtable In the invoice form, open the subtable form by clicking on + Create record. Let's take a closer look at the subtable.…
-
Customize subtable
Here you will learn how to configure the subtable according to your needs The subtable Invoice items is displayed in the form view of the table Invoices.…
-
Excursus 2: Composition
... a little more theory Furthermore, we have added a subtable (composition) to the table Invoices, which is very closely linked to the table Invoices. You can see this close connection on the left…
-
Ninox public cloud down?
Haven't been able to create or modify records, use make.com integrations, or save code changes since Feb 18. Anyone else having this issue. No communication from the ninox team, and no place,…
- Answered
-
API: Sort order not working when combined with filters
Hello! I use Ninox to maintain my collection. I want to display my most recent purchases on a website using the API. This works great as long as I do not apply any constraints through filters: https:…
-
Private clouds unavailable
I wonder if the previous message: "Due to a temporary outage at our hosting provider, some Private Clouds are currently unavailable. The service provider is already working to rectify this.…
-
Creative Suggestions Needed for styled() within a Formula
I plan to utilize the styled() function within a Formula for user alerts, messages, and details. The only way I know to achieve this is to create a separate Formula for each alert,…
-
images in rich text do not appear in the PDF export – Need help!
I have 5 fields in my Ninox database: Tittle Description Img1 Img2 Img3 Rich Text I have created a button with this formula: Rich Text := "<h1>" + Tittle + "</h1>" + "<p>" + Description + "</p>" +…
-
CRM & Activity Management Webinar this Thursday, February 20th at 12:00pm EST/ 5:00pm GMT/ 6:00pm CET
Building a complete ERP/CRM solution from the ground up: This week - Thursday, February 20th CRM & Activity Management 12:00pm EST/ 5:00pm GMT/ 6:00pm CET FREE REGISTRATION: https://us02web.zoom.…
-
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.…
