Loading...
Knack Database Services 2018-02-20T11:05:28+00:00

What is Knack?

Knack an online platform which enables businesses to build their own custom databases. While the platform’s out of the box functionality is strong and can be harnessed with minimal relational database knowledge, it is not unusual for businesses to want to expand the boundaries of what their system can do. This is where we come in.

While we are happy and able to build a database from scratch using Knack or other system platforms, we service a lot of Knack databases, and many requests are very similar if not identical. So to help make things more efficient, here is our list of services and upgrades provided for you with all fees included. This is a small sampling of everything we have done to date and can patch into your system within a matter of hours, to make your business’ day-to-day more efficient.

Take a glance below and if you have any questions or see something you like, don’t hesitate to complete the form at the bottom of the page. We look forward to meeting you!

The DataCove Team

$149.99 USD

Automated currency exchange

DELIVERABLES
When a form is submitted that collects a currency value, an API to a live public exchange database converts the value to another currency of your choosing, and then stores the value in another field on that same record.

DETAILS
The rate assumes the function will be applied to one currency field, on a single form, and that currency value is being converted to one other currency type, using the live exchange rate at the moment the form is submitted, and the new data point is stored in another field on the same object.

$199.99 USD

Automatic form population

DELIVERABLES
When a specified field is populated on a form, the remainder of the fields on the form are automatically populated from either a connected object in your database, or another database entirely via API call.

DETAILS
The rate assumes that an API call is being utilized, the other online database is designed to accept API calls, that no more than 15 fields are being automatically populated on the form, and that the function is being applied to a single form.

$399.99 USD

Automatically push users to correct login views

DELIVERABLES
In the event that a user with a valid login tries to access a view they do not have privileges for, the user is rerouted to a view of your choosing, that they do possess access for and is logged into the system.

DETAILS
The rate assumes that the function covers no more than 5 user roles, where each user role has a maximum of 15 views in the database in which they cannot access.

$749.99 USD

Cart functionality

DELIVERABLES
At the click of a button the user can select a record in your database, and have it copied to a cart object where it is then linked to their log-in. This feature can also be accomplished by applying the checkbox and record update functionality, allowing for multiple records to be selected at once, and then added to the logged-in user’s cart in bulk. The copied records are independent of the original inventory or service items, and as result can then be utilized to track status, feedback, specific regional conditions or any other details which are unique to the purchase order.

DETAILS
The rate assumes that the inventory or services object possess no more than 30 fields, and that the add to cart functionality is being applied to a single view.

$249.99 USD

Checkboxes and record updates

DELIVERABLES
Adds a checkbox column to a table, and then a button to the same view which performs a batch update to your records.

DETAILS
This is a base rate and as such assumes one field is being updated on the selected records, and the field resides on the object to which the table view has been built upon.

$299.99 USD

Copy and split records for a many-to-many connection

DELIVERABLES
When a record possesses a many-to-many connection field to another object, our script will copy the entire record for each of the connections within that field. Such that each connection value then receives its own record.

DETAILS
The rate assumes that the function is applied to one object, one field containing the many-to-many connection, and the object possesses no more than twenty fields.

$174.99 USD

Custom calculation on table view

DELIVERABLES
Displays a custom calculation with label anywhere on a table view.

DETAILS
The rate assumes that the calculation is applied to a single table view, and utilizes data visible on the table in the view; with the exception of static values (these do not need to be on the table).

$74.99 USD

Custom dynamic dropdowns

DELIVERABLES
A form’s dropdown options will automatically vary themselves depending on previous field entries on that same form.

DETAILS
The rate assumes that the previous field entry is on the current form, the function is being applied to a single form, no more than five custom scenarios exist for the dropdown menu’s options, and that no more than 20 dropdown options are being shown/hidden at a time.

$499.99 USD

Custom report from scratch with PDF export button

DELIVERABLES
At the click of a button, you can export a PDF report with as much variation as your relational database will support. This report can include custom graphics and much more.

DETAILS
The rate assumes the report is no larger than two letter sized pages in length, the data points utilized are coming from no more than 3 objects, with a cumulative max of 50 data points (fields), and the client is providing any images to be displayed on the report.

$249.99 USD

Custom rolling numbers

DELIVERABLES
Upon creating a record, a rolling number can be assigned to the record itself for the purposes of identification. Knack does this by default, but this script takes that functionality one step further. This rolling number can be dependent upon another data point within the record, and hence it is possible to have many rolling numbers in your database at once, for different groups of records as determined by the data point you select (usually this a classification field which possesses a dropdown menu).

DETAILS
The rate assumes that the rolling number’s generation will be triggered by the submission of a single form, that there are no more than 5 rolling number groups as dictated by the selected data point, and the groups themselves are defined by the data point found on the record itself.

$249.99 USD

Custom validation rules

DELIVERABLES
Add custom validation rules to a form, and display a notification in a Knack stylized notification message pane, while pushing the user to the top of the screen. The contents of the notification itself are of course customizable.

DETAILS
The rate assumes the function is applied to one form, and inclusive of three custom validation rules. The validation rules can include data checks from connected objects within the database.

$999.99 USD

Dropbox API

DELIVERABLES
This script allows your database users to access and retrieve dropbox files, and automatically create multi-level directories in your dropbox account; labelled using your data points from your Knack database. This function is often used for scenarios where large amounts of images or other files are loaded into dropbox, and are then connected to records in Knack, allowing for the best of both worlds in one screen.

DETAILS
The rate assumes there will be one access point to your dropbox account from your database.

$199.99 USD

Duplicate Entry Check

DELIVERABLES
At the click of a button our custom built function will check your object for instances where multiple records possess identical data points. Where a duplicate is found, a field on the duplicate record receives the matching record’s unique identifier so you can identify where the duplicates are in your object (assuming your object has a unique identifier, otherwise we can populate that field with any value you’d like from the matching record’s data).

DETAILS
The rate assumes the function is applied to one object, and that there are no more than five fields being assessed for duplicates.

$99.99 USD

Dynamic URL links in emails

DELIVERABLES
Inserts a custom dynamic webpage link in your automated emails, to provide your recipient a convenient link to any view in your database.

DETAILS
The rate assumes that the automated email is already in place, and the recipient has the required privileges access to specified view.

$174.99 USD

Export a view as a PDF

DELIVERABLES
A button is placed onto a database view and when clicked; the visible view is exported as a PDF file.

DETAILS
The rate provided assumes that there are no modifications to the exported file. While this is possible, here we are quoting to export the Knack view as it exists on the webpage.

$49.99+ USD

Field and view modifications

DELIVERABLES
We handle small modifications as well! Sometimes you don’t want to re-invent the view, but some part of it just isn’t sitting right. We can help. We align columns, modify text, shift fields around, and do all sorts of tweaks to make things work. Just ask!

DETAILS
This base rate assumes the modifications are impacting one form or view, no more than 20 fields or data points are being modified, and that no data manipulation is occurring.

$249.99 USD

Front-end CSV upload button

DELIVERABLES
A button is placed on a database view which allows the system users to batch upload records into the database via CSV file.

DETAILS
The rate assumes that the function is uploading data into one object, contains no more than 25 fields, and the upload button is placed on one view.

$99.99 USD

Help icon and PDF

DELIVERABLES
Every database view is given a help icon (of your choosing), which when clicked will open a PDF in a pop-up window. This PDF typically serves as a manual or flowchart to assist your users in utilizing your database.

DETAILS
The rate assumes that the patch is applied to all views in the database, and the help file is the same PDF file throughout.

$99.99 USD

Hiding fields and data based on logged in user record data

DELIVERABLES
Hides fields and data on forms and views, based on a data point from the logged in user’s account. Useful for when you need to capture varying data from your users depending on their geographical area (in this case the data point on the logged in user’s account would be country!).

DETAILS
The rate assumes that the conditional data point resides on the logged in user’s account record, and that there are no more than 20 data points being hidden within a single view or form; on more than 10 different views.

$99.99 USD

Hiding filters options from the filter menu

DELIVERABLES
Removes specific fields from the default Knack filter options for better customization and user experience.

DETAILS
The rate assumes that the modification is being applied to a single view, and that no more than 20 fields are being hidden.

$299.99 USD

Image/file batch update

DELIVERABLES
A one time process that performs a match merge and record update, consisting of a batch of images or files, to an existing object’s records in your database.

DETAILS
The rate assumes that no more than 2000 images and/or files are being imported/match merged to the existing object, that the import is being applied to a single object, and the file names of the images/files that are being imported match an ID field on the records in the database’s object.

$149.99 USD

Login history

DELIVERABLES
A login history object is added to your database so you can view past user logins. Additionally, a user’s login record will also show the last time they logged into the system.

DETAILS
In order for the script to function reliably, system users must be running an up-to-date browser. See fine print below for full definition.

$199.99 USD

Password verification

DELIVERABLES
Upon submitting a form the user is prompted to re-enter their password. The password verification must be successful in order for the form to be submitted. Otherwise, the user will receive a notification that their password did not match and will remain on the form view.

DETAILS
The rate assumes that the function is applied to one form, and the form view itself must be behind a login.

$99.99 USD

Pre-populating form fields

DELIVERABLES
A form’s fields will automatically contain dynamic data of your choosing. The source of this data can come from other records and objects in your database.

DETAILS
The rate assumes that the function is applied to one form, and no more than 20 fields are being automatically populated.

$399.99 USD

Saving filter settings

DELIVERABLES
The view’s filter settings will be saved for a given user’s login, and will automatically be applied the next time the user returns to the view.

DETAILS
The rate assumes that the function is applied to one view (which is not a child view), that displays data belonging to no more than 20 fields, from a single object.

$49.99 USD

Update a record upon viewing

DELIVERABLES
Update a record’s data just by viewing it in the system.

DETAILS
The rate assumes that the function is being applied to a single view, and that you are not conditionally updating the record based on other variables. Everything is possible, but let us know and we can discuss further.

$199.99 USD

Update records created with form record rules

DELIVERABLES
When you create records via a form’s record rules, sometimes you need to customize the data on the record beyond Knack’s basic functionality. This data update can even be conditional upon the connections that the newly created record possesses.

DETAILS
The rate assumes the function is applied to one form, and one custom update within the level of complexity defined within the description of this modification.

The Fine Print

While it’s not our intention to rain on the parade, some limitations do apply.

  • The rates described above are limited to the details associated with each script. Please review them carefully.

  • Our scripts assume that there is no pre-existing javascript controlling or impacting the associated views, objects and fields within them.

  • We can modify the scope of the modification, but we must be told in advance so we can properly estimate the work involved. Otherwise we will need to pause the upgrade and re-establish deliverables and quotes.

  • We cannot provide free support for our modifications. We require you to provide sign off on the function upon completion, and after that you are responsible for the script. If your database administrator breaks the function by changing variables the script depends on, we cannot repair it free of charge. This includes instances where the platform itself is patched and the script becomes inoperable. These scenarios do not happen often, but it is unfortunately a possibility and service cannot provide indefinitely. We are happy to repair or patch the code, but fees may apply.

  • You are responsible for ensuring that your database and subscription has the capacity to support the script’s functionality (ex. daily API call limits). If you are not sure what you have, ask us! It’s no problem.

  • Different browsers have varying compatibility with html/css and javascript functions. For that reason, we cannot support out of date browsers. It makes progress slow, and many of these features impossible to provide. We can only guarantee successful implementation on up to date versions of Chrome, Firefox and Safari, otherwise performance may vary.

Our Guarantee

“If you’re not 100% satisfied with your system’s service or upgrade, it’s on us.”

Let’s get started!

Loading...