Database Architecture

Show two tables in one view

Hi there - has any body tried to do this and how will it be done ? The case is that I have a table for purchases (Danish name "Indkøb") An a table for Sales (Danish "Salg"),…

Locked out of our private server !

We have a licence extension to 27th November but have been locked out of the system over the weekend - this is outrageous. The support team are unresponsive to emails - I suspect intentionally so.…

Table or Sub-Table?

Hi, I'm building a database for my company we do production and sales and I'm confused when to make a related table and when to make a sub-table. I understand when I make a table invoice - with…

If I upgrade to the new version 3.13 what would happen to my current database on the previous version?

Field of type JSON

Hello Friends, As I make a database app for my own food business, I am in the process of designing the menu table. The menu items come in varied units like (piece, container, plate, meal etc.).…

Table architecture with a 3 levels or deeper hierarchy

Hello friends, By any chance is it possible to have a Table architecture with a 3 levels or deeper hierarchy in Ninox? Below is the current structure of my database and desitred structure (if…

Complex criteria for Select

Hi, I am working on a project which requires a dynamic choice field to be populated by the results of a select based on one or more of four criteria. The criteria are selected at the top of a…

• Answered

Query regarding the sale price per item in Sale Order

Hello friends, This query might sound very basic, but I have some doubts about it. I am starting to develop a small sale-order system for my own food business.…

• Answered

How to maintain rates in old transactions

@Sean@Fred@Sotirios Zormpas Hello friends, This query might sound very basic, but I have some doubts about it. I am starting to develop a small sale-order system for my own food business.…

Using SNAGIT for tutorials

Hi, I use SNAGIT and it occurred to me that it could be a useful way to create user video tutorials. SNAGIT allows one to create a video and then share it via various methods such as Screencast which…

Help Needed: Error: Database Connection Failed on Ninox

Hi everyone, I have migrated my complete data from Salesforce and imported it successfully, yesterday it was working fine, but right now, I'm encountering an error while trying to connect to my Ninox…

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…

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…

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

Issue with trigger conditions in 'Liste' Field: Multiple Text conditions not triggering as expected

I have an issue with a trigger in the 'Liste' field. I would like to create multiple triggers in the 'Liste' field that check if certain text is contained within it.…

• Answered

how to duplicate a subtable using a button

Hi everybody, I've created a table (Offertes) which has one subtable (Offertelijnen). Using a button, I would like to duplicate the record in the parent table as well as all the records in the child.…

• Answered

Mac app upgrade to 3.11.8 failure !!

after upgrading the Mac application, when starting the application, the system issues the attached alert.... could anyone help me ??

<Trigger after open> scripts

I have code in 'trigger after open' that is causing ninox to hang/ crash. Is there a way to remove this code or prevent the running of this code on startup?