Knack

Knack Updates

Knack update · May 25, 2018

New for Our Knack Integration: Find and Update Records

Zapier automations are one of the easiest ways to add new data to your Knack database. Now, with the new Knack Find Record and Update Record actions, you can have Zapier pull up info or update it inside your workflows. Whenever something new comes in, Zapier could search Knack for...read more
Knack mention · May 4, 2015

Building an App the Simple Way: 6 Database-Powered App Builders

Whether you need to manage customer data, organize inventory information, or keep track of your business contacts, there's likely an app for that. Or 30. The only problem is, no app is a perfect match to the way you work. In your business, you have specific customer characteristics to...read more
Knack update · May 22, 2014

Connect Database Builder Knack to Hundreds of Apps with Zapier

Knack, a simple online database and web app builder, is now on Zapier, allowing you to easily send data between it and over 300 other apps. With Knack and Zapier, you’re able to automate the insertion of a new record into Knack when you add a row to a...read more
Matthew Guay
Written by Matthew Guay · Last updated March 30, 2015
Our Rating:

Everyone needs something a bit different from their apps. You need to keep track of the things that are important to your team—but customizing existing apps by adding new fields can be difficult, and building your own hand-made app would take a prohibitive amount of time.

Start out with an easy-to-use database and form interface designer, and you might be able to make the app you've always wanted without having to dig into code. That's exactly what Knack offers. It's an online database-powered app building tool that lets you make a database and the interface around it that you need to keep track of your team's data.

You'll start out with a video tour that walks you through building a sample app to manage orders from your customers, explaining database terms like object and Knack terms like views while showing them in context in an app. Then, login to your new account, and you'll get another video tour that walks you through the interface. It might seem like a bit much, but if you've never managed a database by hand before, they're a great introduction to how a database in Knack works and what you can do with it.

Because, for all of its simplifications, Knack is still essentially a database with some simplifications to help you use it easier. The first thing you'll need to do in your new app is to define objects—equivalent to a sheet in a spreadsheet—complete with fields—columns in your spreadsheet—for everything you want to store. You'll want to think through the items you need to track in your app, how they relate to each other, and what format they'll be in, and make fields for each of them.

You can add your own individually, or select the Quick add column to import object templates. There's company, employee, contact, product, and order templates, each with appropriate fields (say, company name, logo, website, industry, address and more for the Companies option) pre-added. Or, you can import a spreadsheet that already has data you've been collecting, and Knack with create appropriate objects and fields and import the data accordingly.

Then, it's time to make your app's interface. Switch over to the Interface tab, and you can add new pages with forms to add new entries to your database objects, tables to display the data in your objects, reports that list your data in unique ways, and more. That sounds tedious, but Knack does a lot of the heavy lifting for you to speed things up. Add a form to add new entries to your app, for instance, and Knack will automatically add fields for each of the elements you'd put in your database object previously, each formatted for the type of data you need. There will be a short box for a name, perhaps, a longer one for a description, and an upload button for a photo.

Viewing your data is similarly simple. You'll pick from popular views—a spreadsheet-like table, a search tool, a gallery that emphasizes pictures, and a map that lays out your data on a map—to show your data, or different graphs and charts to make sense of it, and Knack will try to automatically pull the object entries you have into that view design so you can see your data without too much interface tweaking.

Once you've got the system to collect and show the data you want, it's time to put it to work. You can use your Knack app on your own, of course, but if you've built it for your business you likely want others to use it as well. All you'll need to do is add them as users, and set their permissions so they can do anything from tweak the app further, add data, or just be able to view existing data depending on the permissions you give them. You can make a password protected page for your Knack app, or could even make your app's data—or some of it—public and embed it in your website. That way, you can use Knack as an advanced way to make forms and then showcase the data from them in your site.

You're not going to build the next Instagram in Knack, but then you weren't planning on that. What you may use it for is making quick apps for the internal business needs you have, rather than just keeping track of everything in yet another spreadsheet. Knack will make it faster to find the data you need, give you easier ways to visualize and put it to use, and you'll have a system that only asks for the things you want to keep track of. It's a database, form builder, and data viewer, simplified.

Have any feedback on this overview, or something we should change? Let us know!

Use our free platform to build a single Zapier integration and instantly connect your app with 1,400+ others.

Become a Zapier Integration Partner

Knack is the easy way to build online databases and applications.