quickbase_create_field
Add a new field to a QuickBase table, specifying the field type, label, and attributes such as required or unique, to enhance data organization and structure.
Instructions
Create a new field in a table
Input Schema
Name | Required | Description | Default |
---|---|---|---|
choices | No | Choices for choice fields | |
fieldType | Yes | Type of field | |
formula | No | Formula for formula fields | |
label | Yes | Field label/name | |
lookupFieldId | No | Field ID for lookup fields | |
lookupTableId | No | Table ID for lookup fields | |
required | No | Whether field is required | |
tableId | Yes | Table ID to add field to | |
unique | No | Whether field must be unique |
Input Schema (JSON Schema)
{
"properties": {
"choices": {
"description": "Choices for choice fields",
"items": {
"type": "string"
},
"type": "array"
},
"fieldType": {
"description": "Type of field",
"enum": [
"text",
"text_choice",
"text_multiline",
"richtext",
"numeric",
"currency",
"percent",
"date",
"datetime",
"checkbox",
"email",
"phone",
"url",
"address",
"file",
"lookup",
"formula",
"reference"
],
"type": "string"
},
"formula": {
"description": "Formula for formula fields",
"type": "string"
},
"label": {
"description": "Field label/name",
"type": "string"
},
"lookupFieldId": {
"description": "Field ID for lookup fields",
"type": "number"
},
"lookupTableId": {
"description": "Table ID for lookup fields",
"type": "string"
},
"required": {
"default": false,
"description": "Whether field is required",
"type": "boolean"
},
"tableId": {
"description": "Table ID to add field to",
"type": "string"
},
"unique": {
"default": false,
"description": "Whether field must be unique",
"type": "boolean"
}
},
"required": [
"tableId",
"label",
"fieldType"
],
"type": "object"
}