Database Design Documentation
Database Design Documentation
You can set Conditional Formatting to hide, or show fields, adjust field colors based on their value or the values of other fields, lock Action Buttons, and more. Additionally, your Conditional Formatting will also be applied to the sheet's embedded form (currently only Database Form and Raw Embed).
See the following example: When a sheet contains various categories and subcategories of products, named "Product Category" and "Product Type" respectively. The product types are configured using Cascaded Selections, However, we don't want to display the "Product Type" field 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 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.
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.
After saving, you can test the set 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.
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.
You can set the fields 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.
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 already has a field-level Not Empty setting, it cannot be selected when setting Conditional Formatting.
You can also hide or show Field Descriptions through Conditional Formatting.
You can also only hide or show field values with Conditional Formatting.
1. Conditional Formatting for Form Pages and Listing Pages needs to be set separately.
2. Avoid duplicating field attributes between field properties and Conditional Formatting.
(a) If a field is set as Not Empty or Hidden, you cannot select the same field to be Not Empty or Hidden/Shown in Conditional Formatting settings.
(b) Manually setting a field as Not Empty or Hidden after Conditional Formatting has already designated it as Not Empty or Hidden under specific conditions will override the Conditional Formatting and automatically remove the setting.
(c) When a field is set as Read Only, Conditional Formatting takes precedence over field property settings. It is recommended to retain the Conditional Formatting settings and remove field properties.
For example: Apply Conditional Formatting to make the "Total Amount" field Read Only when the "Status" field of a quotation sheet is marked as "Completed". Even if you set the "Total Amount" field as Read Only, it can still be modified when the "Status" field is not "Completed". The Read Only status of the "Total Amount" field only applies when the "Status" field is marked as "Completed".
