Database Design Documentation
How can we help?
Full Site Search

Conditional Formatting

You can set Conditional Formatting to hide, or show fields, as well as set the color of a field label, field label background, field value, or field value, according to their value, or other fields' values. Your conditional formatting will also be applied on the embedded version of your form (currently only Database Form and Raw Embed).

Setting up Conditional Formatting

Our example form design is a shop that has different categories and subcategories of products, named "Product Category" and "Product Type" respectively. We have set the product types in cascaded selections, but don't want to display the "Product Type" field when it's empty (when the category "Special Collection" is selected).

Navigate to Conditional Formatting under Form Tools in the Design Mode.

Click New Rule to set options.

For our example, we would like to show the field "Product Type" if the "Product Category" is not "Special Collection".

Multiple formatting conditions can be set by clicking + button for the conditional formatting rule.

You can click on New Rule to add a new rule. In the example below, we would like to color the label background of the "Product Name" field when the "Special Collection" category is selected. To set the color, you can click on the color swatch next to the field.

Make sure you save your form design.

The rule we have just set works great to avoid confusion during form filling.

Note: Previously, our conditional formatting setting was called "Form Rules".

Other than the example mentioned above, you can also compare a date field with time parameters. This is extremely useful when you want to highlight entries based on the date field on the listing page.

Showing, hiding or locking action buttons

You can also show, hide or lock action buttons through conditional formatting. For instance, in "Purchase Requisition", you may hide the "Create PO" action button when the logged-in user is not "Procurement Officer" to prevent from inadvertently pressing the action button.

Read only

Your Ragic fields can also be set as read only with conditional formatting.

When a field simultaneously has conditional formatting for read-only based on rules and a field-level read-only setting, the conditional formatting takes precedence over the original field's read-only setting.

Not Empty

You can set the fields as Not Empty with conditional formatting. This can only be applied to independent fields on the Form Page.

If a field has been configured with the field-level Not Empty setting, it will remain Not Empty regardless of whether it meets the conditions for being Not Empty.

Hiding or showing field descriptions

You can also hide or show field descriptions through conditional formatting.

Hiding or showing value

You can also only hide or show field value with conditional formatting.

Top of Page Table of Contents

Start Ragic for Free

Sign up with Google