The Data Check command checks the field value based on the conditions set by the user.
Check if a value is entered in the required item "Product ID" field of the product master app.
Input Data
Command Settings
1. Select the behavior if a check error is detected. |
・Select the "Stop executing the data editing flow" option.
・Behavior when error is detected : Check all records even after error detection |
2. Select the data check error app that outputs the record information judged as an error. |
Select the data check error app. |
3. Set check items. |
Value Check |
(1) Select the target fields. |
(2) Set check items and conditions. |
Product ID |
Select the "Required check" option. |
Setting Screen
Execution Result
Execution Result (Error Record)
Check if the date in the Delivery Date field of the Shipment Management app is after the date in the Ship Date field.
Input Data
Command Settings
1. Select the behavior if a check error is detected. |
・Select the "Stop executing the data editing flow" option.
・Behavior when error is detected : Check all records even after error detection |
2. Select the data check error app that outputs the record information judged as an error. |
Select the data check error app. |
3. Set check items. |
Value Check |
(1) Select the target fields. |
(2) Set check items and conditions. |
Delivery Date |
Select the "Compare check" option.
- Compare conditions : ≧(greater than or equal to)
- Compare value : Select the "Select field" option and select the "Ship Date" field.
|
Setting Screen
Execution Result
Execution Result (Error Record)
Check if the value in the "Year" field of the budget management app is in the range of 2019-2021.
Input Data
Command Settings
1. Select the behavior if a check error is detected. |
・Select the "Stop executing the data editing flow" option.
・Behavior when error is detected : Check all records even after error detection |
2. Select the data check error app that outputs the record information judged as an error. |
Select the data error check app. |
3. Set check items. |
Value Check |
(1) Select the target fields. |
(2) Set check items and conditions. |
Year |
Select the "Value range check" option.
- Min value : Select the "Set value" option and set the value to "2019".
- Max value : Select the "Set value" option and set the value to "2021".
|
Setting Screen
Execution Result
Execution Result (Error Record)
Check if the value in the Customer ID field is in the format of 5 digits number.
Input Data
Command Settings
1. Select the behavior if a check error is detected. |
・Select the "Stop executing the data editing flow" option.
・Behavior when error is detected : Check all records even after error detection |
2. Select the data check error app that outputs the record information judged as an error. |
Select the data error check app. |
3. Set check items. |
Value check |
(1) Select the target fields. |
(2) Set check items and conditions. |
Postal Code |
Select the "Format check" option.
|
Setting Screen
Execution Result
Execution Result (Error Record)
Check if the value of the Product ID field exists in the Product ID field of the product master app.
Input Data
Product Master App
Command Settings
1. Select the behavior if a check error is detected. |
・Select the "Stop executing the data editing flow" option.
・Behavior when error is detected : Check all records even after error detection |
2. Select the data check error app that outputs the record information judged as an error. |
Select the data error check app. |
3. Set check items. |
Existence check |
(1) Select the target fields. |
(2) Set check items and conditions. |
Product ID |
Select the "Valid value check" option.
- Target App : Product Master
- Field : Product ID
- Filter : (No condition: all records)
|
Setting Screen
Execution Result
Execution Result (Error Record)
Check if the value of the Category field exists in the selection item of the Category field (dropdown) of the output app (Product Master App).
Input Data
Selection items in the Category field of the output app (product master app)
Command Settings
1. Select the behavior if a check error is detected. |
・Select the "Stop executing the data editing flow" option.
・Behavior when error is detected : Check all records even after error detection |
2. Select the data check error app that outputs the record information judged as an error. |
Select the data error check app. |
3. Set check items. |
Existence check |
(1) Select the target fields. |
(2) Set check items and conditions. |
Product ID |
Select the "Valid item check" option.
- Target App : Product Master
- Field : Category
|
Setting Screen
Execution Result
Execution Result (Error Record)
Check if the value of the Employeee field of Travel Expense Reimbursement app is the kintone user name that exists in the user management.
Input Data
Users registed in Users and System Adminstration
Command Settings
1. Select the behavior if a check error is detected. |
・Select the "Stop executing the data editing flow" option.
・Behavior when error is detected : Check all records even after error detection |
2. Select the data check error app that outputs the record information judged as an error. |
Select the data error check app. |
3. Set check items. |
Existence check |
(1) Select the target fields. |
(2) Set check items and conditions. |
Employee |
Select the "Valid user check" option.
|
Setting Screen
Execution Result
Execution Result (Error Record)
Check if only one of the two fields has a value using the XOR and ISBLANK functions.
Input Data
Command Settings
1. Select the behavior if a check error is detected. |
・Select the "Stop executing the data editing flow" option.
・Behavior when error is detected : Check all records even after error detection |
2. Select the data check error app that outputs the record information judged as an error. |
Select the data error check app. |
3. Set check items. |
Custom Check |
Set the check condition using formula. The formula must return a boolean value (TRUE/FALSE). |
Formula : =XOR(ISBLANK(Input 1),ISBLANK(Input 2)) |
Setting Screen
Execution Result
Execution Result (Error Record)