Hide Empty Fields

I have a statement type database. There are several line items in the database for description and cost of each item. I would like the description and cost fields to be hidden if they are empty,…

Report to print multiple tables

For legal reasons I need to keep backups of my records. I think I need to save PDFs of my tables beyond just using Ninox's backup feature. I've found that I can print what I need by using the Print…

Constraint for multiple customers

Hello Brain Trust, I’ve worked at a constraint without success. I have several tables in the database and the tables of concern are as listed: Customer Owners Item A customer is an individual that…

Creating a template to print labels

Hi, I am creating a template within the print of option of Ninox for my labels. I created furmula field that contains Name and Lastname and the address for one label and I copied the same formulas…

logging user access?

Is there a way with Ninox to log when users access the database? I'm interested in knowing who logs in and when. Ideally would also be nice to know when they close the database (i.e.…

Take Date from another Table

I need to take a Date (FechaP1) in the ACTIVIDADES Table, from the DOCUMENTOS Table belonging to DISCIPLINAS. The Orange Date, I try with these formula but take always the same dates first((select…

• Answered

Weird issue with DB

Hi all - I'm still on v3.5.14 of the MacOS app. I'm waiting awhile before updating to 3.6. Can you duplicate the following issue? After opening the attached table, click on Invoices.…

• Answered

How to update a field from a different table?

Say I have a "Many" table called INVOICES and it has a date in it. I'd like to be able to update the parent table, say CUSTOMER, with a single date field whenever one of the invoice dates is either…

after updating to 3.6 from mac appstore, white window.

Downloaded the 3.6 update from the mac appstore. opened the app on a mac with Big Sur, App showes a white screen. Installed Ninox on a mac mini with Monterey, same white screen.…

How to use the "View" element

Hello, when we create a database, we can add an element called "View". Can you please tell me how to concrete use this field? Because I always get the error message "Expression does not returns…

Webhooks not working after yesterday's outage

Hello, we use many webhooks as "On click" events, etc... in Ninox. Yesterday almost all day Ninox cloud wasn't working. Today it works, but none of our webhooks working.…

Single user, multiple Macs

I'm interested in the standalone Mac version from the App Store for 35 euros, and store my data in iCloud to access from multiple Macs. I'm a single user,…

• Answered

Automatically create a record when a date expires

I have a table called "Jobs". This has a sub-table called "Workings". In the "jobs" table there is a "Date" field that I set manually. I would like to create a formula that,…

After update to 3.6 All platforms cannot start

After update to 3.6 All platforms cannot start

Public APIs

Hi guys, are the public API's operational? API endpoints seem to be showing no results.

trigger a field in subtable from field in mother table

I have a field named "Consegna" in a table called "Jobs" and it has 3 options "fast, standard, custom". There is also a "Data" field which indicates the project date.…

Access my databases online without a Ninox cloud account?

Can this be done?

Counting Confirmed Guests

Hi Guys. Hoping for some assistance. Trying a work a formulae that sums the total amount of guests that have "Check In" to an event. My current formulae is Checked In = 1 (Yes) sum(Guests['Checked…

SQL “flavour”

Is there a proper, up to date reference on the SQL that Ninox uses anywhere that doesn’t involve picking through sample apps? I’m a MySQL user mainly (I’ve used some MS SQL and ages ago, Access).…

How can i get totals from a job type?

I have 3 job types Wedding Setup Family Portrait Wedding Officiant They are all in the customer info under Job Type. How can i get a total for each job type for month and for year?…

How to Duplicate a table also with a subtable

Just quickly created Table 1 and Copy Table 1 for example, I'm wondering duplicate Table 1(Table 1-1) to Copy Table 1(Copy Table 1-1), but only able to duplicate the main table's field,…

• Answered

2 questions about views

Hi, I was playing around with views and started wondering about a couple silly things: 1. When creating a nee table, the default table view is created.…

• Answered

2FA?

Does Ninox support 2FA — either for the developer or for ordinary non-developer users?

How to extend child table in report to show more records

I have an Expense Claim table in which I have a child table with the claim details (Date of expense, Description, Amount in Local Currency, Exchange Rate and Amount Claimed.…