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

Read only table

I would like to make a table accept data, but once entered it can't be altered, Any ideas?

• Answered

Import csv Error URI

I have Problem to import from csv, there are some procedere. I export my table Documentos to csv and try to open in a new identical Database where Documentos is empty. URI error

Expression to place non-printing ascii codes into text

The first 16 values of ascii/unicode are non-printable. e.g. 01, is null, 12 is form feed, 10 is line feed, 13 is carriage return, etc. I don't find any function in the language for ascii codes.…

Auto Import into Table

Is there a way in Ninox to auto import a CSV or plain text document into a specific Ninox table? Perhaps a PowerShell script of some sort.

Ninox for Mac vs Ninox Cloud

Hi, Do I need to subscribe if I only want to use Ninox on my mac?

• Answered

Is there a way to transfer multiple fields from one table to another?

I created a table with a long series of fields but I only realized now that some of these fields would work better if I put them in another table by linking it to the first one.…

Use Formula field to display subset of a linked table??

I have a table called "events". I then have a sub-table called "Expenses"(1:N). I want to create a formula field that only displays records from the Expenses table that have a specific type(one of…

Building table relationship 1:N

I have two tables I imported from a previous database. They were linked by an ID number. How do I recreate the relationship between these tables on the imported ID number fields?…

How do i track payments and update the new balance due?

We sell each customer one item and most of them make payments on it till it is paid off. We take in a CSV for each job that gives the DB the full total.…

• Answered

Formula don't work but no errors

I have this Formula but don't work, the HITOS is a Multiple choice Dynamics with 5 Options. I Try with HITOS = number(5) but not work if FechaF5 <= DataDate and FechaF4 !…

• Answered

How do i get my numbers $ to format right?

I can not get my imported in number - totals to format to show right. I have changed the formatting to every setting in their and none work to fix it. This is how they come in from my CSV files.…

• Answered