Overview of field codes

Article number:040504

Field codes are strings used to specify fields in formulas and APIs.
Field codes are set to default values, but you can change them to any value you like.

Steps

This article describes how to check or change field codes.

  1. Click the App settings icon (the gear-shaped icon) at the upper right of the View screen.
    Screenshot: The "App settings" icon is highlighted

  2. On the App settings screen, click the Form tab.

  3. Hovering over the "Settings" icon (gear-shaped) in the upper right corner of the field for which you want to change the field code, click "Settings".
    Screenshot: "Field Settings" is highlighted for the field for which the field code is being changed

  4. In the field settings dialog, check the string in "Field code".
    If you want to change the field code, click the edit icon for "Field code" and enter the new field code.
    The field code must be between 1 and 128 characters.
    After entering the field code, click "Save" for "Field code".

    スクリーンショット:[計算の設定]ダイアログで[フィールドコード]が強調されている

  5. In the field settings dialog, click "Save".

  6. Click Save form at the upper left of the screen.

  7. Click Update app at the upper right of the screen.

  8. On the Update app dialog, click Update app.

Valid characters

This section explains the types of characters that can be used in field codes and the characters that will be converted during saving.

Available Types of Characters

The characters that can be used for field codes are as follows.

  • Hiragana
  • Katakana (half-width and full-width)
  • Kanji
  • Alphanumeric characters (half-width and full-width)
  • The following special characters:
    • Half-width underscore (_)
    • Full-width underscore (_)
    • Half-width middle dot (·)
    • Full-width middle dot (・)
    • Full-width currency symbols (e.g., $, ¥)

Symbols that are converted to "_"

If you enter any of the following half-width symbols, they will be converted to a half-width underscore ("_") when the field code is saved (only some of the symbols are listed).

@ + ~ # % & ' = | ^ * ; : ? ( ) [ ] { }

For example, if you enter "A&B" as a field code, it will be converted to "A_B".

Convert spaces

If a field code contains spaces (half-width or full-width), the spaces are converted as follows when the field code is saved:

  • If there are spaces before or after a field code, they will be deleted.
  • Other spaces: Converted to half-width underscore (_)

If an error message appears

If you enter a field code and click Save, you may see an error indicating that it contains invalid characters.Screenshot: Error message indicating that a field code contains invalid characters

Check the following items to make sure that the field code does not contain any invalid characters:

Notes on the "Field code" setting

This section describes the rules for setting field codes and the types of fields that require special handling.

Rules for the "Field code" setting

  • Duplicate field codes are not allowed within a form.
    If you set a field code that is already used for another field, the field code will be suffixed with an underscore (_) followed by a number (e.g., "string_0") when you save the settings.
  • The following strings cannot be set as field codes.
    • Status
    • Assignee
    • Categories
    • __ROOT__
    • not
  • If a field code begins with a number, a half-width underscore (_) is prefixed to the field code when you save the settings.

Field codes that require special treatment

The field codes for the following fields are assigned by default as the field names with underscores in place of spaces.

  • Record number
  • Created datetime
  • Updated datetime
  • Created by
  • Updated by

To use the field code of one of these fields for another field, you first need to change the originally assigned field code to a different value.
For detailed procedures, refer to the following section.
Use pre-assigned field codes in other fields

Note that if you change the field code of one of these fields, the modified field code will be saved even if the field is deleted from your app form.
When you place the field on your app form again, the field code that you set for it before it was deleted will be applied to it.

Use pre-assigned field codes in other fields

This section describes how to use preassigned field codes in other fields.

You cannot set a field code that is already used by another field in the form. Therefore, you need to change the field code of the original field first.
As an example, we will set the field code "Record number" for a "Text" field.

  1. Click the App settings icon (the gear-shaped icon) at the upper right of the View screen.
    Screenshot: The "App settings" icon is highlighted

  2. On the App settings screen, click the Form tab.

  3. Place the Record number field on the app form and change the field code to "Record_number_1".

  4. Place a Text field on the app form and change the field code to "Record_number".

  5. Click Save form.

  6. Delete the Record number field that you placed on the app form in Step 3.

You have now configured the field code of a "Text" field to "Record Number".