FAQ

How can I…

... decide which Ninox product do I need?

Ninox offers two product lines:

Ninox Cloud - our cloud service for any browser.
This is our subscription service. You can access your Ninox databases from any browser. You can manage roles and authorizations for team work. Our cloud offers additional data security through extensive data protection measures and is hosted in compliance with the GDPR. You can also access the Ninox Cloud teams from the Ninox App.

The Ninox Apps for Mac, iPad and iPhone.
Here your data will be stored locally or in your iCloud. There is a one time payment for the Mac App, a one time upgrade in the iPad App (only if you want to use the iCloud sync), the iPhone App is free. The Ninox App is basically for a individual user. Synchronize databases from your iCloud on up to 5 devices with the same Apple ID (requires Mac app and/or upgrade of iPad app).

... test Ninox?

The Ninox Cloud version is also our trial version, as it is hardly any different from the app in using the software. We invite you to sign up for the trial version for 30 days. The trial period is not automatically extended and does not automatically pass over into a subscription. Of course, you can transfer the databases you created during the test phase into the Ninox App for Mac, iPad or iPhone later.

... use the iCloud Sync Feature?

With the iCloud Sync feature the same databases can be accessed from multiple Apple devices. To use the iCloud Sync feature choose iCloud as store location when creating a database. A little cloud will appear on the database. If you already created a local database you can duplicate and choose iCloud as store location.

To use the iCloud Sync feature on iPad, please upgrade to Premium.

... modify iCloud databases on another device?

Ninox databases can only be modified on the device they have been created on. Ninox has this setting to avoid conflicts. With “reorganise” you can re-allocate the admin rights to another device. You find this function by clicking the menu button of a database. On iPhone swipe the database to the right.

... backup and share Ninox databases?

Ninox databases can be saved and exported as archives. The resulting .ninox files can be imported with every Ninox version. Use “Save Archive as…” from the main menu in the top left corner to export archives. Use “Import archive” from the start screen to import.

… export and import data?

Ninox allows you to import structured data via csv-import. Ninox will try to match columns in your csv file to data fields in the database. Start the assistent be clicking in the wrench an seleting “Import data…”

Date fields are the hardest to get right. The Ninox date format depends on the system settings. Ninox will use the”medium” system settings. If in doubt try “yyyy-mm-dd” – this will always work fine.

The wrench menu will give you “Export data…” to. An assistent will guide you.

Mac app: To export all tables select “Export data…” from the title page of the database (the one with the fancy bachground image). Here you can export all tables to excel or export the Ninox database without data as an .ninox archive.

… import my contacts?

With Ninox you can import all contacts from the Mac contact app.

  • Click on the database homescreen on –> import data.
  • In the following dialog choose “Contacts”.
  • Install table template
  • Import Contacts

… search?

Ninox provides two search functions – global and local search.

The global search can be accesses via the magnifing glass in the left side bar. Here you’ll search the whole datadase.

To search a table only press “cmd + f” or use right click to select “find”.

… create an auto-incrementing number for invoices or clients?

Option 1: Create a trigger (“on create”) on table level like this:

'Invoice Number' := max((select Invoice).'Invoice Number') + 1

This will check all existing invoice numbers and will fill the field “Invoice Number” with the next number.

Option 2: A little bit more fancy – Create a trigger (“on update”) on table level like this:

if not 'Invoice Number' then

let y := year(Date);

let m := month(Date);

let d := day(Date);

let c := cnt(select Invoice where year(Date) = y and month(Date) = m);

'Invoice Number' := y + format(m, "00") + format(d, "00") + format(c, "00")

else

void

If will give you an invoice number like this:

2016122205

yyyymmddxx – where xx is a counter of invoices per month.

… create and read barcodes?

Click in any field and scan barcodes or QR-codes. The scanner (or camera) will work as an input device.

Output fields as barcode: You’ll need a barcode font installed on your system. In “Print” you can set the font for every field seperatly.

Note that barcodes have the value stored like this:

*123456* (Note the asterisks)

… use the location Field?

To set a location:

  • Click into the location field.
  • Maps will open.
  • Find the location and double-click.
  • Give a name.

… restore local database with “time machine”?

Use “time machine” on your Mac to create regular backups of all your files.

  • Open finder
  • Open menu “go”
  • Press “alt”(+”Shift”): “library” appears
  • Select library
  • go to “Containers”
  • go to “de.ninoxdb.ninox-mac”
  • go to data
  • go to “Documents”
  • go to “data”
  • open time machine
  • go back in time
  • pick the database to recover
  • restore

Introduction

  • Learn what Ninox can do for you in the Basics chapter.
  • The tutorial will help you understand the main concepts of Ninox.

User interface

  • Learn how to create and manage databases on the Ninox start page.
  • On the database homepage you can:
    • Create and modify tables
    • Modify the data model
    • Adjust the options
    • Import data from different data sources
  • Use the calendar to visualize date-related records.
  • Take full advantage of the Ninox full-text search.

Tables

Tables are the fundamental concept of Ninox. Learn:

  • How to create and modify tables
  • Which data fields Ninox provides and how to use them
  • How to connect one table to the other to create table references and relations
  • How to use the data entry form
  • How to create views in order to filter, order, group and analyze data
  • How to use filters in views
  • Charttypes

Formulas and Calculations

With formulas and calculations you can add new data-fields or columns and calculate values or implement triggers.

  • Formula Editor
  • Triggers
  • Mathematical Functions
  • Logical Functions
  • Text / Date functions
  • Function and Language Reference

Supplement

  • iCloud Sync
  • Import Data
  • Importing Linked Data
  • Importing from Bento
  • Importing Attachments
  • Exporting
  • Printing
  • Mass Data Updates
  • Ninox Pro Installation