Knack Blog

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

 

Icons

07/14/2015 Posted by Brandon

You can now add icons to the menus in your apps!

Here’s an example of a menu with icons added:

Edit a link in a menu view to add an icon:

To add an icon to your app’s global page menu first click on a page from the list in your interface, then click on the “Page Options” link in the right column.

There’s a ton of icons to choose from! Not only are icons fun, they can help guide and educate the user experience.

Continue reading...

Task Upgrades

07/02/2015 Posted by Brandon

Scheduled tasks are one of the most popular features on our Pro plan.

Tasks let you define actions to send emails, update records, or even insert new records based on dates and criteria you define.

We’ve recently posted some improvements to scheduled tasks, including some new features.

Tasks are now managed with a tabbed pop-up window:

New features include:

  • Next run date – this will always list the next date the task will run and can be changed at any time.
  • Pause – temporarily pause the task so it won’t run. The task won’t be deleted and will maintain it’s schedule and can still be manually run.
  • Manual Run – run the task in real-time on demand.

We’re also now logging each time a task is run, along with the results and how many records the task processed. This way you can confirm the task ran and is processing the records you are expecting. You can view a history of these logs in the History tab.

As always please let us know what other task features you’d like to see!

Continue reading...

Case Study: Kinetic Events

06/30/2015 Posted by Brandon


The Kinetics Event Staff

Erik Lillquist gave up on finding a canned solution and instead, built a custom application with Knack.

Erik Lillquist runs Kinetic Events, an events management company that specializes in staffing and marketing high profile corporate and entertainment events.

Running events is a big juggling act – it means managing multiple streams of information. Everyone from managers to employees to freelancers needs different access to different info at different times from locations all over the country.

Erik had specific requirements he needed to manage this process:

  • An application accessible from any location on several different types of devices.
  • A portal style database for both managers and employees to access personal information.
  • Calendar features for managing events.
  • Job Board for managing job listings.
  • Secure login for all users

His initial thought was to find a software product specifically for event management. He quickly discovered that most of the products he explored either couldn’t cover these requirements or were super complex products that were too expensive, difficult to use, and couldn’t be easily customized.

Erik realized that an out-of-the-box solution just wasn’t going to work. What he needed was a database solution he could customize to meet his exact needs.

Continue reading...

New Feature: Advanced SSO

06/23/2015 Posted by Brandon

We’ve released new features for advanced Single Sign-Ons, or SSO.

Our basic SSO options have been a big success – these allow users to log into Knack apps using other common accounts they already have with Google, Twitter, and Facebook:

We’ve added additional advanced SSO options so you can create additional login options.

Here’s how it works: there are two common login technologies (oAuth and SAML) used for authenticating logins. You can add any custom login that uses one of these two.

For example, you could add logins using SalesForce or LinkedIn with oAuth. SAML enables more enterprise configurations like Shibboleth and Active Directory.

Adding a custom login

To add a custom login you can use the “add a custom SSO provider” link in the Login view’s “Options” tab:

You’ll be guided through configuring the login with the right options. There’s a lot of options to configure so you may need a developer to help get them all correct.

You can also customize the login button with a color and logo. Here’s a customized LinkedIn login button:

Domain Limiting

In addition to adding new login options, both the Google and OpenID SSO providers have an option to enforce domain restrictions. This means that you can provide a domain to restrict authorization to. Only accounts with emails from that domain will be authorized.

For example, by entering “knack.com” with a Google SSO, only Google accounts with an email address using knack.com will be authorized.

Learning more

You can find the full details in our support article on logins:

http://helpdesk.knackhq.com/support/solutions/articles/5000443954-logins-registrations#sso-advanced

We also added a recipe to our cookbook for adding a LinkedIn login:

http://helpdesk.knackhq.com/support/solutions/articles/5000637997-use-a-3rd-party-login-like-linkedin-or-salesforce

Pricing Note: these advanced features are available on Corporate plans and above, or with an add-on to the Pro plan.

Continue reading...

New Template App: Attendance Tracker

06/15/2015 Posted by Brandon

One of the most common app questions we get is if Knack can handle different attendance apps:

  • Schools taking class attendance.
  • Churches managing small group attendance.
  • Corporations taking attendance and roll-calls for trainings and meetings.
Attendance apps sound simple but can quickly get complicated. How are you reporting attendance? Who’s in charge of taking attendance? Are you recording any additional information? Maybe you want to track each member that attended and if they brought any visitors.

Knack shines in building custom attendance applications like this where you need to tailor your attendance around specific needs.

We recently built a new template app to show a few examples of how attendance can work.

Continue reading...

API Upgrades: Working with logged-in users

06/02/2015 Posted by Brandon

We’ve added some new features to our API so that you can now make login requests and work with the logged-in user!

Highlights include:

  • Secure user tokens to authenticate request for Knack users.
  • Utility functions for getting properties of the logged-in user and checking for role permissions.
  • Remote login requests.
This opens up a lot of great possibilities for developers to work with Knack apps:

  • Mobile developers can have mobile users log-in with their Knack credentials.
  • Make page requests with views that are connected to the logged-in user.
  • Permission customization with user roles.
We’ve include an article in our API documentation that goes into more details:

Continue reading...

Case Study: More baskets for your database eggs

05/28/2015 Posted by Brandon

Joshua Guy Lenes replaced a custom-programmed database with a Knack solution so more team members could help build and maintain it.

Joshua Guy Lenes is familiar with complex, custom database solutions. He works with the American Association of University Professors to manage union memberships. They used to employ a custom-engineered database coded in python, django and sql.

It was a suitable system but there was one big problem: Josh, a trained and capable developer, was the only person who knew how to manage the database and keep it running smoothly. It was too complex to easily bring on others to help.

He knew this would not be sustainable in the long run — if Josh somehow became unavailable how would the system be maintained?

Josh needed a more flexible database solution that his team could easily use and manage without his assistance, and the search began for a replacement.

Continue reading...

Recent Upgrades

05/20/2015 Posted by Brandon

Even though everyone loves big new features, most of our favorite upgrades are often to existing features — little tweaks that improve performance or add functionality.

We recently completed a round of smaller upgrades and wanted to post about them.

Submit the current location of the user

You can now add a Form record rule to set the value of an address field to the user’s current location:

Note: this option is only available on Pro plans and above.

Separate time defaults

For Date/Time fields you can set separate default values for the time component:

Default menu tabs

Format menus to work like tabs and start with the first menu link selected:

Empty tables

Format a table to hide any columns where every column value is empty or blank:

Continue reading...

Yes/No Feature Upgrades

05/11/2015 Posted by Brandon

We’ved added some new input options for a Yes/No field:

You can now choose from the following inputs to display the field in forms:

  • Dropdown
  • Radio Buttons
  • Checkbox

The checkbox display has an additional option for text to display by the checkbox:

This is a great option for adding “agreement” inputs where you want the user to check the box before proceeding. You can use a special text field (from the “special” tab) above the checkbox, and set the Yes/No field to required:

Continue reading...

Case Study: Medical Healthcare Network Solutions

04/24/2015 Posted by Brandon

When MHCNS first looked at Knack they simply wanted an internal data management solution. What they found was a comprehensive application platform that is expanding their revenue and growing their business.


MHCNS enjoying their success!

Early in the summer of 2014 Josh Cameron was researching online database systems for his employer Medical Healthcare Network Solutions, a Houston-based provider of tech services for medical-based businesses and private practices.

He needed an internal data management solution — something that could cut through all the spreadsheet confusion and bring clarity to their projects and clients.

A Forbes.com article about online database tools led Josh to give Knack a try.

He quickly got a sense for Knack’s potential and built a comprehensive company portal including project management, a knowledge base, and equipment tracking.

“We had hundreds of excel sheets that were wasting so much time”, Josh explained. “Our clients were constantly contacting us with the same issue. Knack has allowed us to reinvent ourselves as a company. We have less paper, spreadsheets, and confusion. This has allowed us to have more clients, revenue, and efficiency across the board.”

This would be a great Knack success story if it stopped there. But it gets better!

A little more than 6 months later, MHCNS started hiring staff to round out an entire department devoted to building web applications on the Knack platform.

How did Knack go from meeting an immediate data management need into helping develop an entirely new profit center?

Continue reading...