Release 2.5 Out Now
By Frank Böhmer
On 18 December 2018
Right before christmas we finalized work on release 2.5. This one is a huge update: We implemented four new ways to visualize data. We extended the Ninox forms with handy features like tooltips and styling for headline and free text elements. We enhanced the options for background images, colors and gradients on the team screen. And we worked on countless small improvements based on the Ninox community's feedback.
Views have always been one of the most important concepts in Ninox. With views you can filter, slice and dice your data and display tables in various ways, even as charts. This time we move to the next level, introducing four new types of table views:
- The Kanban View
- The GANTT View
- The Cards View
- The Form View
All new view types can be created, by clicking on the (+) button right besides your view tabs.
The Kanban View
Kanban views are a super-useful tool to manage resources, assign tasks or track the status of your invoices. To configure a Kanban view, Ninox will ask you to pick a grouping column. For every group it will display a swim lane. Records will be rendered as cards on the swim lanes. And the best this is: Just by drag and drop you can move around cards from one swim lane to another, modifying the underlying field - e.g. a status field.
The GANTT View
Time-related data can now be rendered in an intuitive way as a GANTT chart. Ninox will pick the first appointment column or the first two date / date+time columns from the view's configuration to render the bars of the GANTT chart. And just like the Kanban view, GANTT charts are interactive: When dragging around the GANTT bars, Ninox will automatically update the underlying fields.
The Cards View
Tables are an effective way to display many records with high information density. If you're looking for a more visual approach, the new cards view will be the way to go.
The Form View
By combining forms and tables in a split view, Ninox lets you quickly navigate your records while providing the form as a flexible tool to edit your data. However, In some situations the form is more important than the table. And that's where the new form view kicks in: It just shows the form full screen, in full beauty.
New Checkbox Option
Checkboxes can now be rendered as a slider button.
Styled Headlines and Free Text Elements
The settings for headline and free text elements do now sport an additional style parameter. Use this to add more color to your forms. You can configure font size and style, color and background color as well as several border style.
For all field types, Ninox does now give you the option to configure an optional tooltip. A great way to provide your users more assistance when working with forms.
Data model protection
Changing the data model is possible for any user who has the role "admin". The new data model protection feature allows you protect the schema even for admin users with an additional password. This password will be carried on, even if you export the database as a Ninox archive and reimport it into another Ninox team. The data model protection is available on the options tab.
Global Function Definitions
Ninox does now provide an option to store logic, that is reused in multiple occasions, in a central place. On the options tab, there's a new setting for globally defined functions. To give a short example:
function hello(name : text) do
"Hello " + name + "! Good to see you."
function bye(name : text) do
"Good bye " + name + "!"
In any other part of Ninox you can call those functions:
Trigger on Open
On the options tab, you'll find a new setting for scripts that will be executed as soon as the user opens this database. This can come in handy for a wide range of use cases. For example, you could welcome the user with a dialog(…) or alert(…) call. Or you could lead him directly to the most important table with openRecord(…).
Ninox does a lot of of auto-magic to optimize queries and performance internally. In some cases, it needs your assistance, though. With the new option to create an index on a field you can speed up select statements that compare this field to a certain value. We recommend to not make use of this new setting until you run into performance problems especially with long-running scripts. For now, the index settings is only available on the web-bases version of Ninox.
Field and table settings provide a new option to exclude certain fields or whole tables from global search. This will help you to improve search results.
Scripting Language Improvements
With the new function createTextFile(record, contents, filename) you can create file attachments for a record:
createTextFile(this, "Hello World", "hello.txt")
The command openFullScreen(record) will pop up a screen-filling form:
With closeFullScreen() this can be closed again: