What is Conditional Formatting: A Free Add-On for your Kintone Experience

What is Conditional Formatting: A Free Add-On for your Kintone Experience 

Add-ons are packaged customization modules that Kintone users can install to their subdomains at the push of a button. We have multiple free add-ons available for our users, but in today’s blog post we’ll be taking a look at only one: a free add-on from Kintone Open Source called Conditional Formatting.

To learn about how to install add-ons, check out one of our previous past blog posts here. And you can view the full list of native Kintone plug-ins here.

Conditional Formatting

The Conditional Formatting add-on allows you to change the text color, background color, and text size of fields depending on the values of a specific field. This is a quick and easy way of adding an extra layer of organization to your fields.

To set up Conditional Formatting:

1. Verify which field-types this add-on can be applied to. Note that not all field-types can be used with this add-on.
   
   1. To evaluate strings and numbers, use the following "Text conditional format" field-types:
      - String (single-line)
      - Numeric value
      - Calculation
      - Radio button
      - Dropdown
      - Record number
      - String (multi-line)
      - Checkbox
      - Multi-choice
      - Status (Process management) (*Reflects the record list window only)
   2. To evaluate dates, use the following "Date conditional format" field-types:
      - Date
      - Date and time
      - Created on
      - Updated on
2. Adjust the following settings:
   1. Field with Condition: Choose the field to be evaluated. If the value in this field meets the conditions you set, the target field will change its formatting.
   2. Condition: This is the logical operator that will determine what relation the field with condition will have with its specified value.
   3. Value: Enter the value needed in the field with condition. This is the value that will cause the field to format to change.
   4. Field to Format: Once the conditions you have set are met, this is the target field that will have its font size, color, and background color changed.
3. Lastly, under Font Color, Background Color, Font Size, and Style, set how you want the field to format to be displayed with the change.
4. Save and Update App.

You can see the changes on the record list screen or when viewing a record. There are a handful of other free add-ons from Kintone Open Source, so feel free to test them out and see which work for you!

Check out the video below for more details!

Have further questions? Please email support@kintone.com.