
Why? It is possible to make any relation, but the quantity of relations you need and the complexity (usually chaos) that comes with is huge. For nowadays the web design moved to dynamic UI where less is more, if you want an interface to be easy to read and understand, you really need to show less data at the same time, for that you need dynamic and flexible UI, which is not possible to build with Filemaker.ī) Data access/constraint: relations in the database are made in a way (classic relations between tables) that while is intuitive and easy to understand, is very difficult and limited for big and complex relations. In a simple interface with only a few fields, you can handle it easily, but for complex/flexible UI, it becomes a nightmare with a lot of data that you cannot show dynamically.ġ0 years ago it was all that was out there, and therefore the CRM UI were those big messy layouts with a lot of data. Is possible to hide elements of course, but not to adapt the behavior for the rest of the elements. When a layout (page) needs to have a dynamic interface, which means conditionals for show/hide elements and adapt the rest of the elements, you just can't. You only can build scripts and crazy relations as workarounds to simulate a kind of constraint on the layouts, but that is not efficient at all for developing and you reach the limitation in the UI soon.įilemaker a decade ago was like a mule to plow the field in the 18th century, powerful and efficient, and nowadays it is still basically the same mule, just that the ecosystem possibilities and necessities changed.Ī) UI: the interface engine is completely outdated for a modern app, is not that you can't build beautiful UI, you can, as far it does not require real responsiveness and conditionals. If you have 40k records in a table, you cannot easily allow in a page, search or element just to show a part of those records. There are privacy settings for the database of course, but the problem is that when building the UI you cannot make lists, search, and in short, any access to the records, to be really constrained by different criteria. Also the data constrain is a problem when you are building a complex app that requires either internal or external users, to access different data in a clean and easy way. But as the world is changing to web and dynamic UI, Filemaker has not made any step on this, and is getting completely outdated. It was really great few years ago, powerful and clean for database, easy enough to build the interface. Great for database and scripts, a dinosaur for a modern app with complex data relation
