Knack Blog

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

 

Connect your Knack database to hundreds of other services with Zapier

05/20/2014 Posted by Brandon

We’re pleased to announce that Knack is now integrated with Zapier – a website that makes it easy to connect different internet apps and services together to share data from service to service!

Zapier opens up powerful possibilities to extend and enhance your Knack app with other services like Gmail, WebMerge, MailChimp, Twilio, and many more.

Here are a few examples of how you can integrate Knack with other services on Zapier:

The beauty of Zapier is that since Knack is now available in their app library, you can connect Knack to ANY other service they have available. The possibilities are truly endless!

The following is our page on Zapier that describes in more detail how it works:

https://zapier.com/help/knack/

We’ll be outlining a few of our favorite services and “Zaps” in future blog posts. Keep us posted on any you’ve created so we can share them here!

Continue reading...

New Example App: Inventory Manager

04/11/2014 Posted by Brandon

We’ve released a new example app for managing inventory:

https://www.knack.com/inventory-manager/

This app really shows off Knack’s equation and formula fields, as well as a conditional field.

Here’s how it works:

  • Both incoming purchases and outgoing orders are added to the database. Formula fields are used to sum the totals of all purchases and orders for each product.
  • An equation is used to subtract orders and add purchases from a “starting inventory” to calculate the “current inventory”.
  • A conditional field compares the current inventory with a “minimum required’ number. If the current inventory dips below that minimum required, “needs reorder” is set to “Yes”.
Knack users can add this new app directly from the dashboard.

Continue reading...

The Knack Cookbook

03/26/2014 Posted by Brandon

One of the main strengths of Knack is the flexibility. Rather than force you into doing things a certain way, we like to provide different tools you can use to create the app you want.

The downside is that it may not be obvious at first just how all these different tools can best be used.

In order to help we’ve created a Knack Cookbook, which contains different recipes of using Knack functionality to implement specific features.

Each recipe will explain the scenario and then offer step-by-step guides on how to implement that feature into your online database app.

We’re starting small but hope to continually add new recipes as we go. Here are our first recipes:

Continue reading...

New Feature: Single Sign Ons

03/20/2014 Posted by Brandon

A common method for logging in is to use another service like Facebook or Google where you already have an account.

This is called Single Sign On, or SSO, and you can now add these options to your Knack logins.

This will allow your users to use these services to register and log in to your apps:

You can add these SSO links by editing a Login View and clicking on the “Options” section:

There are two options you can add:

Google: no configuration needed, the user will simply use any Google account they have.

Facebook: you’ll need to create a Facebook App and configure this option with the credentials that Facebook provides:

You set this up directly in Facebook. You’ll also need to enter the app URL where the login requests are coming from. Add this by clicking on App, Settings, and then adding a Platform for “Web”. You can then enter the URL.

Here’s an example of getting the Facebook credentials:

Once added you’ll have login links show up to the right of the login form (see above).

Notes:

  • If the user already has an account they should still be able to use the SSO options, but only if the emails are the same. If their Google or Facebook email is different then a new account will be added.
  • If you require users to fill out multiple fields to register for access, new users will be directed to the registration form after logging in with an SSO option.

Continue reading...

Knack is Growing!

03/13/2014 Posted by Brandon

Wow, what a start to 2014! We’ve seen a huge increase in activity lately and we wanted to share a little about this growth and what it means for Knack.

In the last 3 months we’ve seen a big increase in new customers, as our total customer count has more than doubled in that period!

We’re frequently getting more new customers in a day than we did for our entire first month.

We’ve also doubled our server capacity to keep up with all the new traffic. This includes re-structuring our architecture so it’s much easier to continue to add new servers whenever speeds get anything less than super snappy.

The Knack team just got bigger

Best of all, we’ve made our first hire!

Steve Palmer has joined the team and will be helping with both customer support and diving into some bigger projects.

Steve is from the same Central Pennyslvania area as Eric and has great experience with both operations and the start-up world. When he’s not knee-deep in Knack projects Steve is blogging about wine, consulting on social media, and mentoring other entrepreneurs.

We’ll be hearing more from Steve soon as he continues to get involved in all of Knack’s projects.

We’ve already told him that Knack customers are the best, so make sure you give him a friendly welcome!

Continue reading...

New Feature: Conditional Fields

03/04/2014 Posted by Brandon

We’re pleased to announce a major new feature: conditional fields.

You can now add rules to any field that can be used to set the value of that field. Rules can be based on other values from the same record.

Here are some examples of how conditional fields could be used:

  • the value of a Student Rank field is set to “Honor Roll” if the GPA is higher than 3.
  • the value of a Commission Rate field is set to 5% if the Years Experience is higher than 2.
  • the value of a Invoice Status field is set to “Overdue” if the Days Overdue is higher than 0.

To add conditional values to a field, first click on a field in your database to open it in edit mode. A new “gear” icon will display in the top right corner:

Click on that to open up a pop-up for “Advanced Options” where conditional values can be added:

Those rules set a commission rate to custom values based on the years of experience value. A default value is set with the 3 rule (with no criteria).

Once added a “conditional” icon is displayed with the field for easy identification:

Once a field is set to use conditional values it can no longer be added to a form or edited in inline mode. The values will only be set by the rules.

The rules run in order with the first match found. You can add a rule at the end with zero conditions that will set a “default” value in case any of the previous rules aren’t matched.

Continue reading...

New Feature: Add Connected Records from a Form

01/29/2014 Posted by Brandon

We’ve added a new feature to add connected records right from a form.

An example helps describe when this is useful. Let’s say you have Students and Schools and add new Student records with a form. If you need to connect that Student to a School record that doesn’t exist yet, you’d have to leave that form and add the School record first.

You can now add connected records like this directly from the form!

To do so, first click on the form in your Interface to edit it. Then click the edit icon on connection field (in this case, School):

Set the option to “Allow users to add new options”.

When you save the form, this will create a new child form for adding that new school:

This child form can be edited and works exactly like a regular form. You can even add form rules.

This will then add a “Plus” icon next to the field where users can add their own connected records:

This will trigger the child form to display in a popup:

That new School record is automatically connected in the form and added to the list of available Schools to connect to.

Continue reading...

New Field: Signature Captures

01/21/2014 Posted by Brandon

We have added a brand new field: signature captures!

Now your app can capture your user’s signatures with a new Signature field. Signatures should be perfect for user authorization, getting permissions, or signing off on terms of use.

This field is available under the Special tab when adding a new field.

When added to a form, the signature field accepts mouse or touch input to capture a signature:

Two links below the signature make working with the signature easier:

  • reset: clears the entire signature
  • undo: undos the last stroke
When added to other views the signature will display like an image:

Please note that Knack is not claiming that these signature fields convey any legally binding authorization.

Let us know what you think or if you run into any issues with this new signature field.

Continue reading...

New Feature: Translations

01/07/2014 Posted by Brandon

Ever since we’ve launched one of our biggest surprises has been the percentage of users that have come from outside the US. It’s been way higher than what we expected!

It’s been a blast to interact with customers all over the world and look down the list of countries where Knack apps are being used.

Of course, this also means a lot of requests for translations.

Even though you can use your own language for all the field and scene names, there are still plenty of words and phrases built in to the app that are stuck in English.

We’ve slowly been working on a translation system and today we’re launching an official setting that you can change per app. You can access this in your application settings:

We’re starting with a small list of languages that a few of our awesome Knack customers have helped us with:

  • Danish
  • German
  • Portuguese
  • Spanish

Update (April 2013): we’ve since added French, Italian, and Swedish!

These translations are definitely a work in progress. If you spot any English phrases that haven’t been translated, or see any translation that you think should be improved please get in touch.

Other Translations

We’re working on other languages but we don’t have any set ETA.

If you want to help expedite your language translations, we’ve created a form that can be created to help provide translations:

http://knackhq.knack.com/translations

Continue reading...

Happy New Year!!

01/02/2014 Posted by Brandon

Wow, what a year!

2013 saw Knack grow from a tiny launch to a fully matured product powering thousands of apps.

We added some major features last year, from new views like maps and calendars, new fields like equations, and advanced features like our API, scheduled tasks, and SEO indexing.

We have big plans for 2014 as well, like single sign-ons, translations, E-Commerce and more.

But most of all, we want to continue to serve you — our Knack customers.

It’s been such an honor to help so many of you build great apps that help you run your businesses and organizations.

We’re looking forward to doing more of the same for 2014!

-Brandon & Eric & the Knack team

Continue reading...