Knack Blog

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

 

Feature Highlight: Table Grouping

05/18/2017 Posted by Odalis

Tables are an excellent way to display information in your Knack apps.  Especially since they offer many features to further organize your data for easy understanding.

For example, let's say you want to create a table that quickly shows which donors are making the most donations. So you start with a table that shows all donations:

2017-05-09_15-41-57

It's not a bad start, but it's not easy to tell who your best donors are. That's where a feature like grouping can make all the difference.

Grouping allows you to group records by a common value in selected table columns. Here’s what your table will look like when it's grouping the donations by donor:

2017-05-09_15-41-32

 

With a header row for each donor and their donations listed below them, you can see who’s in the giving spirit, at a glance.

Plus, since the “Amount” column was already totaled using a Row Summary, the grouping now shows the total per donor. Though there’s still a complete total for all donors at the bottom of the table:

2017-05-09_16-15-01

How to Add Grouping to a Table

Now that you’ve seen what grouping can do, here are the steps for adding it to your tables.

  1. In the Pages section of the builder, select the page that holds the table you want to add grouping to.
  1. Click on the table on that page to open the editor.
  1. Hover over the column you want to add grouping to and click the edit “pencil” icon to edit that column.
  1. Enable the grouping option by checking the “Grouping” box:

2017-05-09_15-43-05

Note: Any columns that are grouping records will automatically move to the front of the table. A small “group” icon will appear on that column to indicate it is grouping:

2017-05-09_15-47-30

For a quick video walkthrough of this process, see below:

Introducing User Pages

05/17/2017 Posted by Odalis

We’re happy to announce our new user pages. These pages are designed to help your users complete admin tasks, like updating their account information.

User pages will show up in their own user menu in the top-left corner of your live app:

2017-05-09_11-34-49

You can create and access user pages from their own section of the Pages tab in the builder:

2017-04-26_16-32-34

Like standard pages, you can make user pages accessible to all users or only certain user roles.

So you can have an Account Update page for Customers to update their personal details and view their recent orders. While Vendors can have an Account Update page to update their contact information and product offerings.

A full summary of user pages can be found here, and you can watch a video overview below:

Case Study: Shalley & Murray

04/18/2017 Posted by Carson

Speaking with Don Murray for a Knack case-study was a delight. Don had effusively positive things to say about Knack, even going so far as to say he felt he’d dreamed us into existence!

Don and his partner James Shalley use Knack to help them keep track of client calls and case information for their New York City criminal law firm, Shalley and Murray.

Prior to finding Knack, they were consumed by what Don called “spreadsheet madness.” Knack is such a superior solution to spreadsheets that we always love hearing about these stories.

As a New Yorker and an avid Law and Order viewer, talking to an NYC criminal attorney was in and of itself pretty exciting. And learning that Knack is often present (via phone or tablet) on their table during court was also very cool to hear.

Towards the end of our call, I asked Don whether he’d be willing to send us any images of the app itself that he could share. However, Don thought his app may be too simple to be impressive or inspiring. After hearing about how much time and business Knack had saved his firm, I quickly challenged that notion.

If anything, the simplicity of Don’s app makes it all the more noteworthy. The most complex solution isn’t always the best, and the most powerful apps sometimes don’t need to take advantage of advanced features.

What makes Knack so powerful is, in my opinion, its flexibility. It can work just as well for huge corporations as for mom-and-pop businesses; it can be equally powerful in the hands of senior developers and users who’ve never written a line of code in their lives. We may have a lot of complex features, but those definitely aren’t required for an app to be effective.

The bottom line is that it helps Don and James do what they do best. And for Shalley & Murray, their call tracker app is only the beginning. As Don himself said, “We have all kinds of plans for Knack.” We can’t wait to see what they are.

Click here to read the full case study.

Team Knack’s Commute By the Numbers

04/07/2017 Posted by Carson

Here at Team Knack we really value our remote culture. In fact, we see it as more of a lifestyle choice than a working condition. Increased time with family and pets is a huge draw, and proximity to our refrigerators doesn’t hurt, either.

For Walk to Work Day 2017, we decided to quantify another positive byproduct of working remotely: shorter commutes. Some of us work a few steps away from where we sleep, while others (Steve) are overachievers who actually drive to a coworking space.

Differences aside, one thing is clear: none of us is likely to win a Fitbit challenge anytime soon.

Take a look at the breakdown below, and if you’re looking to shorten your own commute, be sure to check out our jobs page, since we’re always on the lookout for new Knacksters!

Continue reading...

Improving the Builder Navigation

04/06/2017 Posted by Carson

We’re happy to announce some small but helpful improvements to how you navigate your way through the Knack builder. Using the builder should be as simple as possible, and we think these changes will help.

A new Knack button in the top left will now take you to your account dashboard from anywhere in the builder:

Screen Shot 2017-04-06 at 11.23.27 AM

The settings menu has been reorganized and is now found next to your app’s name:

Screen Shot 2017-04-06 at 11.24.01 AM

And the updated help menu in the top right corner has more support and help-related links, to better enable you to find the assistance you need:

Screen Shot 2017-04-06 at 11.24.58 AM

It’s also easier than ever to open a chat — just click the message button in the bottom right corner to connect with a Knack success member!

And last but not least, we updated some field icons. We switched our link field to use the old connection icon, and added a fancy new icon for connections:

connection icon

We’re dedicated to making your app building experience as smooth as possible, and will continue to make regular improvements, big and small, to that end.

A full summary of the Knack dashboard and builder can be found here, and you can watch a video overview of the new changes below:

Case Study: Historic Christ Church & Museum

03/29/2017 Posted by Carson

christchurch-logo

We see so many great business uses that it’s tempting to think Knack was specifically designed for business applications. But Knack can help anyone do amazing things with their data, even if that data is historical.

This was part of the reason why talking with Patrick Heffernan was such a rewarding experience. Knack has helped him build something special, and we haven’t seen anything quite like it.

Patrick is a historian who works with Christ Church in Middlesex County, Virginia, and he’s spent years researching the slaves who once lived and worked on the nearby Corotoman estate. Through his efforts and his use of Knack, he’s created a comprehensive database that tracks references to these men and women across documents from that time period.

As someone who grew up in Virginia and is personally interested in history, it’s particularly affecting to see this part of our country’s past laid out; lists upon lists of people for whom, as Patrick put it, Corotoman was both a home and a prison.

When Patrick recounted the story of how his app helped a local woman find her earliest known ancestor, I was floored. Knowing your ancestry is not only interesting from a historical perspective; it can also be uniquely valuable for understanding your family and where you come from.

Software and technology companies do not typically have a hand in this type of personal discovery, so knowing that Knack had helped someone learn more about her ancestry was all the more meaningful.

After over a year at Knack, I’ve come to understand how flexible our product is, and I’ve learned not to underestimate how creative people can be with it. In hearing these personal accounts, I’m continually surprised and delighted. The stories never get old.

Click here to read the full case study.

Introducing Dropdown Menus

03/02/2017 Posted by Brandon

We’re pleased to introduce a feature that has been on the request list for a while: dropdown menus.

Knack makes it easy to build large, complex apps: you can create multiple pages for different users to access in different ways.

This can lead to some crazy page menus, where dozens or even hundreds of pages all try to cram in to a single menu (and good luck trying to use them on mobile).

Dropdown menus are a great way to organize and simplify complex page menus like this. Now you can group pages into dropdown menus to simplify your overall menu:

2017-03-01_19-09-04

You can add menu pages to your page tree that can group other start pages together into a dropdown menu:

These menus also play great on mobile.

View the full documentation here in our Knowledge Base.

Knack Retreat: Miami 2017

02/16/2017 Posted by Brandon

On-site playgrounds now required for all future retreats

We returned from our third official Knack retreat a few weeks ago. It was an epic 6 days in Miami where we met 8 new team members, ate way too much food, and somehow got some great work in. Some of us are still recovering.

We’re working on a full write-up, but thought we’d share a few images here in the meantime.

Continue reading...

Developer Docs Upgrade

01/24/2017 Posted by Brandon

One of our major goals for 2017 is to make Knack even more friendly for developers and designers.

We designed Knack from the beginning to be easy to customize and control. JavaScript, CSS, and our API can be used to do some amazing things to extend the features and design of an application.

We’ve also learned a ton along the way about how developers and designers are working with Knack, including where the struggles are and what can be improved.

We’ve taken that learning to begin a major wave of improvements, starting with our new and improved developer documentation! These dev docs are now live at http://docs.knack.com.

These docs are a massive improvement over our old articles:

  • Better navigation: we’ve separated these docs from the rest of our knowledge base to build a site optimized for navigating, searching, and viewing documentation.
  • Improved organization: documentation is now organized around the major areas of focus: API, JavaScript, and CSS. Sub-navigation makes it easy to find what you need.
  • Consistent formatting: each API request is clearly defined and labeled, with supporting examples and code when applicable.
  • More code examples: we’ve grouped all code examples together and are continuing to add to our library.

This is just the start. We have big plans for continuing to improve our documentation and add additional features and functions for developers:

  • We’ll be adding more utility functions for manipulating the Knack user interface and the application data, with better documentation and examples.
  • With our pending theme upgrades our CSS styles will be greatly simplified and much easier to manipulate. Modifier classes will be available to add standard UI and layout changes.
  • We’ll be incorporating more triggers and events to respond to.

Let us know what other improvements we can make!

Are you a developer or designer interested in getting paid to help build and customize apps for Knack customers? Sign up to be a certified Knack builder. Once approved you’ll be able to view and respond to project submissions.

New Feature: Form URL Vars

01/18/2017 Posted by Brandon

We recently added a feature to help expand and re-use your forms: URL Vars.

URL vars enable you to add values directly to the URLs of your app that can be used to pre-populate insert forms.

URL vars can be used to make forms easier to use and track information from multiple sources:

  • Reduce the friction of registrations or lead forms by pre-populating the names and emails in the URLs you email out.
  • Reuse forms on your websites and apps by setting values based on the source of the links.
  • Track referrals and origins by giving different URLs to different referrers.

We’re currently using URL vars with demo forms on our own site. We use the same demo form but pre-populate the type of app the user wants to demo based on which page the user came from. So each page get’s a slightly different link with that value set in the URL vars.

You could even dynamically create URL vars in links that are sent in custom emails when your Knack forms are submitted.

Setting up URL Vars correctly is a somewhat technical process. We’ve put together this support article to walk you through it:

https://support.knack.com/hc/en-us/articles/115000997068-How-to-Use-URL-Variables-to-Pre-Populate-a-Form

Let us know if you find a great use case for URL vars. We’d love to learn how they are being used.