## 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…

Updated 2 years 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…

Updated 2 years 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…

Updated 2 years 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()…

Updated 2 years 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…

Updated 2 months ago by Lesley

#### 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…

Updated 2 years 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…

Updated 2 years 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…

Updated 2 years 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…

Updated 2 years ago by Danielle Kellogg