quickbase_create_lookup_field
Create a lookup field in QuickBase to pull data from a related table by specifying parent and child table IDs, field references, and a label for the new field.
Instructions
Create a lookup field to pull data from a related table
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| childTableId | Yes | Child table ID where lookup field will be created | |
| lookupFieldLabel | Yes | Label for the new lookup field | |
| parentFieldId | Yes | Field ID in parent table to lookup | |
| parentTableId | Yes | Parent table ID to lookup from | |
| referenceFieldId | Yes | Reference field ID in child table |
Input Schema (JSON Schema)
{
"properties": {
"childTableId": {
"description": "Child table ID where lookup field will be created",
"type": "string"
},
"lookupFieldLabel": {
"description": "Label for the new lookup field",
"type": "string"
},
"parentFieldId": {
"description": "Field ID in parent table to lookup",
"type": "number"
},
"parentTableId": {
"description": "Parent table ID to lookup from",
"type": "string"
},
"referenceFieldId": {
"description": "Reference field ID in child table",
"type": "number"
}
},
"required": [
"childTableId",
"parentTableId",
"referenceFieldId",
"parentFieldId",
"lookupFieldLabel"
],
"type": "object"
}