Skip to main content

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 eas _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 eas _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 eas _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

Your problem might be because you’re calling asynchronous actions outside of an asynchronous function.

Your problem might be because you’re calling asynchronous actions outside of an asynchronous function.



Yeah, I was calling createContactAirTables() from the main function body of the App so it was getting invoked on each table change causing numerous race conditions/collisions. I mapped the function call to a button and it cleared up all the errors I was seeing. Thanks!

Reply


Terms & Conditions