quickbase_create_junction_table
Create a junction table to manage many-to-many relationships in QuickBase by linking two tables with customizable reference labels and optional additional fields.
Instructions
Create a junction table for many-to-many relationships
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| additionalFields | No | Additional fields for the junction table | |
| junctionTableName | Yes | Name for the junction table | |
| table1FieldLabel | Yes | Label for reference to first table | |
| table1Id | Yes | First table ID | |
| table2FieldLabel | Yes | Label for reference to second table | |
| table2Id | Yes | Second table ID |
Input Schema (JSON Schema)
{
"properties": {
"additionalFields": {
"description": "Additional fields for the junction table",
"items": {
"properties": {
"fieldType": {
"type": "string"
},
"label": {
"type": "string"
}
},
"type": "object"
},
"type": "array"
},
"junctionTableName": {
"description": "Name for the junction table",
"type": "string"
},
"table1FieldLabel": {
"description": "Label for reference to first table",
"type": "string"
},
"table1Id": {
"description": "First table ID",
"type": "string"
},
"table2FieldLabel": {
"description": "Label for reference to second table",
"type": "string"
},
"table2Id": {
"description": "Second table ID",
"type": "string"
}
},
"required": [
"junctionTableName",
"table1Id",
"table2Id",
"table1FieldLabel",
"table2FieldLabel"
],
"type": "object"
}