Fields

Numeric Equation Functions

This information is referenced in the Equations article. The functions listed on this page are only available for Equation Fields. If you're looking for the functions available for Text Formula field…

Danielle Kellogg
Updated 2 years ago by Danielle Kellogg

Field Types

What are Field Types? Fields are used to define specific attributes of a table. Knack offers a wide variety of field types, each with its own unique behavior and options. Becoming familiar with the t…

Danielle Kellogg
Updated 1 month ago by Danielle Kellogg

Validation Rules

What is a Validation Rule? Validation rules allow for values which are or are not allowed on a specific field. Validation rules apply when adding or editing a field, both in the Builder and on Live A…

Lesley
Updated 2 months ago by Lesley

Date Equation Settings

Date equations can calculate dates and format results as date values or number of hours, days, weeks, or years. To enable date calculations, update the “Equation Type” to “Date”. Equation Type: Defin…

Ro Chittick
Updated 2 months ago by Ro Chittick

Numeric Equation Settings

This article covers the numeric equation settings, you can find more on Equations here. Numeric equations can run calculations on field values, numbers, and other mathematical functions and format re…

Lesley
Updated 8 months ago by Lesley

Formulas

What is a Formula Field? Formula fields are used to run calculations on connected records and store the total of that calculation. The following are common examples of when formulas are used: Order T…

Danielle Kellogg
Updated 3 weeks ago by Danielle Kellogg

Equations

What is an Equation? . Equation fields work by combining field values, numbers, and other mathematical functions to create an equation that will be calculated for each record. They are a type of a fi…

Lesley
Updated 3 weeks ago by Lesley

Conditional Rules

What are Conditional Rules? Conditional rules can be used to automatically set the value of a field based on the rules, or conditions, that you define for the field. Here are some examples of how con…

Lesley
Updated 1 month ago by Lesley

Text Formulas

What is a Text Formula? Text Formulas are fields that combine multiple text values into a single field, including values from other fields. Text formulas are very similar to equations and can be adde…

Lesley
Updated 1 month ago by Lesley

About Fields

What are Fields? Knack uses tables and fields to structure your data. Fields are used to define specific attributes of a table. You can think of a field like a spreadsheet column. You'll want to add…

Lesley
Updated 2 months ago by Lesley

Text Formula Functions

This information is referenced in the Text Formulas article. The functions listed on this page are only available for Text Formulas. If you're looking for the functions available for Equations, click…

Lesley
Updated 1 month ago by Lesley

Contact