Xross Mode / Feature Overview / Format
In This Topic
    In This Topic

    Set Format

    In order to set the formula, click the gear icon for the field you want to set the formula. You can also select the Format button on the Home tab of the ribbon area.

    Field Settings dialog is displayed after clicking the Format button. From the following three tabs, you can set the format the same way you would in Excel.

    Format Tab

    Font Tab

    Alignment Tab

    • The format you set isn't effective while entering data in a cell.
      For example, if you set the format displaying "Oct 20, 2017" in a Date field, the date is displayed as "2017-10-20" while entering it, and "Oct 20, 2017" is displayed after the entry is confirmed.
    • The settings in krewSheet aren't valid on the record editing page of Kintone.
    • The first Japanese year is displayed as the "first" year with krewSheet. By using the user-defined formatting, the first Reiwa year can be displayed as "1." (Example: R1/5/1)
    • Regarding the format of days such as "ddd" or "aaa," its display will change on krewSheet according to the language setting of the Kintone account (English: Wed, Japanese: 水). If you don't want to change the display according to the Kintone language setting, add locale ID to make it something like "[$-ja-JP]m/d(aaa)."

    Formattable Field Types

    Depending on the field type, the format might or might not be effective. The details are described below.

    Format Priority

    If you set the format in both the krewSheet settings and the Kintone form settings, the format setting in krewSheet has priority. To enable the format setting in Kintone, clear the one in krewSheet.

    Format setting page in kintone

    Clear Format

    To initialize the format of any selected field, move to the target field and click on Clear in the Home tab.

    To clear font effects (Bold, Italic, Underline, Strikethrough) for the selected field, click Clear on the Font tab of the Field Setting dialog.