Knack Blog

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

 

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

New Feature – Map Details

12/11/2013 Posted by Brandon

We’ve added the ability to add Google maps to your detail views.

Note: this feature is available to our Pro customers and above who have geo-coding enabled.

Just edit any address field in your view and you’ll have options for showing the map and configuring the map size:

This will then show a Google map and link the address to the directions feature in the map:

If you are currently a Pro subscriber or above and want to add map details, please get in touch to request geo-location for your addresses.

Next up: a searchable map list!

Continue reading...

New Feature: Add Custom Multiple Choice Options

11/26/2013 Posted by Brandon

We’ve added a nice feature for multiple choice fields so users can add their own custom option on the fly.

You can set this option for any multiple choice field in your forms. Just click on the field to edit and check the option to “Allow users to add new options”:

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

These options will be added to the field’s format, so they will be listed as an available option for any future forms.

Continue reading...

Custom Designs with Knack

11/22/2013 Posted by Brandon

One of the major features we like to show off with Knack is the flexibility you have to use CSS and jQuery to completely customize the design of your online database app.

Developers can use jQuery to respond to application events, like when a scene loads or when a form is submitted. Designers can use CSS to update colors, fonts, icons, and virtually every aspect of the app’s design.

We’ve seen some great use cases of Knack customers modifying their online databases –from minor design tweaks to complete overhauls– and we wanted to show a few examples:

South Padre Island

The official government site of South Padre Island needed a custom calendar solution that would allow them to receive event submissions from multiple sources, and display those events in a variety of different ways, all in a format that could easily be customized for multiple websites.

Here’s how their calendar looks on their main site, with custom icons, button styles, and colors, all easily added with CSS:

Visit: http://www.myspi.org/calendar/

TriStar Plastics

TriStar Plastics uses Knack for a searchable online database for their thousands of engineering materials they work with. These materials needed very precise search options that could be combined and navigated easily.

CSS and jQuery was used to create and position dynamic filters for searching and tabs for more easily viewing the results:

Continue reading...