įormula fields may also utilize simple logic functions such as and, or, greater than, less than, and even if-then-else. Contract Invoice indicates and existing table reference and its direction. For instance, summing the cost of items on an invoice or concatenating first and last names.Īdding fields to the Contacts table. Additionally, there are formula fields that can perform a number of calculations on the data in said fields. Ninox provides a wide variety of field types: number, text, date, image, calendar, URL, phone number, color, icon, multiple-choice, yes/no, etc. We might argue that the arrows should be reversed as Contract Invoice is the table receiving information from the Billing Clients and Pay Rates tables. The relationship between three tables in our test database. in your invoice table, you create a company table, add the company records, then reference them in your invoice table. For instance, if you want choose from a list of clients to insert their address, etc.

These are linked via table references in Ninox. Ninox is a relational database, so tables (sets of records, like rows in a spreadsheet) may access the data in other tables for display and calculations. Ninos also has a server version for larger businesses. If you do want to spend more–or more likely, service a small, medium, or large business–Ninox has an identical $10 monthly online version that Ninox for Mac interfaces with, as well as iOS and Android clients. The kicker is, Ninox for Mac is only US$35 the $540 FileMaker Pro is very powerful but appreciably more high-maintenance. But it's so darn pretty, easy to use, and flexible. Not because it's a powerful relational database–been there, done that. Ninox for Mac (and its other iterations) wowed me. It's not very often that I run across software that is truly impressive.

Database application for mac