Knack Blog

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

 

Zapier Email Parser

06/01/2014 Posted by Brandon

We recently announced integration with Zapier.com which allows you to connect your Knack app with hundreds of other services. We’ll be highlighting a few key services and how you can use them with your Knack online database.

One of the more powerful services available is the Zapier Email Parser.

So what’s an email parser? Good question – it allows you to identify fields and content from an email and map them to match fields in your Knack app.

In other words, you can convert any email into a new record in Knack.

Why is this useful?

Email parsing opens up a variety of great options to extend your Knack apps:

  • Add records from contact and lead forms by parsing the form submission emails.
  • Track expenses by parsing invoice and receipt emails.
  • Allow users to submit records to your database by sending an email. Great for simple records like tips, comments, suggestions, or even calendar events.
  • Add records with emails from your phone when you’re on the road or have limited internet access. Great for tracking receipts, mileage, or expenses.
  • Parse social media emails to record testimonials, comments, or quotes.

Let’s take a closer look

If you are like me you often receive random emails that should be captured as a warm lead. The email parser makes it easy to pull the information you value from the email and create a structured record in Knack.

With the email parser you can extract data like the contact name, date, company they work for, email address, phone number and even some body content within the email.

To send this data to your Knack CRM app, you simply forward the email, unchanged, to your parser email address. Zapier matches the parsed fields and inserts a new contact record into your app.

How do you setup the email parser?

Start by creating a new “Zap” in zapier using Zapier Email Parser as the Trigger and Knack as the Action. Once you choose your trigger and action, you will need to setup the parser. Zapier prompts you by directing you to a link:

zapier-parser-trigger

This actually creates an email address you can use to auto-forward email or set as the address for your website form submissions.

You then highlight sections of the sample email you send to zapier and assign those sections to the fields of your choice. Here is a test email I used from our account signup form:

zapier-parser-fields

Where you see firstname, an actual name existed just prior to highlighting. Then it parsed this into a field name that you can now match to your fields in your Knack app.

You can see more “Zaps” like these here.

Continue reading...

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...

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...

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...

New Feature: Searchable Maps

12/19/2013 Posted by Brandon

We’re pleased to present a brand new view for the Knack interface: searchable maps!

This view is currently available for Knack users on the Pro plan or above, and is limited to North American addresses (international coming soon).

The map view works with Google Maps and is a great solution for store locators, dealer locators, contact searches, and more.

Map views can now be added for any object containing and address field, and include the following features:

  • Search by zip-code or city
  • Automatic directions link
  • Custom pin colors
  • Distance calculations
  • Optional starting point
  • Custom sizing for map and record list
Please let us know if you implement the map view or build your own searchable map locator or directory — we’d love to see it in action.

The Map view is in beta. As always, please get in touch with any suggestions or issues.

Demo

You can see an example online store locator listing all Dunkin Donuts locations:

https://www.knack.com/store-locator-online-database/

Drive-through locations are color-coded green.

Continue reading...

Knack and User Logins

12/17/2013 Posted by Brandon

One of Knack’s most popular features is user logins. You can require your users to log in in order to access your app. Different user roles can be created to define permissions and security.

The best part is you can connect views to the logged-in user, so each user can only see the records they are connected with.

The following are good examples of apps where logged-in users work with connected records:

Job Portal App

Today we added a new example app that further highlights user logins and working with connected records: a Job Portal app.

This app works with two main user roles: employers and applicants. Each role can log in and manage their own records.

The employers can manage jobs they have available. The applicants can manage their employee profile and apply for available jobs. Each record added by a user is available for the other users to view.

We think think this is a great example of Knack user features. It works with multiple user roles and the entire database is populated directly by the users.

This app structure can be used for any scenario where you want two groups of users to interact with each other, like realtors and house-hunters, artist and collectors, or students and internships.

New User Tutorial

To make it easier to work with these features we’ve added a new tutorial:

Showing Records Connected to the Logged-in User

This tutorial exhaustively covers the different scenarios where you can connect your views to a logged-in user:Add views for the user to manage their own recordAdd views for records connected to the logged-in userAssign the logged-in user to a form submission

Add rules to filter records by the logged-in user

Continue reading...