Regarding the issue of modifying a sub-table of a sub-table.

Created an order database. The Orders table records the product details of an order; the Products table records product names and quantities; the code table records code information, etc.…

• Answered

Help with code to create non-repeating set of 10 numbers

So I'm working on trying to create a non-repeating set to 10 randomly selected numbers between 0 and 9. I have this in a formula field: let x := [number(void)]; while length(x) < 10 do let newItem :…

• Answered

Populate a field with values from a list

Hello! I need to write some values in a field. There are around 10 different values, that i want to put in a field in random order. I guess i first need to put them in a separate table,…

Mac app update to 3.11

After updating the Mac app to 3.11 I get a white screen with no database???

Issue with a script that does not display the expected value when two fields are equal

Pgr.('Total Earned Value' := if cnt((select 'Progress-Cost Report')['Total Earned Value' = xFld4]) > 0 then null else xFld4 end); The problem with the part script is that when the "Total Earned…

How to use code to remove extra information?

I have set up two text elements in the database, and text1 contains the following information. 2222 333 44553 1234 How to set up a button to remove the extra spaces in the content of text1?…

• Answered

Some idea ?

let vDd := 'Add Data|Date'; let check := dialog(" Warning ", " ¿Confirm the Progress Update by Disciplines ? ", ["Yes", "No"]); if check = "Yes" then for loop1 in select 'CutOff Days' do 'Add…

• Answered

Previous record

I am new to Ninox. I have a simple database to keep track of mileage on my car (to check on Allstate numbers). Thus far, I have only two data fields: date and odometer mileage.…

• Answered

Parameters it is possible to pass to a function

Hi, fairly new to Ninox and now in the process of "tidying" up a database which has become a bit untidy in terms of number of fields and duplication, this thread sort of fits with what I am trying to…

• Answered

Choice (dynamic) Combobox Behavior

Is there a method to tweak the behavior of the Choice (dynamic) Combobox such that either 1 - an option can be selected from the dropdown list - OR - 2 - new text not found in the dropdown list can…

NINOX upgrade question - is it worth it?

I am using version 3.8.11 in a private cloud. Three questions: is the latest version faster? Same overall processing speed? There was chatter about the "select" function being slower.…

POS System ( Sales,Income,Expenses,Stock,Supply)

Hello, I have been working on a POS System all created in Ninox, What I'm trying is that when the sale of 1 product happens (Sales Table) the product is deducted from the Stock table and money added…

Regarding the issue of the record limit in the database.

I seem to remember that Ninox Cloud has a limit of 800,000 records per database. If this limit is exceeded, how can I consolidate my data into a single database?

• Answered

Data display

Hello After I create a new day, on cloud version, windows. data is displayed like 06/08/2024 - 6 june 2024. i need to 08.06.2024. on the computer the date is displayed as 06/08/2024.…

• Answered

lost database on my phone

The Ninox app on my phone required a data migration, so I followed through the instruction and it imported all the files. But now I can't find my database, it's not showing.…

add prefixed text to textfield linked to multiple choice

Hi, Brief intro: my name is Brit and I have founded a charity to give people with physical disabilities in The Gambia mobility. I use Ninox for client registration,…

Print and save more than 1 PDF

Hi there, hoping someone can help me. I have several different Print Layouts for one table and I would like to be able to press a button and have the system print all of them in one go and merge…

Print Layout - Group filter

I'm Trying to create a print layout filtered by week and grouped by drivers, but it print layout when grouped, each group is closed and only shows totals for each driver.…

data migration required on phone can't access my database

Opening the Ninox app on my phone I got this message (see picture) above. Migrate app data takes me to picture 2. Stuck after that as I don't have any Ninox files on my phone.…

Formulae in Global Search

@Jacques TUR Is it at all possible to work your magic so that based on user wishes formula fields can be excluded from the view that result from a global search? Example:…

Formular for current records ID?

What is the formular to display the current records ID? I need to pass the current record ID to a webhook but can't find the formular. Thought it would be easy but am stuck and searching the…

• Answered

Merge visible PDF in one file

I have a table named "Allegati". Inside it, there's a field called "File" which contains a PDF. In another table called "DOC FIERA", I have created a reference to "Allegati" in such a way that if a…

Sub table query - limit to current record

I have a table -> Event Details and a subtable - Event Expenses. Each event can have expenses of different types, there is a "Type" field in the expense table.…

Script to update records in another table

So I for this scenario I have 2 tables. One is called DID the other is called E911. I have data in both tables. In both tables there is a piece of information that may be the same.…

Sync and updating

Hi. All works well on my pc, and my phone, and 1 of our tablets. All of the other tablets havent updated any of the changes made in the last 2 weeks.. Uninstalled, reinstalled, tried a manual sync,…