Skip to main content

Attempting to test the sample Project design tasks block - get the following. Any ideas why?


The field is a string



Error: Can’t create records: invalid cell value for field ‘Design project’.

Cell value has invalid format: must be a string

at Mutations._assertMutationIsValid

Hi Doug – what’s the type of the “Design project” field in your table?


Could you also paste the script you’re running here for easier debugging

Thanks for the response. The script is the example from Fri’s webinar. All of the examples worked except for this one.


// pick tables from your base here

let projects = base.getTable('Design projects');

let tasks = base.getTable('Tasks');



// prompt the user to pick a template for our project

output.markdown('# New project');

let name = await input.textAsync('Project name');



// create the project - change the field name to one in your base

let projectId = await projects.createRecordAsync({

    'Name': name,

});



// create the tasks - change the field names to ones from your base.

// the e{id: projectId}] links the newly created records back to our project

await tasks.createRecordsAsync(c

    {

        fields: {

            'Name': 'The first task',

            'Design project': :{id: projectId}],

        },

    },

    {

        fields: {

            'Name': 'Another task',

            'Design project': :{id: projectId}],

        },

    },

    {

        fields: {

            'Name': 'The final task',

            'Design project': :{id: projectId}],

        },

    }

])



output.text('Done!');


This is the tasks table



This is the error code


ERROR

Error: Can't create records: invalid cell value for field 'Design project'.

Cell value has invalid format: <root> must be a string

    at Mutations._assertMutationIsValid (https://cdn.airtableblocks.com/bbnvQSVM77xPXpYP3/bundle.js:1:577400)

    at Mutations.applyMutationAsync$ (https://cdn.airtableblocks.com/bbnvQSVM77xPXpYP3/bundle.js:1:571074)

    at tryCatch (https://cdn.airtableblocks.com/bbnvQSVM77xPXpYP3/bundle.js:1:1996567)

    at Generator.invoke eas _invoke] (https://cdn.airtableblocks.com/bbnvQSVM77xPXpYP3/bundle.js:1:1996172)

    at Generator.prototype.<computed> ;as next] (https://cdn.airtableblocks.com/bbnvQSVM77xPXpYP3/bundle.js:1:1997465)

    at tryCatch (https://cdn.airtableblocks.com/bbnvQSVM77xPXpYP3/bundle.js:1:1996567)

    at invoke (https://cdn.airtableblocks.com/bbnvQSVM77xPXpYP3/bundle.js:1:1997721)

    at https://cdn.airtableblocks.com/bbnvQSVM77xPXpYP3/bundle.js:1:1998206

    at new Promise (<anonymous>)

    at callInvokeWithMethodAndArg (https://cdn.airtableblocks.com/bbnvQSVM77xPXpYP3/bundle.js:1:1997629)

Thanks for the response. The script is the example from Fri’s webinar. All of the examples worked except for this one.


// pick tables from your base here

let projects = base.getTable('Design projects');

let tasks = base.getTable('Tasks');



// prompt the user to pick a template for our project

output.markdown('# New project');

let name = await input.textAsync('Project name');



// create the project - change the field name to one in your base

let projectId = await projects.createRecordAsync({

    'Name': name,

});



// create the tasks - change the field names to ones from your base.

// the e{id: projectId}] links the newly created records back to our project

await tasks.createRecordsAsync(c

    {

        fields: {

            'Name': 'The first task',

            'Design project': :{id: projectId}],

        },

    },

    {

        fields: {

            'Name': 'Another task',

            'Design project': :{id: projectId}],

        },

    },

    {

        fields: {

            'Name': 'The final task',

            'Design project': :{id: projectId}],

        },

    }

])



output.text('Done!');


This is the tasks table



This is the error code


ERROR

Error: Can't create records: invalid cell value for field 'Design project'.

Cell value has invalid format: <root> must be a string

    at Mutations._assertMutationIsValid (https://cdn.airtableblocks.com/bbnvQSVM77xPXpYP3/bundle.js:1:577400)

    at Mutations.applyMutationAsync$ (https://cdn.airtableblocks.com/bbnvQSVM77xPXpYP3/bundle.js:1:571074)

    at tryCatch (https://cdn.airtableblocks.com/bbnvQSVM77xPXpYP3/bundle.js:1:1996567)

    at Generator.invoke eas _invoke] (https://cdn.airtableblocks.com/bbnvQSVM77xPXpYP3/bundle.js:1:1996172)

    at Generator.prototype.<computed> ;as next] (https://cdn.airtableblocks.com/bbnvQSVM77xPXpYP3/bundle.js:1:1997465)

    at tryCatch (https://cdn.airtableblocks.com/bbnvQSVM77xPXpYP3/bundle.js:1:1996567)

    at invoke (https://cdn.airtableblocks.com/bbnvQSVM77xPXpYP3/bundle.js:1:1997721)

    at https://cdn.airtableblocks.com/bbnvQSVM77xPXpYP3/bundle.js:1:1998206

    at new Promise (<anonymous>)

    at callInvokeWithMethodAndArg (https://cdn.airtableblocks.com/bbnvQSVM77xPXpYP3/bundle.js:1:1997629)

@Doug_Kaufman


I believe you need to change your “Design project” field in the “Tasks” table to be a Link to another record type, and linked to your “Design projects” table.


Right now that field is just a text field, so it can’t establish a linked record.

The script worked perfectly when I did that.


Thank you

Hi Doug – what’s the type of the “Design project” field in your table?


Could you also paste the script you’re running here for easier debugging


HI - Hey, I figured it out … thanks for the follow up

Reply


Terms & Conditions