Feature for Assisting With Function and Field Code Entry

Article Number:040824

When you are entering a formula, you can use a feature that assists with entering functions and field codes.
The feature provides assistance in the following ways.

  • Displays suggestions for functions and field codes
  • Allows you to enter functions and field codes using Insert Function and Insert Field Code buttons
  • Displays information about functions and field codes that have been entered

For more details on each form of assistance, see the sections below.

Auto-suggest for functions and field codes

When you are entering a formula, functions and field codes containing the characters you have entered will appear as suggestions.
If you select a suggested function or field code, it will be entered in your formula.

Screenshot: The "Calculated Settings" screen. Functions containing the character entered are displayed as suggestions in the Formula setting.

"Insert Function" and "Insert Field Code" buttons

Insert Function and Insert Field Code buttons are added above the Formula input field.
Click Insert Function to display a list of functions that can be used with Kintone, or click Insert Field Code to show the field codes that exist in the app for which you are setting a formula. From the relevant list, select a function or field code to have it entered in the Formula input field.

Screenshot: The "Calculated Settings" screen. The "Insert Function" button has been clicked and a list of functions is displayed.

Display information about entered functions and field codes

If you move the text cursor to a field code or function in a formula that has been entered, information about the function or field code is displayed.

Screenshot: The "Calculated Settings" screen. The text cursor is moved to a field code entered in a formula and information about the field code is displayed.