FormLayoutFields
Query the available Form Layout Fields in kintone.
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 | The App ID of the kintone application. | |
| Code | String | The field code. | |
| Type | String | The type of field. | |
| ElementId | String | The element ID of the Space field. Only returned for Space fields. | |
| Label | String | The text set in the Label field. Only returned for Label fields. | |
| Width | String | The width of the field in pixels. | |
| Height | String | The height of the field in pixels, including the height of the field name. | |
| InnerHeight | String | The height of the field in pixels, excluding the height of the field name. |
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 | By setting this to False, you will be able to retrieve the Form Layout details of the live App. Default value is true. |