quickbase_create_advanced_relationship
Define and establish table relationships in QuickBase, automatically creating lookup fields between parent and child tables to streamline data connections and enhance database structure.
Instructions
Create a comprehensive table relationship with automatic lookup fields
Input Schema
Name | Required | Description | Default |
---|---|---|---|
childTableId | Yes | Child table ID | |
lookupFields | No | Lookup fields to create automatically | |
parentTableId | Yes | Parent table ID | |
referenceFieldLabel | Yes | Label for the reference field to create | |
relationshipType | No | Type of relationship | one-to-many |
Input Schema (JSON Schema)
{
"properties": {
"childTableId": {
"description": "Child table ID",
"type": "string"
},
"lookupFields": {
"description": "Lookup fields to create automatically",
"items": {
"properties": {
"childFieldLabel": {
"description": "Label for lookup field in child table",
"type": "string"
},
"parentFieldId": {
"description": "Field ID in parent table to lookup",
"type": "number"
}
},
"required": [
"parentFieldId",
"childFieldLabel"
],
"type": "object"
},
"type": "array"
},
"parentTableId": {
"description": "Parent table ID",
"type": "string"
},
"referenceFieldLabel": {
"description": "Label for the reference field to create",
"type": "string"
},
"relationshipType": {
"default": "one-to-many",
"description": "Type of relationship",
"enum": [
"one-to-many",
"many-to-many"
],
"type": "string"
}
},
"required": [
"parentTableId",
"childTableId",
"referenceFieldLabel"
],
"type": "object"
}