Field Type Descriptions

Within an app form, there are 23 field types that the user can configure, and 5 which will auto-populate. Below are the descriptions and details of each of these fields.

Field Types

Labels

  • Labels contains multiple lines of formatted text. Labels only appear when a user clicks into an individual record. Labels cannot be added as a column in a table. When the end user is editing a record once the settings have been applied, the end user will not be able to edit the label within the record itself. Rich text functionality is available for labels. Labels are counted within the field limit. 
  • Field Settings: 
    • Rich Text - Type text to be displayed on the form.

Text(single-line)

  • This field can be used to capture any data in the form of text. The field name can be hidden, but the name can still be used for list views, filters, and graphs. The other settings available are – toggling field requirement, prohibiting duplicate values, setting character limits, and providing a default value. In addition, single-line text can be used for calculations and text combinations. See Automatic Calculation.
  • Field Entry Limit: 
    • If you set Prohibit Duplicate Values, the number of characters will be limited to 64.
  • Field Settings: 
    • Field Name - Specifies the header for the entry line. 
    • Hide Field Name - If checked, hides the field name from the record screen.
    • Calculate Automatically - Calculated/converted values are automatically entered in reference to the values in other fields. You will need to specify the formula if you choose to use this feature. For more information, see Automatic Calculation
    • Required Field - If checked, a value is required to be entered. 
    • Prohibit Duplicate Values - If checked, this prevents users from entering a duplicate value between multiple records.
    • Number of Characters - Specifies the minimum and/or the maximum number of characters. 
    • Default Value - Set the default value. Unless changed, this value will populate in this field for every newly created record. 
    • Field Code - Used for the Automatic Calculation feature. The system will automatically set the field code if it is not specified. 

Rich text

  • Rich text fields provide an area for users to add multiple lines of rich text. The rich text will appear in an individual record. If the rich text is added to a list view, the contents will appear, but the rich text will not.
  • Field Entry Limit:
    • 0 - 10,000 characters
      • Please note, HTML tag characters are included in the 10,000 max.
  • Field Settings:
    • Field Name - Specifies the header for the entry line. 
    • Hide Field Name - If checked, hides the field name from the record screen.
    • Required Field - If checked, a value is required to be entered.
    • Default Value - Set the default value. Unless changed, this value will populate in this field for every newly created record.
    • Field Code - Used for the Automatic Calculation feature. The system will automatically set the field code if it is not specified.

Text Area (multi-line)

  • This field type allows users to enter multiple lines of plain unformatted text. 
  • Field Settings: 
    • Field Name - Specifies the header for the entry line. 
    • Hide Field Name - If checked, hides the field name from the record screen.
    • Required Field - If checked, a value is required to be entered.
    • Default Value - Set the default value. Unless changed, this value will populate in this field for every newly created record.
    • Field Code - Used for the Automatic Calculation feature. The system will automatically set the field code if it is not specified.

Number

  • Users can enter an integer or decimal number.You can specify a prefix (e.g. $) or suffix (e.g. USD) in this field to indicate currency.
  • How is this different from a Text field? 
    • Values can be displayed with a thousands separator.
    • Entry range can be specified.
    • Data can be filtered and sorted with the filter feature using the conditions "Value greater than" and "Value less than"
    • It is not subjected to a full-text search.
  • Field Entry Limit: 
    • The number of digits that can be entered is restricted as follows depending on the setting of "total number of digits" and "number of digits of fraction part" in the Advanced Settings of the application.
      • The integer part of a numerical value is limited by the number of digits obtained by subtracting the value of "number of digits of decimal part" from the value of "total number of digits". You can specify an integer from 1 to 30 for "total number of digits" and an integer from 0 to 10 for "number of digits in decimal part". By default, up to 12 digits can be entered for the integer part of a number.
      • The fractional part of the decimal part number is processed with the number of digits specified in "Number of digits in decimal part". How to process is specified by "Rounding method". In the initial setting, the fifth digit after the decimal part is treated as "fractional number of nearest even number" as a fraction.
  • Field Settings: 
    • Field Name - Specifies the header for the entry line. 
    • Hide Field Name - If checked, hides the field name from the record screen.
    • Use thousands separators - If checked, it will display with a thousands separator.  
    • Required Field - If checked, a value is required to be entered. 
    • Prohibit Duplicate Values - If checked, this prevents users from entering a duplicate value between multiple records.
    • Limits of Value - Specifies the minimum and/or the maximum number of integers.  
    • Default Value - Set the default value. Unless changed, this value will populate in this field for every newly created record. 
    • Number of Decimal Places - Specifies the number of digits after the decimal point that will display. The decimal part that exceeds the specified number of digits will be rounded down.
      • Eg. When "2" is set: 1 is displayed as 1.00 and 1.007 is displayed as 1.00.
    • Currency - Specifies a unit symbol to be prefixed or suffixed to the field, such as "$" or "meter". Unit Symbols will be displayed on the form, from the Record List screen, and in History.
    • Field Code - Used for the Automatic Calculation feature. The system will automatically set the field code if it is not specified.

Calculated

  • This field type allows the user to have automatic calculations derived from other fields in the same record. See Automatic Calculation for details on configuring.
  • Field Entry Limit: 
    • The number of digits that can be entered is restricted as follows depending on the setting of "total number of digits" and "number of digits of fraction part" in the Advanced Settings of the application.
      • The integer part of a numerical value is limited by the number of digits obtained by subtracting the value of "number of digits of decimal part" from the value of "total number of digits". You can specify an integer from 1 to 30 for "total number of digits" and an integer from 0 to 10 for "number of digits in decimal part". By default, up to 12 digits can be entered for the integer part of a number.
      • The Fractional part of the decimal part number is processed with the number of digits specified in "Number of digits in decimal part". How to process is specified by "Rounding method". In the initial setting, the fifth digit after the decimal part is treated as "fractional number of nearest even number" as a fraction.
  • Field Settings: 
    • Field Name - Specifies the header for the entry line. 
    • Hide Field Name - If checked, hides the field name from the record screen.
    • Formula - A value calculated or formatted from the values of other fields in the record can be filled automatically. For more details on the formula format, see Automatic Calculation
    • Hide Formula - If checked, the formula will be hidden from the form.
    • Show As - Select the display format of the calculated result. 
    • Number of Decimal Places - Specifies the number of digits after the decimal point that will display. The decimal part that exceeds the specified number of digits will be rounded down.
      • Eg. When "2" is set: 1 is displayed as 1.00 and 1.007 is displayed as 1.00.
    • Currency - Specifies a unit symbol to be prefixed or suffixed to the field, such as "$" or "meter". Unit Symbols will be displayed on the form, from the Record List screen, and in History.
    • Field Code - Used for the Automatic Calculation feature. The system will automatically set the field code if it is not specified.

Radio Button

  • This field type is a set of items with option buttons, allowing users to select one. 
  • Field Entry Limit:
    • The maximum number of characters per option is 128. You can configure up to 1,000 options.
  • Field Settings: 
    • Field Name - Specifies the header for the entry line. 
    • Hide Field Name - If checked, hides the field name from the record screen.
    • Options - Configure the different options. Drag and drop with the arrow to change the options display order.
    • Layout - Specifies the option layout to be displayed horizontally or vertically. When the app is used on a smartphone, regardless of this setting, options will display vertically.  
    • Default Value - Set the default value. Unless changed, this value will populate in this field for every newly created record.
    • Field Code - Used for the Automatic Calculation feature. The system will automatically set the field code if it is not specified.

Check box

  • This field type is similar in structure to the Radio Button field type, but it allows users to select multiple options.
  • Field Entry Limit: 
    • The maximum number of characters per option is 128. You can configure up to 1,000 options. 
  • Field Settings: 
    • Field Name - Specifies the header for the entry line. 
    • Hide Field Name - If checked, hides the field name from the record screen.
    • Required Field - If checked, a value is required to be entered.
    • Options - Configure the different options. Drag and drop with the arrow to change the options display order.
    • Layout - Specifies the option layout to be displayed horizontally or vertically. When the app is used on a smartphone, regardless of this setting, options will display vertically.  
    • Field Code - Used for the Automatic Calculation feature. The system will automatically set the field code if it is not specified.

Multi-choice 

  • Vertical list of items, where users can select one or more items.
  • Field Entry Limit: 
    • The maximum number of characters per option is 128. You can configure up to 1,000 options.
  • Field Settings: 
    • Field Name - Specifies the header for the entry line. 
    • Hide Field Name - If checked, hides the field name from the record screen.
    • Required Field - If checked, a value is required to be entered.
    • Options - Configure the different options. Drag and drop with the arrow to change the options display order.
    • Field Code - Used for the Automatic Calculation feature. The system will automatically set the field code if it is not specified.

Drop-down

  • This field type allows users to select a single choice from a drop-down menu. 
  • Field Entry Limit: 
    • The maximum number of characters per option is 128. You can configure up to 1,000 options.
  • Field Settings: 
    • Field Name - Specifies the header for the entry line. 
    • Hide Field Name - If checked, hides the field name from the record screen.
    • Required Field - If checked, a value is required to be entered.
    • Options - Configure the different options. Drag and drop with the arrow to change the options display order.
    • Default Value - Set the default value. Unless changed, this value will populate in this field for every newly created record.
    • Field Code - Used for the Automatic Calculation feature. The system will automatically set the field code if it is not specified.

drop_down.png

Date

  • This field type captures dates. For input, the user can select from a calendar view or input a date. Regardless of the time zone setting for each user, an identical date is displayed for all users. 
  • Field Entry Limit: 
    • You can specify dates from January 1, 2000 to December 31, 9999.
  • Field Settings:
    • Field Name - Specifies the header for the entry line. 
    • Hide Field Name - If checked, hides the field name from the record screen.  
    • Required Field - If checked, a value is required to be entered. 
    • Prohibit Duplicate Values - If checked, this prevents users from entering a duplicate value between multiple records.
    • Default Value - Set the default value. Unless changed, this value will populate in this field for every newly created record.
      • If "Default to the record creation date." is checked, the field will auto-fill to the records create date when adding a new record. 
    • Field Code - Used for the Automatic Calculation feature. The system will automatically set the field code if it is not specified.

Time

  • This field type captures time input in 12-hour format. The user can select times that are thirty minute increments or enter in time in the 12-hour format. Regardless of the time zone setting for each user, an identical date is displayed for all users. 
  • Field Settings:
    • Field Name - Specifies the header for the entry line. 
    • Hide Field Name - If checked, hides the field name from the record screen.  
    • Required Field - If checked, a value is required to be entered. 
    • Default Value - Set the default value. Unless changed, this value will populate in this field for every newly created record.
      • If "Default to the record creation time." is checked, the field will auto-fill to the records create time when adding a new record. 
    • Field Code - Used for the Automatic Calculation feature. The system will automatically set the field code if it is not specified.

Date and time

  • This field type is simply a combination of the Date and Time field types above, providing a field to capture both data types. The entered date and time is displayed according to the time zone setting for each user. 
  • Field Entry Limit: 
    • You can specify the date and time from 00:00 on January 1, 2000 to 23:30 on December 31, 9999.
  • Field Settings:
    • Field Name - Specifies the header for the entry line. 
    • Hide Field Name - If checked, hides the field name from the record screen.  
    • Required Field - If checked, a value is required to be entered. 
    • Prohibit Duplicate Values - If checked, this prevents users from entering a duplicate value between multiple records.
    • Default Value - Set the default value. Unless changed, this value will populate in this field for every newly created record.
      • If "Default to the record creation date and time." is checked, the field will auto-fill to the records create date and time when adding a new record. 
    • Field Code - Used for the Automatic Calculation feature. The system will automatically set the field code if it is not specified.

Attachment

  • Attachment fields allow users to add files to a record, with a maximum of 1 GB. You can add multiple attachments per Attachment field, as long as they are under the data limit.
  • To attach files, click Browse and select the files. You can drag and drop files you want to attach into Browse if you are using Google Chrome, Mozilla FireFox, or Mac Safari.
  • Field Entry Limit: 
    • Up to 1 GB of files can be attached. 
    • There is no limit to the number of files that can be attached. 
    • The thumbnail displayed when attaching an image file may not be displayed if the image file is too large. To display the thumbnail you will need to reduce the size of the image file.
  • Field Settings:
    • Field Name - Specifies the header for the entry line. 
    • Hide Field Name - If checked, hides the field name from the record screen.  
    • Required Field - If checked, a value is required to be entered. 
    • Thumbnail Size - Selects the size of the thumbnail that is displayed when an image file is attached. 
    • Field Code - Used for the Automatic Calculation feature. The system will automatically set the field code if it is not specified.

Link

  • Create a link to a URL, telephone number or e-mail address input by a user. Once the type is selected, it cannot be changed for that particular field. 
  • Field Entry Limit: 
    • URL
      • You can only enter addresses beginning with "http://" or "https://"
      • Characters that can be used - Uppercase/lowercase alphabet, Arabic numerals, specific symbols: _.! ~ * '(): @ & = + $,;? / #%  (some fields may not be used depending on the part of an address)
      • If you set Prohibit Duplicate Values, the number of characters will be limited to 64.
    • Telephone Number
      • If you set Prohibit Duplicate Values, the number of characters will be limited to 64.
    • Email Address
      • Must be in the format (local part)@(domain) eg. user@example.com
      •  The local part can be a maximum of 64 characters. The following characters can be used - Uppercase/lowercase alphabet, Arabic numerals, specific symbols: :! # $ '% & * + / =? ^ _- `{} | ~ 
      • The following characters can be used for domain - Uppercase/lowercase alphabet, Arabic numerals, specific symbols: .-
      • If you set Prohibit Duplicate Values, the number of characters will be limited to 64.
  • Field Settings:
    • Field Name - Specifies the header for the entry line. 
    • Hide Field Name - If checked, hides the field name from the record screen.  
    • Required Field - If checked, a value is required to be entered. 
    • Prohibit Duplicate Values - If checked, this prevents users from entering a duplicate value between multiple records.
    • Type - Choose one of the following:
      • URL - Places a text field for entering a website address. Click the link to access the linked website.
      • Telephone Number - Places a text field for entering a telephone number. Click the link to call the number by using IP phone software, such as Skype.
      • Email Address - Places a text field for entering an email address. Click the ink to send email by using email software, such as Microsoft Outlook. 
    • Number of Characters - Specifies the minimum and/or the maximum number of characters.
    • Default Value - Set the default value. Unless changed, this value will populate in this field for every newly created record.
    • Field Code - Used for the Automatic Calculation feature. The system will automatically set the field code if it is not specified.

User selection

  • This field type allows users to search and select other users (or themselves) to add as a data point. The information is pulled from the subdomain, which all users are added to. Users can select preset users to limit the selection to one or a few users. 
  • Field Settings:
    • Field Name - Specifies the header for the entry line. 
    • Hide Field Name - If checked, hides the field name from the record screen.  
    • Required Field - If checked, a value is required to be entered.
    • Preset Users - Specifies users that will be displayed in the User Selection. If this option is not specified, all users will be displayed in the User Selection. 
    • Default Value - Set the default value. Unless changed, this value will populate in this field for every newly created record.
    • Field Code - Used for the Automatic Calculation feature. The system will automatically set the field code if it is not specified.

Department selection

  • This field type mirrors the User selection field type, with the difference being the selection of different departments created in the subdomain. 
  • Field Settings:
    • Field Name - Specifies the header for the entry line. 
    • Hide Field Name - If checked, hides the field name from the record screen.  
    • Required Field - If checked, a value is required to be entered.
    • Preset Departments - Specifies groups that will be displayed in the Department Selection. If this option is not specified, all departments will be displayed in the Department Selection. 
    • Default Value - Set the default value. Unless changed, this value will populate in this field for every newly created record.
    • Field Code - Used for the Automatic Calculation feature. The system will automatically set the field code if it is not specified.

Group selection

  • This field type mirrors the User selection and Department selection field types, with the difference being the selection of different groups created in the subdomain. 
  • Field Settings:
    • Field Name - Specifies the header for the entry line. 
    • Hide Field Name - If checked, hides the field name from the record screen.  
    • Required Field - If checked, a value is required to be entered.
    • Preset Groups - Specifies groups that will be displayed in the Group Selection. If this option is not specified, all groups will be displayed in the Group Selection. 
    • Default Value - Set the default value. Unless changed, this value will populate in this field for every newly created record.
    • Field Code - Used for the Automatic Calculation feature. The system will automatically set the field code if it is not specified.

Related Records

  • Displays related fields from specified records in a source app. See Configuring a Related Records Field.
  • Field Settings:
    • Field Name - Specifies the header for the entry line. 
    • Hide Field Name - If checked, hides the field name from the record screen. 
    • Datasource App - Specifies the app to pull information from.
    • Fetch Criteria - Selects a field from this app and a field from the datasource app. If both of the fields match, the information specified in Datasource App Fields to Display will display.   
    • Filter - Set a filter on the records that are being displayed. 
    • Datasource App Fields to Display - Selects the fields from the Datasource App that will be displayed. 
    • Display Order - Specifies the conditions for sorting records. 
    • Max Records to Display at a Time - Select the maximum number of records to display at a time. Choose from 5, 10, 20, or 30.
    • Field Code - Used for the Automatic Calculation feature. The system will automatically set the field code if it is not specified.

Lookup

  • Specify source app and other settings to create a lookup field where users can select from fields in another app. See Configuring a Lookup Field.
  • Field Settings:
    • Field Name - Specifies the header for the entry line. 
    • Hide Field Name - If checked, hides the field name from the record screen.
    • Required Field - If checked, a value is required to be entered. 
    • Datasource App - Specifies the app of the lookup source.
    • Key Field - Specifies the field that is used for the data search. 
    • Field Mappings - Maps the field in the app with the lookup source and the field of a data destination field in the current app. 
    • Fields Shown in Lookup Picker - Specifies the fields displayed when an app user is selecting a data source field. Use the arrow icon to drag and drop the fields in a specific order.
    • Filter - Filters and sort records that are displayed when selecting a data source field. Only the records that match the conditions specified here are displayed as the options in the source field.
    • Sort by - Specifies the order of records that are displayed when selecting a data source field.
    • Field Code - Used for the Automatic Calculation feature. The system will automatically set the field code if it is not specified.

Blank space

  • This field type provides a way to make the user interface of the form look cleaner with clear separation. Size of the space can be adjusted. 
  • Field Settings:
    • Element ID - Enter an ID to use the blank space field in Javascript or CSS customization for the app. 
      • Up to 64 characters beginning with an alphabetic character are allowed for element ID. The following characters can be used - Uppercase/lowercase alphabet, Arabic numbers, specific symbols: -_:.

Border

  • Borders provide cleaner separation and design, particularly with different sections in the form. 

Field group

  • Drag fields to this object to create a group of fields on the form. This allows separation of specific fields from other fields on the form. 
  • Field Settings:
    • Field Name - Specifies the header for the entry line. 
    • Hide Field Name - If checked, hides the field name from the record screen.
    • Default Value - If "Show fields in this group" is checked, the fields in this group will display on the form. 
    • Field Code - Used for the Automatic Calculation feature. The system will automatically set the field code if it is not specified.

Record number

  • This section displays a number that is automatically assigned to the record and not overlapped with other records. This field is automatically entered and the value cannot be edited.
  • For an app that is set with an app code, the record number is a combination of an app code and numbers. Example: "example-1" for an app with the app code "example". In kintone apps or spaces, any record number that includes an app code becomes a link to a corresponding record. See Setting the App code in Misc App Settings.
  • Field Settings:
    • Field Name - Specifies the header for the entry line. 
    • Hide Field Name - If checked, hides the field name from the record screen.
    • Field Code - Used for the Automatic Calculation feature. The system will automatically set the field code if it is not specified.

Created by

  • This will display the user who created the record. This field is automatically entered. 
    • Values for this field can only be edited by API's. To edit values, you will need admin privileges for the app. 
  • Field Settings:
    • Field Name - Specifies the header for the entry line. 
    • Hide Field Name - If checked, hides the field name from the record screen.
    • Field Code - Used for the Automatic Calculation feature. The system will automatically set the field code if it is not specified.

Created datetime

  • This will display the created date and time of the record. This field is automatically entered. 
    • Values for this field can only be edited by API's. To edit values, you will need admin privileges for the app. 
  • Field Settings:
    • Field Name - Specifies the header for the entry line. 
    • Hide Field Name - If checked, hides the field name from the record screen.
    • Field Code - Used for the Automatic Calculation feature. The system will automatically set the field code if it is not specified.

Updated by

  • This will display the user who updated the record. This field is automatically entered. 
    • Values for this field can only be edited by API's. To edit values, you will need admin privileges for the app. 
  • Field Settings:
    • Field Name - Specifies the header for the entry line. 
    • Hide Field Name - If checked, hides the field name from the record screen.
    • Field Code - Used for the Automatic Calculation feature. The system will automatically set the field code if it is not specified.

Updated datetime

  • This will display the updated date and time of the record. This field is automatically entered. 
    • Values for this field can only be edited by API's. To edit values, you will need admin privileges for the app. 
  • Field Settings:
    • Field Name - Specifies the header for the entry line. 
    • Hide Field Name - If checked, hides the field name from the record screen.
    • Field Code - Used for the Automatic Calculation feature. The system will automatically set the field code if it is not specified.

FAQ

What is a Field Code? 

  • A Field Code is a text string used to identify a field. It is used for Automatic Calculation and API's. Although the field code is automatically set for each field, you can change it to any value within 128 characters. However, you can't specify a value that overlaps with a code in another field in the app.
    • Character restrictions: 
      • The only half-width symbol you can use is "_" (underscore)
      • The full-width symbols you can use are:
        • Currency symbols
        • ・ (centered dot)
        • _ (underscore)
      • The field code can't start with a number. If the field code begins with a number, an underscore symbol is automatically prefixed to the field code.
      • The following strings can't be used for field codes:
        • Record_number
        • Created_by
        • Updated_by
        • Updated_datetime
        • Created_datetime
        • Status
        • Assignee
        • __ROOT__
    • How to Check or Set Field Codes
      • From within an App, click the gear wheel icon to enter App Settings.
      • From the Form tab, hover your cursor over the field you'd like to set the Field Code for and click the gear wheel to access the field settings. 
      • Under Field Code, click the pencil icon to edit the code and click Save
Was this article helpful?
5 out of 6 found this helpful

Comments

0 comments

Please sign in to leave a comment.