Logic, Equations & Formulas

Start an Auto Increment Field from Any Number

Scenario. You want to begin the count in an auto increment field from a number other than 1. Knack users often already have record ID numbers stored in an existing database or spreadsheet and would l…

Danielle Kellogg
Updated 11 months ago by Danielle Kellogg

Display a Message When a Deadline is Approaching

This article will discuss using page rules to show a message in the Live App when a date/time is approaching. Scenario. Your app contains records from your database that have a specific date/time. Yo…

Danielle Kellogg
Updated 2 months ago by Danielle Kellogg

Generate Simple Numeric Barcodes Automatically

Scenario. This article will explain how to generate barcodes based on a number from each record. In this scenario we will be using an Order Number field to generate the barcode. Requirements. In orde…

Danielle Kellogg
Updated 5 months ago by Danielle Kellogg

How to Set a Random ID

Scenario. You would like assign a random ID to new user sign-ups or generate coupon codes. Since Text Formulas and Equations recalculate every time a record is updated, the random function [ random()…

Sarto Jama
Updated 11 months ago by Sarto Jama

Calculate Age in Years from a Birthday

Scenario. You would like to calculate someone’s age based on their birthday. Requirements. This article assumes you already have an object set up where the birthday value will be stored. You can read…

Danielle Kellogg
Updated 2 months ago by Danielle Kellogg

How To Number Line Items

Scenario. There are a few scenarios where you may want line numbers to start over from "1" for a group of records. For example, in an Orders app , you have one or more Line Item records that are asso…

Danielle Kellogg
Updated 11 months ago by Danielle Kellogg

Show Upcoming Birthdays

Scenario. You would like to show and be alerted about upcoming birthdays. Requirements. If this your first time creating an app, you'll need to know some basics about adding objects, fields, pages, a…

Danielle Kellogg
Updated 11 months ago by Danielle Kellogg

How to Extract the Start and End Dates from a Date Field

Scenario. You’re using the advanced calendar options on a date field to capture both a start and end date. You’re displaying that field on a calendar. But you also want to use the start and end dates…

Sarto Jama
Updated 11 months ago by Sarto Jama

How to Display Multiple Date Formats Using a Single Date Field

Scenario. You want to display a date field in different formats. For example, let’s say that you’re accepting registrations for an event and want to show the date of the event in the following format…

Danielle Kellogg
Updated 11 months ago by Danielle Kellogg

Contact