Database Architecture

Importing QuickBooks transaction report to create tables in Ninox

I have several QuickBooks companies that I would like to switch over to Ninox. I would export the data from QuickBooks from a detailed transaction report via excel and then import it into Ninox.…

real time link between local DB and Cloud DB

Hi there, with the barcodeScan I can scan a barcode via my mobile app and place the barcode info in a field in the mobile app. How do I pass this info over to the app in the Cloud,…

• Answered

Relations between records in the same table

Hi, I have a table for Invoices, where the type of the invoice can be selected: Fee requester, Proforma invoice, Invoice, Modified invoice, Storno invoice.…

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