To “Calculate the average value of fields in table rows that meet the conditions”, as well as the “Do” for conditional aggregation such as “If the field value is a specific value,” you can compare whether the field value is “equal” to the value specified by the parameters.
Here, we will describe the rules for determining whether the field value and parameter value are “equal” in Customine. Please refer to here for size comparison.
On this page, we call the field’s value “Left Side” and the comparison value “Right Side.”
The comparison method changes depending on the field type on the Left Side.
Depending on the field type, the value of the field is not necessarily a string. On the other hand, since the right-side value is a string, the point is “how to compare something that is not a string with a string. "
| Left Side | Comparison Method |
|---|---|
| Text | First, compare them as numbers; if they do not match, compare them as strings. |
| Number | Compare the values as numbers. |
| Calculated | First, compare them as numbers; if they do not match, compare them as strings. |
| Text area | Compare the values as strings. |
| Rich text | If the right side is empty, compare the left side with “HTML representing empty." In other cases, compare values as strings. |
| Check box | Compare as a string array. |
| Radio button | Compare the values as strings. |
| Drop-down | Compare the values as strings. |
| Multi-choice | Compare as a string array. |
| Attachment | * Error due to non-support * |
| Link | Compare the values as strings. |
| Date | Compare the values as strings. |
| Time | Compare the values as strings. |
| Date and time | Compare the values as strings. |
| User selection | Compare as an array of code/names (guest/removal included) |
| Department selection | Compare as an array of code/names (guest/no removal) |
| Group selection | Compare as an array of code/names (guest/no removal) |
| Record number | Convert the left and right sides to numbers after removing the app code part, then compare them. |
| Created by / Updated by | Compare as code/name object (guest/removal included) |
| Created datetime / Updated datetime | Compare the values as strings. |
| Category | Compare as a string array. |
| Status | Compare the values as strings. |
| Assignee | Compare as an array of code/names (guest/removal included) |
Both the left and right sides can be checked for equality, ignoring full-width and half-width characters and uppercase and lowercase letters.
Internally, it converts to a numeric value and compares. If at least one of the left or right sides cannot be converted to a number, it is considered “not matching as a number.”
If the left side is an empty array and the right side is an empty string, it is judged to be “equal”; otherwise, it is “not equal.”
If the left side has one element, it compares that one element with the right side value “as a string.”
If the left side contains two or more elements, the array on the left is separated by commas and then “compared as strings” to the value on the right.
The “code/name object” referred to in this document combines code and name, like a user’s “login name/display name.” The following code meanings are defined:
When comparing field values of this type, the left-side code value and the right-side value are “compared as strings.” The name value is not compared.
If “guest/removal included” is indicated in the table above, the “guest/” part will be removed from both the left and right sides. This is a specification for easily comparing guest users on Kintone. For example, if the left-side code is “guest/test@r3it.com” and the right-side value is “test@r3it.com”, the left-side value will become “test@r3it.com” after removing “guest/”, so it will be judged as “equal”.
If the left side is an empty array and the right side is an empty string, it is judged to be “equal”; otherwise, it is “not equal.”
If the left side has one element, that one element is compared as a “code/name object.”
If the left side has two or more elements, it is judged as “not equal.”