I am trying to create a table with linked records using a one-to-many relationship.
How would I create a Contacts table with a link to ContactPhones where a single Contact record is linked to multiple ContactPhones records?
Below is one of the things I have tried based on the base.createTableAsync and the FieldType documentation.
import { FieldType } from "@airtable/blocks/models";
import { useBase } from "@airtable/blocks/ui";
export async function createContactAirTables() {
const base = useBase();
if (!base.getTableByNameIfExists('ContactPhones_')){
await base.createTableAsync("ContactPhones_",
[
{name: 'Id', type: FieldType.SINGLE_LINE_TEXT},
{name: 'PhoneNumber', type: FieldType.SINGLE_LINE_TEXT}
]);
}
if (!base.getTableByNameIfExists('Contacts_')){
await base.createTableAsync("Contacts_",
[
{name: 'Id', type: FieldType.SINGLE_LINE_TEXT},
{name: 'BusinessName', type: FieldType.SINGLE_LINE_TEXT},
{name: 'ContactName', type: FieldType.SINGLE_LINE_TEXT},
{name: 'ContactPhones', type: FieldType.MULTIPLE_RECORD_LINKS,
options: {
linkedTableId: base.getTableByName('ContactPhones_').id
}
}
]);
}
};
This is the error I’m getting:
I got it working with this code:
Thise creates the tables and the proper linking fields and it all works perfect, however I keep seeing errors only when the tables are first created (this code is run when none of the tables exist).
Console log text:
[RADACTED]
liveapp-br.js:1 Error: Duplicate table name
at Object.l [as spawnError] (liveapp-br.js:1)
at e.<anonymous> (liveapp-br.js:1)
at s (liveapp-br.js:1)
at Generator._invoke (liveapp-br.js:1)
at Generator.forEach.e.<computed> [as next] (liveapp-br.js:1)
at _e (liveapp-br.js:1)
at i (liveapp-br.js:1)
at liveapp-br.js:1
at new Promise (<anonymous>)
at e.<anonymous> (liveapp-br.js:1) {applicationId: "appVTaxjt11yHcFQ6", blockId: "blkO713F5CgEpUh5a", blockInstallationId: "blitXm1PFuXJl5enq", err: {…}, message: "Error handling block-to-host method call: APPLY_MUTATION"}
Contacts.tsx:2 Uncaught (in promise) Error: Error: Duplicate table name
at https://static.airtable.com/js/by_sha/605ec711/block_frame-br.js:1:2550392
at https://static.airtable.com/js/by_sha/605ec711/block_frame-br.js:1:2549701
at r._wrapped (https://devblock---v-taxjt11y-hc-f-q6--abr0nxm.airtableblocks.com/__runFrame?blockId=blkO713F5CgEpUh5a&isDevelopment=1&shouldEnforceCspForDevelopmentApps=reportOnly:103:440)
Async gap:
at e.value (https://static.airtable.com/js/by_sha/605ec711/block_frame-br.js:1:2529449)
at Mutations.applyMutationAsync$ (https://localhost:9000/__runFrame/bundle.js:5551:73)
at tryCatch (https://localhost:9000/__runFrame/bundle.js:79991:40)
at Generator.invoke [as _invoke] (https://localhost:9000/__runFrame/bundle.js:80221:22)
at Generator.next (https://localhost:9000/__runFrame/bundle.js:80046:21)
at tryCatch (https://localhost:9000/__runFrame/bundle.js:79991:40)
at invoke (https://localhost:9000/__runFrame/bundle.js:80082:20)
at https://localhost:9000/__runFrame/bundle.js:80117:11
at new Promise (<anonymous>)
at callInvokeWithMethodAndArg (https://localhost:9000/__runFrame/bundle.js:80116:16)
(anonymous) @ block_frame-br.js:1
(anonymous) @ block_frame-br.js:1
r._wrapped @ __runFrame?blockId=blkO713F5CgEpUh5a&isDevelopment=1&shouldEnforceCspForDevelopmentApps=reportOnly:103
Promise.then (async)
[RADACTED]
Contacts.tsx:32 Uncaught (in promise) TypeError: Cannot read property 'id' of null
at _callee$ (Contacts.tsx:32)
at tryCatch (runtime.js:63)
at Generator.invoke [as _invoke] (runtime.js:293)
at Generator.next (runtime.js:118)
at asyncGeneratorStep (Contacts.tsx:2)
at _next (Contacts.tsx:2)
_callee$ @ Contacts.tsx:32
[RADACTED]
r._wrapped @ __runFrame?blockId=blkO713F5CgEpUh5a&isDevelopment=1&shouldEnforceCspForDevelopmentApps=reportOnly:103
error_utils.js:33 Uncaught (in promise) Error: Can't create field: invalid field config.
Failed schema validation: <root>.0.options.isReversed is missing, <root>.0.options.linkedTableId is missing, <root>.1.options.linkedTableId is missing, inverseLinkFieldId is not included in the <root>.1.options schema
at Mutations._assertMutationIsValid (mutations.js:475)
at Mutations.applyMutationAsync$ (mutations.js:113)
at tryCatch (runtime.js:63)
at Generator.invoke [as _invoke] (runtime.js:293)
at Generator.next (runtime.js:118)
at tryCatch (runtime.js:63)
at invoke (runtime.js:154)
at runtime.js:189
at new Promise (<anonymous>)
at callInvokeWithMethodAndArg (runtime.js:188)
spawnErrorWithOriginOmittedFromStackTrace @ error_utils.js:33
