FormFields

Allows you to create, update, delete, and query app fields so you can manage an app's data model programmatically.

Select

The AppId column is required in the WHERE clause. The connector will use the Kintone APIs to filter the results by this column. By default, the connector will process other filters client-side within the connector.

For example, the following queries are processed server side:

SELECT * FROM FormFields WHERE AppId = 6
SELECT * FROM FormFields WHERE AppId = 6 AND Lang = 'en'
SELECT * FROM FormFields WHERE AppId = 6 AND IsPreview = false

Insert

The AppId, Type, Code and Label columns are required in the INSERT statement.

INSERT INTO FormFields (AppId, Type, Code, Label) VALUES (6, 'SINGLE_LINE_TEXT', 'Text__single_line_CRUD', 'Test')

Insertion can also be executed by providing the AppId column and Properties column as a json aggregate:

INSERT INTO FormFields (AppId, Properties) VALUES (6, '{"Text__single_line_TD":{"type":"SINGLE_LINE_TEXT","code":"Text__single_line_TD","label":"Test"}}')

The Kintone API supports Bulk Insert as well:

INSERT INTO FormFields#TEMP (AppId, Type, Code, Label) VALUES (6, 'SINGLE_LINE_TEXT', 'Text__single_line_temp1', 'Label1')
INSERT INTO FormFields#TEMP (AppId, Type, Code, Label) VALUES (6, 'SINGLE_LINE_TEXT', 'Text__single_line_temp2', 'Label2')
INSERT INTO FormFields (AppId, Type, Code, Label) SELECT AppId, Type, Code, Label FROM FormFields#TEMP

Update

You can update FormFields in two different ways, depending on your use case:

Method 1: Update Using the Properties Column, If you want to update multiple form field details at once, you can use the Properties column. This column expects a JSON object that includes field attributes like code, label, and type etc. In this Method AppId column is required in where clause.

UPDATE FormFields SET Properties = '{"Text__single_line_TT":{"code":"Text__single_line_PT","label":"text","type":"SINGLE_LINE_TEXT"}}' WHERE AppId = 6

Method 2: Update Individual Columns, You can also update individual fields like label, code etc. directly without using the Properties column but this will update one field at a time. In this Method both AppId and Code columns are required in where clause.

UPDATE FormFields SET label='text', code='Item_update', type='SINGLE_LINE_TEXT' where appId=444 and code='Item';

Delete

You need to specify the comma separated values of Code column that you want to delete. The AppId Column is required to delete the FormFields.

DELETE FROM FormFields WHERE Code = 'Text__single_line_CRUD, Text__single_line_TD' AND AppId = 6

Columns


Name	Type	ReadOnly	References	Description
AppId [KEY]	Integer	False		Identifier of the Kintone app whose form-field configuration is being retrieved or updated.
Code [KEY]	String	False		Field code that uniquely identifies the form field within the app's schema.
Enabled	String	True		Indicates whether specific field features are enabled or disabled, helping control how the field behaves in the form.
Label	String	False		Display name shown for the field in the form layout.
NoLabel	Boolean	False		Indicates whether the field's label should be hidden in the form to create a cleaner or more compact layout.
Type	String	False		Field type used in the form, determining the data format and behavior for the field.
Required	String	False		Specifies whether the field must contain a value before a record can be saved.
Unique	String	False		Specifies whether duplicate values are prohibited for the field, enforcing uniqueness across records.
MaxValue	String	False		Maximum number of characters allowed for the field, helping control input length.
MinValue	String	False		Minimum number of characters required for the field to ensure sufficient input.
MaxLength	String	False		Maximum number of digits allowed for numeric fields to control the size of accepted numeric inputs.
MinLength	String	False		Minimum number of digits required for numeric fields to enforce minimal numeric input.
DefaultValue	String	False		Default value applied to the field, returned as an array when the field supports multiple default selections.
DefaultNowValue	String	False		Indicates whether the field should automatically populate with the record creation date.
Options	String	False		Object containing the field's selectable options, such as labels and values used in dropdowns or radio buttons.
Align	String	False		Layout alignment applied to option-based fields, affecting how choices are displayed to users.
Expression	String	False		Formula expression used to calculate the field's value dynamically.
HideExpression	String	False		Indicates whether the field's formula expression should be hidden from users in the form.
Digit	String	False		Indicates whether thousands separators should be used when displaying numeric values.
ThumbnailSize	String	False		Pixel size of image thumbnails shown for fields that store images.
Protocol	String	False		Link-type configuration defining how URLs or link fields behave when opened.
Format	String	False		Display format applied to calculated fields, such as formatting numbers or dates for readability.
DisplayScale	String	False		Number of decimal places to display for numeric fields when rendering values.
Unit	String	False		Currency unit displayed with the field when the field represents financial values.
UnitPosition	String	False		Position of the currency unit relative to the numeric value in the field's display.
Entities	String	False		Array listing the preset users assigned to the field, often used for default assignees or user picker initialization.
ReferenceTable	String	False		Object containing configuration details for a Related Records field, defining how linked records are retrieved and displayed.
LookUp	String	False		Object containing lookup field settings that define how values are pulled from another app's record.
OpenGroup	String	False		Indicates whether the field group should be expanded by default when the form loads.
Fields	String	False		Object containing nested field definitions for table fields, using the same parameters as the Properties structure.
Revision	String	True		Revision number of the app settings, helping track updates to the form configuration.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Lang	String	Locale code used to retrieve form-field data in a specific language.
IsPreview	Boolean	Indicates whether to retrieve form-field settings from the preview environment ('true') or from the live environment ('false'). The default value is 'true'.
Properties	String	Value used only when performing an insert or update to supply modified field definitions.