--- title: "Advanced rules" slug: "advanced-rules" updated: 2026-09-28T06:23:24Z published: 2026-09-28T06:23:24Z canonical: "help.quickbase.com/advanced-rules" --- > ## Documentation Index > Fetch the complete documentation index at: https://help.quickbase.com/llms.txt > Use this file to discover all available pages before exploring further. # Advanced rules ## Overview FastField comes packed with an extremely powerful and robust form rules engine with the following capabilities: - Skip logic - Calculations - Variables - Action alerts - Conditional workflow Advanced Rules are **form rules**, as opposed to **field rules**. Field rules are rules that trigger action from a single field, while form rules (Advanced Rules) let you create rules that span multiple fields and fire multiple actions in a single rule. For example, you can create rules that trigger alerts, hide and show other fields, calculate sums of fields, and more based on the conditions you set. With Advanced Rules, you have all of the power and flexibility of scripting language with no technical knowledge of programming or JavaScript required. When written as a script, a form rule may look something like this: ```plaintext if (IssueFound == true && Severity == 'High') {    show('WhatIssueWasFound'); } else {      hide('WhatIssueWasFound'); } ``` Instead of writing a script to accomplish this, however, you can set up an **Advanced Rule** as shown here: ![Advanced Rule setup replicating the if/then script logic using a visual rule builder](https://cdn.document360.io/dd260e4e-10bb-4b66-8fb3-5504c272b904/Images/Documentation/blobid0(15).png?sv=2026-02-06&spr=https&st=2026-10-30T07%3A57%3A13Z&se=2026-10-30T08%3A57%3A13Z&sr=c&sp=r&sig=QD0pLSh2tjXmQKbtIEaWw%2Fj%2FcvoAPVT80qL3PjC4s1M%3D) The Advanced Rules screen provides a menu to select from your field list and available functions, requiring limited or no programming experience. ## How to set up an Advanced Rule 1. Open your form in the **Form Builder**. 2. Select **Advanced Options** > **Advanced Rules** to open up the rule editor. Stay in the **Rules tab.** ![Advanced Rules screen accessed from Advanced Options in the Form Builder](https://cdn.document360.io/dd260e4e-10bb-4b66-8fb3-5504c272b904/Images/Documentation/12751444415629?sv=2026-02-06&spr=https&st=2026-10-30T07%3A57%3A13Z&se=2026-10-30T08%3A57%3A13Z&sr=c&sp=r&sig=QD0pLSh2tjXmQKbtIEaWw%2Fj%2FcvoAPVT80qL3PjC4s1M%3D) 3. You will be presented the **Form Rules** screen. To add a rule, select the **Add Rule** button. 4. **Name** your rule. - It's best to give this a logical name so you can find your rule in the list of rules you may have later on. 5. Add a **Rule Condition.** - Select a field from the **Field, Rules, and Variables** dropdown list. - You can add additional conditions by selecting the **+** button. 6. Select the type of **evaluation** you are performing. - The list of operators will change based on the field that you selected. - In the following example, we chose a *Yes/No/NA* field, so we have the options *Equals*, *Not Equals*, and *Has Value:* 7. Select the **value** you are comparing your field to. - In the example below, we are checking if the *Was there an issue found?* field has a value of *Yes*: 8. Once you have set up your rule conditions, define the **actions** that run if those conditions are met. - You can add additional actions by selecting the **+** button. - In the following example, we are going to *Show* the *Please describe the issue* text field if the user taps *Yes* on the *Was there an issue found?* field: - See a list of available actions in the next section. ## Actions The following is a list of available actions that can be triggered on an Advanced Rule: - **Show (Else Hide)** — Shows a field/section when a condition is met, otherwise hides it - **Show** — Shows a field or section - **Hide (Else Show)** — Hides a field/section when a condition is met, otherwise shows it - **Hide** — Hides a field or section - **Set Color - Green** — Sets a field or section's color to Green - **Set Color - Blue** — Sets a field or section's color to Blue - **Set Color - Yellow** — Sets a field or section's color to Yellow - **Set Color - Red** — Sets a field or section's color to Red - **Clear Color** — Resets a field or section color - **Disable (Else Enable)** — Disables a field or section when a condition is met, otherwise Enables it - **Disable** — Disables a field or section - **Enable (Else Disable)** — Enables a field or section when a condition is met, otherwise Disables it - **Enable** — Enables a field or section when a condition is met - **Required (Else Not Required)** — Sets a field or section as required when a condition is met, otherwise sets it to Not Required - **Required** — Sets a field or section to Required - **Not Required (Else Required)** — Sets a field or section to Not Required when a condition is met, otherwise sets it to Required - **Not Required** — Sets a field or section to Not Required - **Add Alert** - Adds an Action Alert to the form when the conditions are met ## Action alerts Action Alerts can be leveraged for several purposes. You can think of Action Alerts as notices or tasks that are being triggered by conditions or how a form is completed. For example, Action Alerts can be used as a **summary** of issues that were identified in an inspection form. Action Alerts can also be used to drive specific **workflow actions** when your form is submitted. In the case of an inspection form, your workflow may forward a form to a Sr. Inspector if the *High Severity Issue* alert was triggered during the inspection. The following screenshot illustrates the use of an alert in a Form Rule: ![Form Rule configured with an Action Alert triggered by a rule condition](https://cdn.document360.io/dd260e4e-10bb-4b66-8fb3-5504c272b904/Images/Documentation/blobid2(10).png?sv=2026-02-06&spr=https&st=2026-10-30T07%3A57%3A13Z&se=2026-10-30T08%3A57%3A13Z&sr=c&sp=r&sig=QD0pLSh2tjXmQKbtIEaWw%2Fj%2FcvoAPVT80qL3PjC4s1M%3D) ## Calculations/Variables In the **Calculations/Variables** tab of the Advanced Rules screen, you can perform basic arithmetic directly in your form without the need for a script. For example, you might want to find the total sum of 3 numeric fields. Written as a calculated script, it would look like this: ```plaintext var total = 0; total += float($numeric_field1$); total += float($numeric_field2$); total += float($numeric_field3$); return total; ``` With Advanced Rules, it can be set up using the variable builder screen (**Advanced Options** > **Advanced Rules** > **Calculations/Variables tab** > **Add Variable**): ![Variable builder screen showing a calculation set up in the Calculations/Variables tab](https://cdn.document360.io/dd260e4e-10bb-4b66-8fb3-5504c272b904/Images/Documentation/blobid1(5).png?sv=2026-02-06&spr=https&st=2026-10-30T07%3A57%3A13Z&se=2026-10-30T08%3A57%3A13Z&sr=c&sp=r&sig=QD0pLSh2tjXmQKbtIEaWw%2Fj%2FcvoAPVT80qL3PjC4s1M%3D) In this example, the variable, *Total Issue Count*, will automatically sum the 3 fields. Variables can be used in rule conditions and can also be referenced in other variable formulas.