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?

Multi language solutions best practices

Hi again. I don't know if this is the best place for this question, but I will try... Here in Spain, about 70% of our clients sell their products and services in at least 3 languages: Spanish,…

• Answered

show only relevant table columns based on two criteria

Objective Map relevant terms, people, and institutions to respective slides. Hurdles Show appropriate table columns based on source/target language. Hey Ninox Experts, Hey@Fred /@Jacques TUR ,…

transaction or deferred

the query below currently takes almost five minutes (browser) with just 30% of the final data expected. It's okay to wait this long , but I was wondering if anyone has an idea how to tweak its…

Dynamic Dropdown sorting

Is there a way to sort the contents of a dynamic dropdown?