Airtable vs FileMaker

Overview

Airtable

Stacks1.0K

Followers890

Votes40

FileMaker

Stacks36

Followers42

Votes8

Share your Stack

Help developers discover the tools you use. Get visibility for your team's tech choices and contribute to the community's knowledge.

View Docs

CLI (Node.js)

Manual

Advice on Airtable, FileMaker

DetStartups

Nov 11, 2019

Needs advice

I'm trying to set up an ideally "no- code" way to have a backend of 3 different tables and be able to find a value in table #3 (contains businesses & cities) by first finding a record in table #1 (7,000+ zip codes) that corresponds to a city (table #2 has the unique cities), and then finding which businesses are located in these cities ( in this specific, original zipcode lookup). And return the business and a description via an API to a front-end results page, which happens to be a WordPress page - but doesn't need to be. I've tried Airtable's API, AirPress (a finicky WordPress plugin for Airtable's API), and I've looked at Sheetsu and a similar spreadsheet as backend and a simple API. I run into the issue where they work fine when you just need to query 1 table, but when you need to use the result from that query in another query to a different table. I'm back in SQL land - where sure it could be done with SQLite - needing to probably create an intersection table or a JOIN and build an API off of that. Is there a way to accomplish what I want without going back to SQL queries and some API?

59.9k views59.9k

Comments

Detailed Comparison

Airtable	FileMaker
Working with Airtable is as fast and easy as editing a spreadsheet. But only Airtable is backed by the power of a full database, giving you rich features far beyond what a spreadsheet can offer.	It is a Platform to create innovative custom apps for your workplace.
Attachments;Link Tables;Fully mobile;Instant collaboration;Easily undo mistakes	Quick Reports; Cross-platform; Quick Find; Theme Styles; Cross-Platform Access; Powerful Encryption; Field Formatting.
Statistics
Stacks 1.0K	Stacks 36
Followers 890	Followers 42
Votes 40	Votes 8
Pros & Cons
Pros 19 Powerful and easy to use 8 Robust and dynamic 6 Quick UI Layer 4 Practical built in views 3 Robust API documentation	Pros 2 Rapid development 2 REST API 1 All included 1 API 1 Easy to learn Cons 1 Expensive
Integrations
No integrations available	Android Studio iOS Android OS

What are some alternatives to Airtable, FileMaker?

Ionic

Free and open source, Ionic offers a library of mobile and desktop-optimized HTML, CSS and JS components for building highly interactive apps. Use with Angular, React, Vue, or plain JavaScript.

Flutter

Flutter is a mobile app SDK to help developers and designers build modern mobile apps for iOS and Android.

React Native

React Native enables you to build world-class application experiences on native platforms using a consistent developer experience based on JavaScript and React. The focus of React Native is on developer efficiency across all the platforms you care about - learn once, write anywhere. Facebook uses React Native in multiple production apps and will continue investing in React Native.

Xamarin

Xamarin’s Mono-based products enable .NET developers to use their existing code, libraries and tools (including Visual Studio*), as well as skills in .NET and the C# programming language, to create mobile applications for the industry’s most widely-used mobile devices, including Android-based smartphones and tablets, iPhone, iPad and iPod Touch.

NativeScript

NativeScript enables developers to build native apps for iOS, Android and Windows Universal while sharing the application code across the platforms. When building the application UI, developers use our libraries, which abstract the differences between the native platforms.

Apache Cordova

Apache Cordova is a set of device APIs that allow a mobile app developer to access native device function such as the camera or accelerometer from JavaScript. Combined with a UI framework such as jQuery Mobile or Dojo Mobile or Sencha Touch, this allows a smartphone app to be developed with just HTML, CSS, and JavaScript.

Framework7

It is a free and open source mobile HTML framework to develop hybrid mobile apps or web apps with iOS native look and feel. All you need to make it work is a simple HTML layout and attached framework's CSS and JS files.

Qt

Qt, a leading cross-platform application and UI framework. With Qt, you can develop applications once and deploy to leading desktop, embedded & mobile targets.

PhoneGap

PhoneGap is a web platform that exposes native mobile device apis and data to JavaScript. PhoneGap is a distribution of Apache Cordova. PhoneGap allows you to use standard web technologies such as HTML5, CSS3, and JavaScript for cross-platform development, avoiding each mobile platforms' native development language. Applications execute within wrappers targeted to each platform, and rely on standards-compliant API bindings to access each device's sensors, data, and network status.

Expo

It is a framework and a platform for universal React applications. It is a set of tools and services built around React Native and native platforms that help you develop, build, deploy, and quickly iterate on iOS, Android, and web apps.