Knack Blog

The Knack team on web applications, online databases, and beautifully designed products.


Building online quizzes with Knack

02/27/2015 Posted by Brandon

With our recent form upgrades it’s now possible to create multi-step processes using forms and other views.

With each form you can redirect to a child page that works with the same record. You can continue to create a path to work with the same record using as many forms or other views as you need.

This is perfect for quiz apps where you can ask a single question on one form and then redirect to a child page to show whether the answer was correct or not.

A menu can then link to question 2. You can cycle like this through all of your questions until you eventually hit a “results” page to show a final score.

We built an example quiz to show you how it can work.

We also added a walk-through with some animated GIFs of how we built it:

Knack now makes it easy to build simple quizzes like this. Throw in all the extra features Knack provides and you can start to build some very complex multi-step processes.

Continue reading...

Major Upgrade: Form Rules

02/23/2015 Posted by Brandon

Form rules are hands-down one of our most powerful and flexible features: you can define rules to trigger actions like custom emails and record updates when a form is submitted.

Form rules can really expand your app to include work flow features and sophisticated data management.

We recently decided to do a form overhaul to better organize rules and include new features that have been popular requests with our users.

This upgrade is now live! Here’s what’s included:

New Organization

We’ve organized the rules into some new groupings that make more sense:

  • Display Rules: identical to the old “Field Rules”. These rules control how the form is displayed: you can show and hide form inputs and change input labels based on other form and record values.
  • Record Rules: rules that add or update records in your database. For example, you can insert a connected record, or update the form’s record. These were in the old “Submit Rules”.
  • Submit Rules: new! These cover the old form “Options” for what to do when the form is submitted, like show a confirmation message or redirect to another page.
  • Emails: rules for sending custom emails or email alerts. This combines the general alert options and the email options from the old “Submit Rules”.

Submit Rules

Major upgrade! Submit rules include 3 major new features:

Redirect to the parent page

After the form is submitted the user will be redirected to a parent page. Perfect if you’re adding a child record and want to quickly go back to a parent list showing all those record.

Redirect to a new child page

You can now create a new child page to direct the user to. You can add any views you wish to this page and it will automatically work with the form’s record. This means you insert a new record and immediately show other views for that record.


You can create different Submit Rules and define criteria for using each rule.

We’ve also tweaked the confirmation message with rich text and the ability to hide the reload link or automatically reload the form.

These features add quite a few new form possibilities:

  • Multiple Paths: create different paths based on different answers. One choice can lead to one page while another leads to a second page.
  • Multi-page Forms: break up a long form into multiple pages.
  • Confirmation Pages: create child pages to show details and connected views.
  • Quizzes: Show multiple questions on different pages and end with a “results” page.


We’ve also added new features for form emails:

You can add multiple emails rules and choose between sending a simple notification or a custom template

Dynamic Recipients

You can add multiple recipients to a custom email and choose the type, including Reply-to:

Template VariablesWe’ve included 3 variables you can add to your templates:

  • Page URL – include the URL for the current page.
  • Parent Page URL – inlude the URL for the parent page, if a parent page exists.
  • Record ID – the ID of the record
These variables are listed in italics below the list of fields.

Note: please review your current form rules and email tasks to ensure everything was migrated correctly, and get in touch if there appears to be any issues.

Continue reading...

Recent Updates

02/10/2015 Posted by Brandon

We’ve been so busy lately with our server upgrades we’ve let a few recent updates go by unannounced.

This, of course, is unacceptable — announcing updates is exactly what this blog is for! We’re making this right and listing them here all at once.


Maps now have the option of working with kilometers:

You can also set a map’s starting point to be the user’s current location:

This uses the user’s browser or phone’s GPS features to get the closest point to search by.

Note – the user will have to approve revealing their location.


You can now configure your search view to show search results by default:

This means results will dispay before the users submits any search criteria. The results will follow the Data Source to determine which records to show (similar to a table or list).

User Email Templates

You can now customize the emails that are sent to users when they are approved or emailed their account info.

These links are available in the right column when viewing user records in your database:

Click on a link to edit the Approval template or Account Info template. Each user role can have their own custom templates:


Number Formats

You can now customize how you want to separate decimals and thousands in your number fields:


Email Subject Fields

You can now include dynamic fields in the subjects of custom emails that are sent when forms are submitted. Click the “field” button by the subject line to access:


Billing Receipts

You can customize the billing information that displays on your receipts. This is helpful if you need to include VAT numbers are other specific identifiers. Click on the account settings in your dashboard to customize:

Continue reading...

Super Speeds and Better Job Processing

01/31/2015 Posted by Brandon

In the past year we’ve more than tripled the number of Knack customers! This is obviously fantastic but there was a downside: our infrastructure was starting to feel the strain of this increased traffic and activity.

The past few months we’ve focused on improving this infrastructure and some of the job processing that requires intensive resources.

We launched these upgrades last week and we’ve been thrilled with the results! We’re seeing increased speeds across the board and improved job processing.

We’ve detailed these updates below.


We’ve completely upgraded every aspect of our cloud-based infrastructure:

  • Speed – we’ve beefed up our servers, streamlined code, and optimized our databases to speed up how quickly your apps and records load.
  • Capacity – we’ve doubled our capacity by utilizing multiple cores on each cloud server. We’ve re-wired our job processing so we can now add unlimited capacity with a click of a button.
  • Compression – we’re now compressing all data delivery through our API before delivering it. For some pages and views this means up to an 80% smaller data payload.

Job Processing

An online database needs to be able to run big jobs to insert, update, or delete many records at once. In the past we’ve handled these without communicating much about how the job was going or how fast it was processing.

Along with increased speeds from the infrastructure improvements above, we’ve added some nice features for processing imports, batch updates, and batch deletes:

  • Real-time Progress: you can now see how fast your job is processing and how much is left to run.
  • Cancel Jobs: you can cancel your job at anytime. Any records processed before the cancel will be saved.
  • Delay Alerts: if our job queue is too busy we’ll let you know if there’s a delay.

What’s next?

Although most of these improvements are behind the scenes these changes set us up to grow well into the future.

It also allows us to get back to focusing on on adding great features and improvements.

Continue reading...

Case Study: DNAeX

01/14/2015 Posted by Brandon

Running a desert marathon!

In 2016 Scott Longden plans to run in the Marathon Des Sables, a 250km self supported run across the Sahara Desert where you carry everything you need on your back in temperatures approaching 50C/122F.

Not my idea of fun.

For Scott a jog across the Sahara seems like the logical next step — he’s participated in numerous triathlons and marathons and is ready for the next challenge.

At that level you can’t simply trust your training or body to know if you are “competition-ready”. What is on the surface may not reveal the potential, or lack of potential, for competitive success.

Science has come along way in helping athletes like Scott. DNA science can now measure athlete-to-sport compatibility and tailor programs for specific genetic make-ups.

So how does this relate to Knack?

Continue reading...

Featured Industry: Beer, Wine, & Beverages

01/09/2015 Posted by Brandon

Here at Knack we have the unique opportunity to see all of the web apps and online databases that are built for specific industries.

A great example is the beverage industry, where we”ve seen a particularly strong fit amongst the craft beer and wine sectors.

This attention may or may not be heightened by the near and dear place wine and craft beer holds in our hearts 🙂 Eric makes his own wine, Steve ran a wine blog, and craft beer is always on Brandon”s Christmas list.

Why Knack?

Many of the breweries and wineries we”ve worked with are big enough to have significant I.T. needs, but don”t have the technology budgets to pay for bloated software or full-time technology staff.

Many of these individuals not only manage “the books” but they wear several hats like purchasing agent, production supervisor or even brewmaster.

This is why Knack is so appealing: it”s quick, easy to use, and perhaps most crucially can immediately provide major benefits. Customized apps can quickly be built to help manage sales, inventory, and distribution without a huge investment in time or money.

Ninkasi Beer Industry Database

This combination of simplicity and customization were exactly what appealed to Jessica Jones of Ninkasi Brewery:

“We needed a platform for group project management and collaboration. Other options were either not customizable enough or too complex to teach all of our staff at varying levels to use.”

Trey Bowden of Dogfish Head Brewery was pleased with the ease of use when creating a production management database:

“When I was recently tasked to build an internal database-driven app for “beer product holds & dispositions”, I knew Knack was the right tool to get the job done in a timely manner…You can”t beat the simple user interface, built-in reporting, and cloud-connected capabilities with it”s Zapier interface (as opposed to using something like MS Access).

“We just launched our first app in early 2015 and our production team couldn”t be happier!”

Here”s a look at some of the apps we”re seeing for beer and wine users:

Continue reading...

New Feature: Shared Builders

12/17/2014 Posted by Brandon

We recently released a new feature where you can share your apps with other builders.

This means that you can now collaborate on creating and managing your apps with other builders.

These shared builders won’t be able to delete your app or add new apps, and won’t have access to your account details like billing. They will be able to fully edit the app you share with them, including adding, editing, and deleting elements from both the database and interface.

You can share your apps by clicking on the “settings” icon for any app in your dashboard:

You then enter the email of the builder you want to share that app with and they’ll be emailed a link notifying them of this shared access. If they don’t already have a Knack account they’ll have one created for them automatically.

You can view any apps that have been shared with you in the Shared Apps link in your dashboard.

Shared builders are available on our new plans which you can view here:

Continue reading...

Case Study: Svelte Brands

12/11/2014 Posted by Brandon

Max Hauer is the founder of Svelte Brands – an operator of multiple E-commerce brands focused on fashion and beauty.

The trick for any modern E-Commerce company is managing product data, and lot’s of it.

It’s not as simple as maintaining a spreadsheet of your products — each product can be sold through various channels that may require a different set of data for the same product, including unique item numbers and SKUs.

Max was struggling to find the right platform to manage Svelte’s product data:

“We faced an existential challenge. How can we store, manage and update large numbers of products? How can we manage workflows of creating, copywriting, building product data for each product?”

Max turned to Knack to create a custom solution that simplified the entire process.

Continue reading...

New Example App: Donations Manager

12/08/2014 Posted by Brandon

When we launched our AppsGiving campaign we decided to include a new example app specifically for non-profits: a donations manager.

Knack has a heart for non-profits so a targeted example app was long overdue!

We hear from many of our non-profit customers that they struggle to find simple solutions that are focused and easy-to-use amidst the glut of software options out there.

Knack is such a great choice because it meets those exact needs. You can focus the features on exactly what you need your software to accomplish.

We designed the donations manager to be a great foundation for simple and focused donor management.

It comes included with these features:

  • Track donations by assigning each donation to the donor and campaign.
  • Calculates total donations, average donation, as well as minimum and maximum donations for each donor and campaign.
  • Easily search and filter to find your donors and donation data.
  • Run reports to view percentage of donations by campaign, donations per month, and much more.

As with every Knack example app you can install the donor manager straight from your dashboard and customize it to fit your exact needs.

Get in touch if you need any assistance building a fantastic donor management app for your non-profit!

Continue reading...

Dynamic PDFs and Documents with WebMerge

12/02/2014 Posted by Brandon

When it comes to using your Knack database to generate formatted PDF, Word, and other documents, WebMerge is a great tool that we often recommend.

Although Knack lets you print any page in your interface to a PDF, sometimes you need more custom formatting or other document types.

WebMerge makes it easy to set up your documents and then use Zapier or our API to populate those documents with records from your Knack database.

The following is a guest post by Webmerge’s very own Jeremy Clarke on how to to do some custom integration with Knack and Webmerge.

Continue reading...