-
Find the minimum value in a group of records
Hello Ninox users! I’m completely addicted to Ninox but still young in scripting… so… Does anybody knows how is scripted the formula used to find the min/max/… of records grouped in a category (see…
- Answered
-
Warning on button coding: "Field must return dynamic values..."
Hi there! After some trial and error, I came out with this coding that works as expected but I can't get rid of the warning sign saying: Field must return dynamic values...…
- Answered
-
How can I adjust this?
In the Home table, I selected the Alcohol option. The three charts below show the corresponding values. Starting from the second chart, I added the condition (choose=2).…
- Answered
-
Generated an array with record numbers in a formula field.
How Generated an array with record numbers in a formula field. Array. 'Booking Cod' into Formula
- Answered
-
No databases visible after updating to Ninox 3.11.3 on macOS
I recently updated Ninox through the App Store, and now my Database overview is empty. Even newly created Databases are missing. Is there anything I can do, or do I have to wait for a fix?…
- Answered
-
want to use a button to check if the content of A in table 1 is the same as the content in the associated table 2….
I have two tables (1&2), I want to use a button to check if the content of A in table 1 is the same as the content in the associated table 2, and the number is also the same (the content of A may be…
- Answered
-
index with regex
I'm trying to find a way to get the index (i.e. start position in a string) for a regex pattern. I can use text, replacex, extractx for various operations but not for getting the index,…
- Answered
-
Field txt to date(dd/mm/yyyy)
There are any script to convert a field txt to a date format (dd/mm/yyyy)
- Answered
-
Updating records in the DB
I have several databases, and once a month, i need to transfer information from all databases to a mine database. The problem is, that the data is not updated, it is copied.…
- Answered
-
For the question of using N:1 search
When searching for the same content in the same database, there is data returned on the MAC port, but no data is returned on the web port. how are the search keywords defined?
- Answered
-
calendar option missing
I have Ninox Mac version 3.10.10 and my system is MacOS Sonoma 14.2. I have a MacBook Pro 2020. I unistalled Ninox from my iPad and iPhone, I have been working with this 3 devices and I have data…
- Answered
-
Button to apply filter to sub-table
Hi everyone, I've got a main table 'CONTRAT' that corresponds to our technical contract where i can find the start and end date, name of the client... And a sub-table 'INTERVENTIONS' that corresponds…
- Answered
-
Questions sur le choix multiple (dynamique)
How the first multiple choice affects the next multiple choice. I have uploaded the file, thanks for the reply。
- Answered
-
Sum Based on Choice
Trying to add up all totals from multiple records based on a choice. Data Base is called Receipt Details. When I choose a month, for example OCT under Statement Month,…
- Answered
-
Click on button in Ninox to view Gmails
Hi everyone, I'm new to Ninox so forgive me for asking this question. When I'm logged into Ninox and also my Gmail account, I'm wanting to click on a button that searches for all emails related to a…
- Answered
-
double click in a cell puzzle.
Can someone enlighten me please. double click to edit a cell content is not possible in all cases. Sometimes when I try the form slides in from the right on the first click.…
- Answered
-
Rounded amount
There are two fields in the table, and when they are equal, it shows green in the middle, when not exactly red. For convenience, the amount is rounded off to the left and shows the amount without a…
- Answered
-
Duplicate multiple records to another table
Hi I would like to succeed in creating a button allowing me to transform quotes into invoices. In Ninox, my quotes are built like this: When I create an estimate,…
- Answered
-
Problem N:1 Activity_Name
@ Fred On Staff Hour table, I create Activity_Name (N:1 'Staff Hours' To Activitires) for select the Activity. With the Add Register button add the info to ' History Hours' but no find the way to…
- Answered
-
Multiply a number to get a status
Hi ! How would it be possible to modify a loyalty status (which corresponds to a number) according to the sums spent. Example: the threshold for changing loyalty level is every €600 - Case 1:…
- Answered
-
OPENAPI
I'm trying to write the openapi-api code to import company data from the VAT number. I can't figure out how to tell which value to put in which field. I don't understand anything about API but I'm…
- Answered
-
VIEWING IMAGE SIZE
Once I've uploaded an image to an image field, is there any easy way to see how large the file is? It might come up on mouseover or right click, but it doesn't.…
- Answered
-
Table cels Background color
Good morning, I would like to create a rule so that the background is green when the indication is 'NO' and green when the indication is 'YES'. I saw that NINOX provides this for sub-tables,…
- Answered
-
Limit the number of rows visible in a table view
Hello ! I have a table view on my dashboard that sorts customers by amount spent. I would like it to display only the 5 customers who made the biggest expenses.…
- Answered
-
Calculate the most recent date of an activity
Hello, I would like to know if it is possible to have a formula field that allows me to display the date of the most recent activity of a contact (the date of the most recent appointment and not the…
- Answered
Answer questions and share your knowledge