These same options are also available at field level but sadly not yet at database level. Notice in the table design view above that there are events at table level to run a script (NX language) on creation of a record and after update. Designing a table data schema automatically creates a starter form Events and triggers If this visual approach is too tedious, it is also possible to carry out the form design task in a more traditional way by selecting and data-schematising all of the fields on a single screen first before then adjusting the look of the auto-generated form. Form design is a drag and drop joy and the forms it produces look great and are very usable. Let’s face it designing forms can be a total pain in the ass, even the best databases out there struggle with front end form design. This is a feature which will be welcomed by power users and those who wish to copy and paste data into a spreadsheet for more powerful data analysis, statistical and charting solutions. It now also allows inline editing like a spreadsheet without having to rely on the popover forms to edit records. Ninox allows presentation of data in 2 main ways right now as either tabular data (like a spreadsheet) or in graphical representations with some basic graph types. NX language also forms the basis for powerful view filters for changing representations of your data. It’s true to say that the NX language is a work in progress, with new command sets available in every release but it is already very powerful. Date calculations are a breeze and strings can be manipulated and mutated easily. Ninox uses its own Javascript like NX language to allow extremely powerful data manipulation and some basic front end user interface controlling tasks.Īll of the difficult tasks are dealt with by the language’s powerful variable handling and type conversion. Undoubtedly the thing that sets a database environment apart from being a consumer level hobbyist product is a good scripting language. The best thing of all is that as soon as tables are linked, all fields become programmatically available to exploit with the powerful scripting language. The relational model allows different tables of data to relate to and refer to each other. This greatly aids design of database schemas and visualisation of relationships. Powerful Relational Databaseīut Ninox goes much further than those simple needs, it is a fully fledged relational database system allowing 1-to-many and many-to-many relationships via a visual data model designer. For those tasks, key features like dropdowns for classification, embedding images (you can even shoot them from the iphone / ipad versions) and attaching documents are all well covered. To call Ninox a simple personal database is an injustice, although it will do a perfectly capable job of those simple tasks like organising your object collection or keeping an inventory.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |