1/5/2024 0 Comments Ninox vs accessThis is especially likely as the UI imposes no real control over how data is entered. However, linking rules between tables can be broken (it’s possible even to break a one-to-many rule). This means that user's slowly gain knowledge and experience with a relatively gentle learning curve.Įssentially a relational database at heart, Airtable is pretty visual in how data works. The language is used for everything from formula fields to complex processes manipulating multiple records. Ninox's NX language is very powerful and integrated into the system in a way that makes it particularly easy to learn (with a beginner mode). The Deluge language is very efficient (in terms of the amount of code needed) when manipulating data and enables creator to provide a relatively steady learning curve from beginner to expert. However, I am constantly surprised by what can be achieved without code. I find the JavaScript option quite unfriendly and cumbersome and not suited to manipulating data – but for the seasoned JS developer this may be ideal. It’s also possible to use either Integromat or Zapier for this purpose. Knack doesn’t have its own language but can be programmed semi internally using JavaScript. It is possible to implement automation externally using Zapier or Integromat – or coders can use the API. Ninox has the usual capability to create file fields and images will be displayed on the edit / detail screens.Īdditionally, there is a generic attachments tab (along with a comments tab) for each table.Īirtable includes formulae, lookup fields etc – but no language or macro features. Usefully, you can specify sizes for thumbnails for each image which can then be used for displaying images at sensible sizes in tables etc.Īgain, the features here are similar to Knack in that you can choose the size to display images etc. This makes it ideal for teams dealing with media content such as design agencies, marketing departments etc.Ī more traditional approach here allows you to add file upload and image fields to the database. Multiple files can be uploaded to the same Attachment field. Like Knack and Zoho Creator, views can be filtered by logged in users.Īirtable has great features for handling documents, images etc. Once again, comprehensive control is available to determine what users (individually or by group) can see, edit, create or delete. This includes both feature level access and row (data) level control. Very comprehensive features allow builders to quickly provide multiple levels of access to data through a UI which responds to the settings for the logged in user. In the light of GDPR and similar data protection laws this could lead to significant compliance issues. Users can be given Creator, Editor, Commenter or Read only access but once they have access to a ‘base’ then they can see ANY of the data within it. Tabular, Grid, Kanban, Chart, Form and Gantt views can be created. For the end user, the result is a very pleasing interface to use with apps mainly working with panels which slide in and out. The difference is that you need to be an Admin user to access any design tools. Ninox takes a different approach in that the design view and live view cohabit (like Airtable). My only issue is the cumbersome way Sub-forms are handled. Like Knack, the developer can build rich UIs including the ability to trigger emails and other events and workflows. Like Knack, the UI is separate for developers and users with the paradigm based around Forms (creating a form also creates the Table behind). Particular strengths are the ability to produce pages with multiple tables and other ‘views’ which enable a rich user experience. Recent additions of Personal and Locked views help a little here.īuilder: The Builder is where you create your Objects (tables) and then the pages, reports (cross tabs, charts, maps etc) which the user sees.Įnd User: The end user gets a relatively modern, responsive UI which is well ‘locked down’. In my experience, the Spreadsheet UI design leads inexperienced users to approach their databases like they would a spreadsheet and this can lead to some poor database designs. This means that there is risk of users changing things they shouldn’t. I have been using these four database/app building platforms for some time now and thought it would be useful to do a comparison of their features, strengths and weaknesses…īeautiful – BUT you are working in a Spreadsheet like UI which is both the design and end user environment. In this revised article (now including Ninox), I am going to compare the features of Airtable, Knack, Zoho Creator and Ninox – three of these are platforms I’ve chosen to work with for clients following an extensive evaluation of the no/low code database market (I no longer provide Zoho Creator services).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |