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,…

simple dynamic field - small issue

I have a small issue with looking up other related data when using a dynamic field so Table1 (Joblines) has the dynamic field in it called Pcode. this is set up point to the lookup table (Products)…

• Answered

Release Notes gone

https://forum.ninox.com/t/g9yzkrh/release-notes Where are the Release notes < 3.17.17 ? Can you bring them back?

Auto-fill field not triggering when record is created via popup — is this expected?

Hi everyone, I’m running into an issue with my database setup and I’m not sure if this approach is valid. In Table 1, I created a text input field called “BB”.…

• Answered

If data can be exported between databases, what’s the point of password protection?

Hi everyone, If data can be exported between databases, what is the purpose of setting a password? Thanks!

numeric order by child table field

This is not about actual families, but just illustrates the structure of the problem I am dealing with and my own actual tables and fields do not obscure the issue.…

API pagination same records repeated

I'm learning the basics of API and scripting and trying to start with a simple request - all record IDs for the given table using pagination (limit and offset) and have it saved as a JSON file.…

Help with a Formula in a list view

Hello! Could you guys help me with a formula? I have 3 tables: appointments, treatments, products. Each related to another: each appointment can have several treatments,…

• Answered

textfield with text suggestions fetching data from same field which have the same link to a record.

i have one record, which has multiple records connected to it because they were records for time-recording. So I would like to have the possibility to get a suggestion while starting to type.…

Lost database

One of our databases was accidentally deleted. There were no backups. Is there a way to recover it?

Sorting for a View Element

I have a relation field with multiple records in it and I display it via a view element. Now I want to have some dynamic sorting by name, or by a number, but with the sorting I dont have some luck.…

Formula Problem ?

The formula in Cost Field. 'Fully Loaded Cost Rate' * first('b_Bid Hours'.'Spend Hours') 55.22 * 1,100 = 60,742 the formula give me 60,736.60. 5,5 diference.

• Answered

anmeldung Stonieren

Negative Round number make the APP CRASH!!!

I started using Ninox a few years ago. In some cases, I need to round with a negative value. For example, rounding the number 1,234,567.78 with (-2) should return 1,234,500.00.…

• Answered