Claris FileMaker vs. Power Apps

I think FileMaker [Pro] is a great solution for a small business wanting to take the next step from managing data with Excel spreadsheets to actually using a database. It is very intuitive to use and manage. A tech-savvy user can learn to use FileMaker [Pro] very easily without advanced skills as a developer.

Incentivized

PowerApps is well suited for "quick-wins" and fast prototypes of business solutions. It also is beneficial for situations where business partners and developers work together - it allows the business folks to provide a "quick-and-dirty" prototype which is then fleshed-out by developers that are trained experts on the platform. The interactive and easy to understand representation of the solution allows business partners to "see" the solution and add, remove, or correct aspects of it themselves. It provides a common view and understanding of the actual solution across business units and tech teams. PowerApps, being a low-code\no-code platform is not well suited for business processes that require many complex computations or large amounts of custom code - such as solutions that are better architected as Web Site or "full-blown" desktop solutions. There are solutions that are just not easy or quick to accomplish in a low-code\no-code platform. Enterprise Architects should know the difference, however business partners often try to create a solution and only when stuck because it becomes too complex do they engage a tech team for assistance - at which point there are sunk-costs involved and hinderences to re-platforming the solution

• The relational database management system makes the program highly customizable to fit the needs of any product. You can add a ton of information to each record and update your inventory on a regular basis with an Excel import or manually inside of the record. It has the capability to incorporate barcoding, which can manage your available inventory with ease.
• The scripting language allows FileMaker to automatically calculate complex algorithms automatically or generate report outs with the click of a button. This allows for greater UI, especially with active users who are not familiar with writing code. Almost all of our internal data is linked to the FileMaker database
• The server license allows many users to update the database in real time, which is handy if your inventory is constantly changing. We have users with Macs, PCs, iPhones and handheld tablets linked to our FileMaker database and they are updating the information constantly throughout the day.
• If you invest some time into formatting and scripting the database, there is a high ease of use for users without knowledge of any programming or FileMaker itself.

Incentivized

• Power Apps has formats that are pre-built that don't require any coding which makes it easier to achieve your vision. This does become a challenge if your App needs don't fit into that format.
• We deal with a ton of data so the fact that you can connect to any data source in addition to their pre-stablished data connections makes the process a breeze.
• The online learning resources and tutorials are helpful as well for those who are tech savvy.

Incentivized

• I had some big complaints about how to edit calculations and scripts, and not being able to print/export PDF from server but with the last 2 versions I can't complain any more. Those got added.
• Syncing records between iOS and Filemaker Server still requires a developer to accomplish. Although I make money doing it for others I wish there was some "central" method of syncing that everyone can follow.

• More complicated to understand in comparison with Nintex Forms.
• Complicated to find errors.
• Using PowerApps for SharePoint Forms is a bit complicated by setting up the start and load scenario with a lot of JavaScript.
• Load values, change them by code, and save them back could be easier. Actually quite complicated to handle a lot of variables.

Incentivized

It it not really up to me but my opinion does have some weight in the decision and the reason I would renew my use FileMaker Pro 8.5 is because I am finally getting used to it! Now that I have been working with the program, tasks have become quicker and projects are getting done faster. File Maker Pro 8.5 really is a versatile tool and I think we are just scratching the surface with it's abilities.

Incentivized

It's almost what it should be after so may years and with Apple's longevity and strength behind it. For people who earn their living based on efficiency I think there are too many developer obstacles that waste time and therefore money.

Incentivized

PowerApps is a great solution and I have spent the last year familiarizing myself with the platform and building custom applications to complete a whole range of tasks such as asset management, custom invoice generation, and item restriction tracking. We as a company have barely begun to scratch the surface of what can be achieved with PowerApps.

Incentivized

mostly never issues and if there are they are resolved fast

Incentivized

for the most part but lots of error messages if you type something h correctly

Incentivized

The forums are great with lots of helpful experts and the staff monitor them to provide help where needed. There have been a couple of unique technical issues I've had to deal with that I haven't been able to get resolved so I chose to score this a 9 instead of a 10.

Incentivized

The community forums are extremely responsive to questions asked, there is a good body of online documentation and many community posts to draw from. Although the platform has changed, which means some of the posts are out of date and the solutions provided aren't relevant. Of relevance, I read over 400 articles plus documentation to get this first app built in SharePoint, move it to SQL and make it work exactly the way it should.

easy to follow along and was able to jump in right away

Incentivized

Suggest you use an iterative R.A.D. or AGILE development approach. (i.e. rather than writing a gigantic spec for a system, then building it). FileMaker facilitates quick prototypes. Developing an example, then allowing users to "try it out" is a snap.

Incentivized

FileMaker Pro is the chaotic, cumbersome and non-integratable little sibling of MS Access. And even MS Access can't be taken serious in a medium sized company. FileMaker Pro can not even be compared to serious products like OutSystems and Sitecore. It's also not free... whereas at least MS Access can be used free, even if your company is (really) small.

Incentivized

Power Apps is great for rapid app development and internal business solutions. It helps build user-friendly applications quickly and is a great, cost-effective option for existing Microsoft customers like us. Even non-developers can get started on using Power Apps without much difficulty. Power Apps is ideal for scenarios with limited customization and works well for reusing simpler applications. Power Apps is the go-to choice for empowering business users.

Incentivized

it's most definitely does as we are a unique business to use this for scholarship awarding

Incentivized

• Positive impact for my company is that we have designed a solution that meets the needs of our very custom processes.
• My company is in the process of expanding rapidly and with that the need for new tools are need quickly. With most languages (like Java or .Net), it could take weeks to develop the same tool it takes us 3 days to make in Filemaker.
• The most negative impact however is that at times Filemaker will just become overwhelmed and we have no choice but to restart the server which hosts the application.

Incentivized

• Automation of manual processes brings an ROI on labor costs.
• Intake of data provides clean database design.
• Connectivity to data-lake provides insights and trends into the data.
• Able to scale operations with efficiencies provided by the app.
• Can mature the process and workflows to do more.

Incentivized