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
WHERE 句ではAppId カラムが必須です。本製品 はKintone API を使用してこのカラムによる結果をフィルタリングします。デフォルトでは、本製品 はクライアント側で本製品 内で他のフィルタを処理します。
例えば、次のクエリはサーバー側で処理されます。
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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるデータを詳細に制御することができます。
| 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'. |