Conditional Format Plug-in

Introduction

Adding this plug-in to your kintone app allows you to change text color, background color, and text size depending on the values—or "conditions"—in the given field. This displays in both the record list and record detail views.

Record list view with conditional formatting

Record details view with conditional formatting

Installing the plug-in

Add the latest version of the conditional format plug-in to your app. Refer to kintone help for information about how to install a plug-in.
Adding a plug-in

Setting up the form

To set up the app form, use the following fields:

Format condition field

Choose which fields to evaluate. To evaluate strings and numbers, use "Text conditional format." To evaluate dates, use "Date conditional format." You can choose from the following field types:

• Text Format Conditions:
  • String (single-line)
  • Numeric value
  • Calculation
  • Radio button
  • Drop down
  • Record number
  • String (multi-line)
  • Checkbox
  • Multi-choice
  • Status (Process management) (*Reflects the record list window only)
  
  
• Date Format Conditions:
  
  • Date
  • Date and time
  • Created on
  • Updated on
  
  

Format target field

Choose the field that should have the formatting applied to it. It can be the same field you are evaluating or a different one. All the fields listed in the "Format condition field" can be selected.

Configuring the conditions

1. From the app management window, open Settings > Plug-in and click the gear to access conditional format settings.
2. Set up each field you want to apply formatting to.

Conditional formatting options

Note: Options in bold were are part of the 3/31/2017 update.

3. Click Save.
   Note: If required fields are missing when you click Save, the invalid configuration is deleted.
4. Click Finish Setting to see the new formatting applied to your app.

Using the plug-in

1. Add or update a record.
2. The format of the target field will be changed in the record list window and record details window depending on the conditions you set.

Downloading the plug-in

Packaged plug-in

conditionformat2_plugin_v3.2.2.zip

Updates

Restrictions

• Not compatible with IE8.
• Cannot be used on the smartphone.
• After editing a record, the conditional format will not display. Update the window to redisplay the format change.
• If multiple conditions apply, the lower line takes precedence. Date condition formatting takes precedence over string condition formatting.
• Conditional formatting is only supported for lists in table format. It may not work for lists in calendar format or customized format.

Notes

• Conditional formatting is not guaranteed.
• Support is not provided for this plug-in.
• This plug-in performs DOM manipulation to change field formatting. The implementation may be affected by updates. Please use caution when using this sample as a reference.