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

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