Knack Blog

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

 

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

Featured Web Apps: March

03/25/2013 Posted by Brandon

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

  • Materials Database: A Plastics Engineering company uses Knack for an online database of materials so users can search and download engineerings specs.
  • Price List: A Commodoties Buyer uses Knack to list precious metal prices for their customers using daily changes and equations for different measurements.
  • Recruiting Database: a College uses Knack to manage the recruiting process for football student athletes.
  • Job Placement App: a University Administrator uses Knack to manage a Job Board for students and employers.
  • Advertisement Tracker: a Media Company uses Knack to manage available advertising locations and the customers and revenue generated for each.
We’re still amazed by the variety of custom web apps and online databases we continue to see. This only gets more interesting as we continue to add great features. Can’t wait to see what’s next!

Continue reading...

Announcing the Knack API

03/06/2013 Posted by Brandon

We’re thrilled to announce the release of the Knack API!

The API was designed to provide access to your Knack online database, as well as tools and documentation for extending your Knack apps:

  • Root Data Access: a secure API is provided for full access to your raw data. You can use this for integrating your data with other services and APIs, running maintenance tasks, inserting and updating records…the opportunities are endless.
  • Scene Access: a scene API is provided for working with your app’s Scenes and Views. This is much more limited and follows any rules defined by your application, like logins and user roles. This API can be used with JavaScript to respond to app events and further extend the functionality.
  • JavaScript Events: you can add JavaScript listeners to respond to specific events triggered by your app. For example, when a view renders you may want to insert your own button or set the color of a specific element. Or when a form is submitted, you may want to insert that record into Salesforce.
  • CSS Customization: when you publish a Knack app to your own website you can use your site’s CSS to modify the visual look and design of the app.
We’re really excited to see how it’s used:
  • Front-end coders can use Knack to easily build a custom online database, set up a basic interface, and completely control and customize the app with jQuery and CSS.
  • Mobile developers can create apps where the data is stored in the Knack online database. You can create Knack apps that can enable admins to update or view the data the mobile app is using.
  • Designers can publish Knack apps directly in their client websites and completely control the look and feel to match their designs.
You can access documentation for the API here:

http://support.knack.com/knowledge_base/topics/working-with-the-api

Please try it out and let us know what amazing creations you come up with!

Continue reading...

Featured Web Apps: February

02/18/2013 Posted by Brandon

This is the latest entry in a series describing different web apps and online databases that Knack users are building:

  • Project Management: Photobox, the leading European online photo service, uses Knack to manages special projects across multiple teams.
  • Cashflow Management: a bag manufacturer is using Knack to manage orders, deliveries, and cash-flow reports. Special access is given to accountants for key reports.
  • Homeowners Portal: an HOA uses Knack for a neighborhood directory and for tracking HOA issues.
  • Freight Management: a trucking company uses Knack for a full service freight management solution, including invoices and accounting, trips and logs, and fleet management.
  • Production Whiteboard: an online marketing firm uses Knack to manage production roles and deadlines.

We’re really excited about each of these custom web apps and online databases. We can’t wait to see what will be built with Knack next!

Continue reading...

New Feature: Tracking Record Changes

02/13/2013 Posted by Brandon

For Knack users with a Pro plan or above, we’ve added some features for managing records in your online database. There’s now a small edit icon with each record:

You can click on that icon to edit the entire record at once:

You can click on the History tab to review changes for that record:

This will provide the version of the record every time it was changed, highlighting any changes from the previous record with a color.

It also notes the time of the change, whether it was updated in the builder or the app, and who changed it (if applicable).

Continue reading...

Create Custom Mobile Workforce Apps

02/05/2013 Posted by Brandon

We recently added a new example app called job tasks.

It’s a fairly simple app, but it presents a framework for easily building distributed and mobile workforce apps with Knack.

The idea is you have a workforce that is either distributed across multiple regions or just doing most of their work on mobile devices away from the office.

Companies that do work activites off site often are using incredibly cumbersome paper systems to transfer information from the job to the company. We’re seeing the following as just a few examples for migrating to mobile apps:

  • installations
  • repairs
  • appraisals
  • inspections
  • contract estimates

Knack makes building online database apps for your mobile workforce really easy.

You set two user roles: “Supervisors” and “Employees” (or similar). When a Supervisor adds a new job or task, he connects that record to one or more Employees.

The Employees can then log in from any mobile device to view and update their assigned tasks. So right from the field they can enter their inspection data, or view installation instructions, or set a task as completed.

The key is Knack’s great User Authentication features. We’ll soon be releasing a video tutorial on setting up a mobile workforce app from scratch.

In the meantime please let us know if you’re working on a mobile workforce app or need help with setting up your online database.

Continue reading...

New Features: Form Actions & Display Rules

02/03/2013 Posted by Brandon

It’s a feature extravanganza! We’ve released so much new functionality we need multiple sections to cover it:

Form Submit Rules

You can now set rules that trigger actions when a form is submitted. Here’s what it looks like to set a custom email:

Each form can have multiple submit rules, and each rule consists of criteria and an action.

The criteria allows you to define when the action is triggered. For example, you may only want to send an email when a status field is updated to “pending confirmation”. The default is to trigger the action for every form submission.

Each rule can perform one of the following actions:

  • Send an email: Send custom email reciepts, notices, and other email templates. You can use inputs from the form to populate the template.
  • Update the form record: useful for setting status or workflow fields on submissions. You can also assign logged-in users so you can track who submitted comment, rating, or ranking forms.
  • Insert a connected record: add a new record connected to the form record. Your form object must be connected to other objects for this option to be available. Great for adding history, version, and archived records based on the submission.

Field Rules

Field rules are triggered when a form is initially populated or updated by the user. These are useful if a certain input response should hide or show additional inputs

The classic example is a multiple choice input where one of the options is “other”. If they user selects other you can show an additional “comments” input to explain.

Based on a criteria you can trigger multiple actions:

  • Show or hide an input: as discussed this will show or hide inputs based on the rule criteria.
  • Rename label: This can change labels of other inputs. For example, if you had a multiple choice for “language”, you could change the labels of the other inputs based on that language selection.
Details Field Rules

Similar to Forms, you can hide and show fields based on criteria in a Details view as well.

Beta

Please note that these are both in Beta. This means that you may encounter some bugs or unexpected behavior while using them. Please contact us immediately if you do.

Continue reading...

Featured Web Apps: January

01/22/2013 Posted by Brandon

This is the latest entry in a series describing different web apps and online databases that Knack users are building:

  • Order Management: A mobile phone shop is using Knack to track all phone purchases and repairs.
  • Customer Portal: A web design agency has built a portal for customers to log in and view projects and invoices.
  • Music Library: a choral director is using Knack to track and distribute sheet music for arrangements.
  • Employee Appointment Tracker: a healthcare technology company is building an online calendar to schedule and track employee service visits.
  • Lab Test Database: a medical lab is using Knack to track tests for clinical trials.

We’re really excited about each of these custom web apps and online databases. We can’t wait to see what will be built with Knack next!

Continue reading...

New Feature: Equations & Text Combos

01/18/2013 Posted by Brandon

We’ve recently released two new fields we’re really excited about: equations and text combos.

Both fields are used to create new values based on others.

Equations

Equations are used to perform mathematical functions on numeric fields. So like the example above, you can easily create simple math equations for doing things like:

  • totalling orders
  • calculating sales commissions
  • determining profit/loss
Equations can also be combined with the other formula fields like Sum, Average, Min, Max to create some complex equations.

Text Combos

Text combos are similar to equations except you can combine any field and text (not just numbers). Instead of math functions these are all simply combined together to form a new text field.

Text Combos are useful for:

  • combining fields to create a more informative ID fields
  • creating name or address fields from separate fields

Beta

Please note that these are both in Beta. This means that you may encounter some bugs or unexpected behavior while using them. Please contact us immediately if you do.

Continue reading...