FAQ

Ninox on the App Store: for Mac | for iPad | for iPhone

How can I…

 

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

Tables

Tables are the fundamental concept of Ninox. Learn:

Formulas and Calculations

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

Supplement

171 Gedanken zu „FAQ

  1. Hello, I really like this product.
    I am working on a database on currency exchange rates. You know, the exchange rate changes in real time, so I need to introduce an external API to adjust the exchange rate in real time. What should I do?
    Thank you

  2. Hi

    There is a table of A and B (A <—- B)

    Records of B table linked to A tape record are very many.
    A table <– B table
    aa a-1
    a-2
    .
    .
    .
    .
    bb b-1
    b-2
    .
    .
    .

    Connect from a-1 to a-100 (actually more)
    Copy the same query for the record of the connection, paste, select, there is inconvenience that there is a need to repeat continue to click.

    what should I do
    1. Click the button
    2. Set the value of the field for which you specified the search keyword to the variable. ( Let AA : = 'field name'; )
    3. Open the reference form. (script ?)
    4. Give the retrieval window the value set for the variable (script ?)
    5. I want to select more than one. (I only have one choice, which is very inconvenient.)

    Thank you very much.

  3. Hello. I have a DB consisting of three tables where I have used the formula field function to link a picture of an article in one table to another function in another table. The question is: is there a way to place that picture field just where i want and can I size the picture field just the way I want? As it appears now, the picture field will just be placed in pre-defined spots and I can only adjust the with of the picture field down to a pre-set minimum.

    Best regards
    Arnth Lien

  4. Hello. I have used the “Inventory” as a basis for a new database I have made. But when I try to change the picture on the homepage (not on the web version), it will not change the picture from the one that is in the template. (the one with all the containers). Is there a fix on this?

  5. Hallo Ninox-Team,

    für wann ist denn endlich ein Update für die Servervariante geplant?

    Die Versionsunterschiede 1.7.1.1 (Server) und 2.3.4 (Mac App) sind ja doch schon erheblicher Natur.

  6. If I can leave a question, Is it possible to calculate a Running Total (something that FileMaker would call a sub-summary) on a table so that the cumulative total appears as a field in each record?? Thanks. John

    1. yes; add a formula field and enter the following:

      let myID := number(Id);
      let myACC := Account;
      sum((select [tablename])[number(Id) <= myID and [tablename] = myACC].[FieldNameToAdd])

      1. I am new to Ninox and I have a similar problem and cannot get it to work. I have table “Checking” with fields “Date” and “Balance” and sub-table “Input” which has a field “Total”. I’d also like to have a running balance in “Balance” but cannot figure out what variations to your above solution to use. My original formula for “Balance” was:
        sum(Input.Total[Date <= Date])
        Any help would be appreciated.

        Thanks, Don

            1. Leo,

              Thank you for your quick help. I tried the above but it’s still not working for me. I get the error message

              “Field not found: Date at line2, column 14″.

              I tried replacing that field by deleting the text “Date” and then clicking on the field name in the left hand pane. I’m still getting the error message. Suggestions?

              Thank you,
              Don

Leave a Reply