FormLayoutFields
Returns the individual layout elements used within an app's form, making it easier to analyze field placement, grouping, and user interface design.
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 FormLayoutFields WHERE AppId = 6 SELECT * FROM FormLayoutFields WHERE AppId = 6 AND Lang = 'en' SELECT * FROM FormLayoutFields WHERE AppId = 6 AND IsPreview = false
Columns
| Name | Type | References | Description |
| AppId | Integer | Identifier of the Kintone app whose form-layout field details are being retrieved. | |
| Code | String | Field code that uniquely identifies the field placed within the form layout. | |
| Type | String | Type of field represented in the layout, determining how the element behaves and is rendered in the form. | |
| ElementId | String | Element identifier assigned to a Space field, returned only when the layout element is a Space field. | |
| Label | Longvarchar | Text used as the label for a Label field, returned only when the element represents a Label component. | |
| Width | String | Width of the field in pixels, defining how much horizontal space the element occupies in the layout. | |
| Height | String | Total height of the field in pixels, including the space used by the field name. | |
| InnerHeight | String | Height of the field in pixels excluding the field name, showing the actual input or display area size. |
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 | |
| IsPreview | Boolean | Indicates whether to retrieve form-layout field details from the preview environment ('true') or from the live environment ('false'). The default value is 'true'. |