Knack Blog

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

 

The Knack Roadmap

11/30/2016 Posted by Brandon

In case you weren’t aware, software development is hard.

When you combine overly optimistic expectations, backwards compatibility, scope creep, conflicting user needs, changing requirements, engineering allocation, quality control, and technology trade-offs, you have a recipe for things to go very wrong very quickly.

Trying to predict timelines and deliverables on top of all of this is even harder. It’s why we’ve been hesitant to do it. The last thing we want to do is create false expectations, miss deadlines, or disappoint anyone depending on a crucial feature at a crucial time.

In addition, our internal roadmap is a living document. It changes weekly. We pride ourselves on the ability to move quickly and change directions to respond to demand, capture opportunities, and optimize resources.

All that being said, we understand that we owe it to our customers to make some attempt at this. Many of you are making long term investments in the Knack platform. Some of you are even making your living from developing Knack apps. We understand how important it can be to have insight into where Knack is going and what features will be included in the near future.

Our first stab at this will be a very high-level roadmap you can access here:
https://roadmap.knack.com

This roadmap will be subject to change. We still won’t be able to provide exact estimates or timelines on feature releases, but we do hope it helps to provide some insight into where Knack is going.

As always, our roadmap is completely defined by building the best product we can for our users. We need your feedback and insight to help define what that product will be. You can continue to add suggestions to our forum or contact us at any time.

What’s next?

11/22/2016 Posted by Brandon

This year has seen a focus on major projects.

Knack has continued to grow into a mature company managing billions of database records for customers all over the world. To keep up with that pace, we’ve undertaken major projects to address virtually every aspect of our product and infrastructure.

With all these major projects flying around we thought now would be a great time to review everything we’re working on and where Knack is going.

What got completed?

The first major project was completely revamping our infrastructure to better leverage a cloud-based architecture that can grow dynamically and be isolated to different geographic areas.

We then completely redesigned our Builder, making it easier to use and adding features like view previews, and/or filters, and batch deleting.

After the builder we moved our Knowledge Base to a new provider, improving our articles and videos as well as giving us more insight into how we can offer better support.

So what’s next?

Continue reading...

Helping our help desk

11/01/2016 Posted by Brandon

Along with the launch of our new builder we took the opportunity to completely revamp our help desk!

Along with a clean and simple new design we're looking forward to new tools and data that will help us improve the support experience.

help-desk

Continue reading...

Introducing the new builder

10/04/2016 Posted by Brandon

A new version of our Knack builder has been live for a few weeks now and we couldn’t be more excited!

We’ve learned a ton during the 2 years since our last release, and we’ve applied that learning to further optimize and simplify the process of building data-driven web applications.

We put together a new intro video to walk through it (we also dramatically improved our video skills).

Now that the dust has settled we wanted to provide some insight into the goals of this new builder and what changes those led to.

Continue reading...

Guest Blog post: How doctors can track continuing medical education credits using Knack and Zapier

07/11/2016 Posted by Brandon

Alex used Knack and Zapier to create CMElog, his own service for tracking medical credits

Knack is loaded with features right out of the box that make it simple to build powerful online database apps. What can be easy to forget is how much more power you can add by integrating other services with your Knack database.

Our API makes it easy for developers to add integrations, and Zapier is great for creating simple connections and triggers between these services.

In our first guest blog post, Alex Mohseni explains how he used Knack and Zapier to build a TripIt like clone to help manage education credits.

Alex is a practicing Emergency Medicine physician around Washington, DC. He integrated  Knack with services like DropBox and Mandrill to combine their functionality into a single powerful service that gave him the exact features he needed.

Part of what makes Knack so powerful is that it integrates easily with Zapier — but how to do that can be a bit tricky, so Alex decided to include some of his “lessons learned” with a fantastic tutorial.

Take it away, Alex!

Continue reading...

Upgrading Our Infrastructure

06/15/2016 Posted by Brandon

When we started Knack, our traffic was small enough that we just needed one tiny server. As we grew we started to add a few cloud servers here and there. And this worked fine for a while — we could just add more servers whenever we needed.

These last few years have seen considerably more growth, and that model started to show some cracks. We were leveraging the cloud but certainly not optimizing for it. Users from other areas were seeing delays and we weren’t able to keep data isolated to a specific region.

We were on training wheels and needed to upgrade to a ten speed.

Continue reading...

Our New Domain

05/26/2016 Posted by Brandon

Notice that short URL in your browser above? We’re now officially using knack.com for our domain!

It’s a big milestone for us and we thought we’d share a little about how we came to this point.

the knack

Continue reading...

Upgrading our Text Combo to Text Formula

04/28/2016 Posted by Brandon

We just gave our text combo field so many new super-powers we had to rename it.

Introducing the new Text Formula: it’s a magical combination of our old Text Combo field and the recent equation updates.

You can combine any text values like before but now you can also include a great library of text-based functions.

Continue reading...

Better Data with Validation Rules

01/28/2016 Posted by Brandon

Your database is only as good as the data it contains.

In most cases this is obvious. If you are calculating order totals, you’l need each order to have a number that can be added together. If you are running monthly reports you’ll need some valid dates to group by month.

Other cases are more subtle. You may want to only accept dates that are in the future, or define allowable ranges for a number.

Data that breaks these types of rules may not crash your database, but getting those values right can be just as critical to ensuring your data is meaningful and correct.

Knack has always helped by ensuring field types and providing options for values to be required or unique.

We recently added a feature that dramatically expands Knack’s validation capabilities: validation rules.

Continue reading...

All the Math Functions!

12/09/2015 Posted by Brandon

When we first launched our equation editor we were pretty excited: the ability to use field values in mathematical (and date-driven) equations opened up exciting functionality.

We considered adding more advanced equations like rounding or exponents, but decided to keep it easy with basic arithmetic. We figured our users would appreciate the simplicity and how well it worked.

Boy were we wrong.

We immediately started seeing demands for all sorts of functions (is a hyperbolic tangent function really needed? yes, yes it is).

Many of these opened up major features like mortgage amortization and equipment depreciation. It quickly became a no-brainer decision: we had to completely redesign our equation editor.

We recently released this upgraded equation editor, complete with a whole new library of functions:

A major change is simply how it works. Instead of a largely point and click approach we’ve opted for a typing-based approach:

  • As you type a dropdown menu of fields and functions becomes available to autocomplete.
  • Each field or function in the menu provides some additional contextual info about how to use it.
  • As you construct your equation you’ll get instant feedback on how it works and whether it’s valid above the editor.

New functions

We included a whole slew of mathematical functions that are now available to integrate with your equations.

Some highlights include:

  • ceil – Round a value up to the nearest integer. Example: ceil(4.2) = 5
  • factorial – Compute the factorial of a number. Example: factorial(5) = 120
  • max – Get the maximum of a list of values. Example: max(1,6,9) = 9
  • mean – Compute the mean of a list of values. Example: mean(1,6,8) = 5
  • median – Compute the median of a list of values. Example: median(8,9,1) = 8
  • min – Get the minimum of a list of values. Example: min(42, 100, 3) = 3
  • pow – Calculate the base to the exponent power. Example: pow(7,2) = 49
  • randomInt – Get a random integer between two values. Example: random(1,42) = 36
  • std – Compute the standard deviation of a list of values. Example: std(1,5,42,78) = 36.07861785970558
  • sqrt – Calculate the square root of a number. Example: sqrt(81) = 9
You can view the full list of functions here.

Conditional Equations

You could always use conditional rules to include logic with field values an equation uses, or to choose from multiple equations.

You can now include logic right in the equation to create conditional equations.

It’s called a ternary operator and works like this: (condition ? equation_1 : equation_2)

This means if your condition is true, Knack will use the equation followed by the ? symbol. If your condition is false, Knack will use the second equation followed by the : symbol.

Continue reading...