Knack Blog

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

 

New Feature: Table Summaries

06/11/2013 Posted by Brandon

This feature has been in beta for a while but we never announced it.

You can now add summaries to a table to run formulas like sum and averages on all the rows in the column:

To add a summary simply edit any table and click on the Options section. You’ll see options to add summaries at the bottom:

Any label you add will be placed in a left column if available. You can add multiple summaries to a table.

Continue reading...

New Feature: User-based Global Tabs

06/06/2013 Posted by Brandon

We added an additional option to our Global Tab Menu. You can now set it so that the tabs will show based on User Roles:

This means that when a user logs in they will only see tabs for scenes that share a user role they are assigned to. They will also see tabs for any scenes that are not protected with a login.

This should allow for more flexible apps where you can design for the user without worrying about hiding or showing the right scenes.

This feature is currently in beta, so please let us know if you run into any issues.

Continue reading...

May Online Database Examples

05/29/2013 Posted by Brandon

April and May have been record-breaking months with new customer sign-ups! We want to welcome aboard all our new Knack customers. Here are some examples of the apps and online databases they’ve been building.

  • Patient Database: a biotech company uses Knack to track treatments and results for patients.
  • Project Dashboard: a software developer uses Knack to track project budgets and predict cash balances.
  • Legislation Database: an educational institute is using Knack to enable legislative data to be easily searched and categorized.
  • Enterprise Resource Planning: a jewelery E-commerce company uses Knack to manage all customer shipments and manufacturer orders.
  • Alumni Database: a sorority uses Knack to manage alumni information and chapter officers.
As always we’re thrilled to see the huge variety of amazing apps that Knack customers are building every day.

Continue reading...

Support Videos

05/28/2013 Posted by Brandon

Now that we’ve completed our new web design, we’re going to be spending more time on support videos.

For each of our example apps we’ll be adding a video on how we built it. We’ll also be completing our video tour of building an app from start to finish.

First up, a new video for our video tour on connections:

Continue reading...

Customer Success Stories

05/23/2013 Posted by Brandon

In case you haven’t noticed we launched our new web design last week!

One of our main goals with the new design was to integrate more of our passionate Knack customers. We included some testimonials on our homepage. We also have plans for featured case-studies coming soon.

We’re most excited about our customer success stories. These are short question and answers from Knack customers about what drew them to Knack and how they’re using Knack to build online databases and web apps that solve real problems.

Because Knack can be used for so many different use cases we really like showcasing actual apps our customers are building. We’ll have lots more coming soon.

We want to include you!

To be in an upcoming success story or case study please fill out our customer success form here.

We also want to showcase more tweets, so follow us on twitter and mention @knackhq in a tweet so we can include it on the site.

Continue reading...

New Feature: Scene Printing

05/10/2013 Posted by Brandon

You can now print any of your Knack scenes!

You can add a “print” link to the top of your scene that will automatically send the scene to your browser’s print preview.

We remove everything except the views so the printed version is nice and clean. We also remove links and submit buttons where it makes sense.

To activate the print link, edit a scene in your interface and click on “Scene Options” in the right column.

PDFs are next. We’re still looking for decent options for that.

Continue reading...

Featured Knack Apps: April

04/29/2013 Posted by Brandon

This is the latest entry in a series describing different online databases and web apps being built by Knack users:

  • Plant Database: a forestry network uses Knack for an online database of plants and ecological data in their network.
  • Homeless Information System: A non-profit used Knack for an online system to manage data about local homeless populations
  • Feature Request Management: a software developer uses Knack to solicit and manage feature requests for their software. Developers can convert suggstions into active development.
  • Bike Fitting: a bike shop used Knack to create a bike fit app where customers can come in for measurements and store their all their data online.
  • Realtor Network: a real estate agent used Knack to create a network for agents to list buyers and sellers and search for matches.
As always we’re thrilled to see the variety of custom web apps and online databases bult with Knack every day.

Continue reading...

Example App: Purchase Orders

04/24/2013 Posted by Brandon

We’re starting to add more compex apps to our example catalog that show off some of Knack’s advanced features.

First up is a purchase order app. Staff can log in and manage vendors and products and submit purchase orders. Reports can be run on weekly totals and vendor and item totals.

Some features the purchase order app is using:

  • Equations: Item totals are automatically calculated from the quantity and item price
  • Formulas: Totals are summed for each product and vendor.
  • Form Rules: The logged in user is assigned via a form rule as the author of the purchase order
  • Reports: Reports are run for weekly totals and vendor and item totals.
We’re planning on starting on some project management and CRM apps next.

Continue reading...

New Feature: Using Remote Images

04/22/2013 Posted by Brandon

Knack image fields now have the ability to use images hosted on other websites. You can set this option when editing an image field in your database:

This means you can now easily use images hosted on your own site, CDN or asset library with your Knack app. It also means these images can be imported by including the URL in the CSV.

We also included the ability to add thumbnail versions. It still needs to load the full image but you have the option of using different sized thumbnails of your images throughout you app.

Continue reading...

Filtering and Limiting Connections

04/02/2013 Posted by Brandon

We recently added features to filter and limit the records that show in connection inputs.

Filters

You can now add filters to any connection input to filter which records will display.

For example, let’s say you have a form to add a new Rental. Each Rental is assigned to a Product, which has an “available” field. You can now add a filter to only show those Products where “available = true”.

Showing records connected to another form input

Multiple connection inputs can be added to a form so that the records of a child connection input will display depending on which parent connection record is selected.

For example, if you have connections to both companies and employees, you can edit employees so that only records connected to the currently selected company will display. When the user selects a different company the employee records will automatically update.

Limiting child records connected to the same parent

You can also limit connection records that have a parent that has been selected in the app or connected to the logged-in user.

For example, let’s say you select a Company from a table and then have a form to add a Project to that Company. Projects can also be assigned to an Employee. When selecting Employees, you’ll only want to show the Employee records that are connected to the selected Company.

You can now edit that Employee input in the form and have

Please note: these features are in beta

Please note that these features are in beta. Please contact us immediately if you notice any issues with these features.

Continue reading...