Default value for Location (lat / long)

The following steps are needed to record the current location when using Ninox on an iPad. I see now "default" value. Is there a function that can be called?…

sum and count function?

Is there sum and count function for column

Calculation of dates

Is there a formula that will return a date after a certain number of months, years or days from a given date? For example, If the date entered is June 27, 2005 in Field 1,…

Changing database icons and colors

On the home screen showing all your databases, how does one change the icon and the color of the databases? Using standalone ninox, v3.18.13 on an iPadPro(4th Gen) with iPadOSv18.7.8.

• Answered

Issues after update

Hi, I'm having serious issues with my print layouts (not working anymore and fields no longer giving data) and formula fields not filling in the form (but they do fill in the table view.…

Dynamic Drop Down List sort order? and Pre Select?

So Guys - My question is in 2 parts Firstly my dynamic list (Pcode) is sorted in order by text (A-Z) but as you can see from the screen shot. The list is out of order for each product that has qty…

Open child form from table (fill in data) abd return to main form.

I have a main table (quotes) and child tables (quotelines). up to now, I have used selected data entry fields on the main table form and then used a button script to copy that data into a child…

• Answered

Return of ID Number

i found a disscusion >>Formular for current records ID?>> there is described how to get the id Number of a record.. but if i try tthis: let me := this; number(me.…

• Answered

Status script not working

I am having an issue with a script. All appears fine but the status is not updaing and simply defaulting to "Order Complete" The idea is to count up the true 'dispatched' status of each 'Job Lines'…

copy table record with child records to another table record also with child records

I want top copy a "quote" record that has child lines "quotelines' into a new table record "multiJob" that will also have the copied records "Joblines".…

reset/unlink client field (field a) when advicor (field b) is removed

Hi everyone, I have a form with two relationship fields in Ninox: Advisor (1:N): Allows selecting one or more advisors. Client (N:1): Allows selecting a client who is being advised by the chosen…

Problem Ninox

I can't log in to ninox, what's going on? What a problematic week.

Something new today. Very annoying.

Please fix this. Twice today it appeared, never before. Mac desktop app.

Parent and Child reUnion

I currently have a need to create a UNION between some Parent and Child records. The fields I want to use are mappable between the 2 tables, so the resulting selections can match.…

Unique transaction Number Not Triggering from Embedded View

Hello everyone, I am facing an issue related to generating a unique “Transaction Number” in my database and would appreciate your guidance. As you see in my “Data Model”,…

Dashboard not Calculating

Hi Team, Running into some dashboard issues. My goal is to show the companies in a bar chart with the amount of open tasks they have. Optionally , limit the output to the 10 companies with the most…

• Answered

Compare tables

Hallo, I m stuck on a problem with Ninox. I have a database with 2 tables A & B. Each table has lets say 5 record sets. I want from table A view each record set in view mode. Got that working.…

• Answered

Geschwindigkeitsoptimierung: Große Menge an Datensätzen schneller verknüpfen.

Ich nutze die Desktop App von Ninox am Mac um Datensätze anhand des EAN Barcodes Produkten in unserer Tabelle zuzuordnen. In der Datenbank gibt es 188 Produkte und halbjährlich müssen aktuell circa…

How do you replace a LF or CR?

I need to take a multi line field, and for each line, add a “\n” so I can make them into a single string. Line 1 Line 2 would end up as Line 1\nLine2\n I tried the replace function with a Char(10)…

share.ninox.com

I had connected HTLM pages on my web site and all of a sudden today i receve back a page that instead of showing my ninox files is sais that share.ninox.…

Image Container does not update after edit

Hi I am building an app which uses an Image container. I can drag an image to the container and it loads and saves correctly. Clicking on the image or using the Open in editor menu item opens the…

Filter format URL for API call

I m trying to do server side filter so Ninox only returns the relevant records, however I am having trouble figuring out the format. I have the proper ids for team,…

• Answered

Formula for the button

Good evening everyone and Merry Christmas I need professional help. I'm having trouble describing the problem, so I'm attaching the database so you can examine it in more detail.…

Look up query

Hi, I do have a question to find a solution in Ninox. In one table I have a dataset. Each dataset has a Main ID#. Thats easy and works well. In a different table I have a date,…

On Premise server migration and userid's

Hello all, I am working on a physical server migration for an On-Premise Ninox database. On the new server, I will have to recreate users with new ids assigned,…