Skip to main content

Hello!


My team uses airtable for our task tracking. We get new clients/shows all the time and many of them start off with the same tasks. I used one of the examples to help get me started on some basics! I would like to add another line under each field that allows me to assign a member of my team to a certain task. Does anyone know how to do this and/or if this is possible? This is what I have so far…


Thanks so much for your feedback on this!


`// pick tables from your base here


let tasks = base.getTable(‘Task’);

let projects = base.getTable(‘Performances’);

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

output.markdown(’# New Show’);

let name = await input.textAsync(‘Task’);

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

let projectId = await projects.createRecordAsync({

‘Performance’: name,

});

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

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

await tasks.createRecordsAsync(k

{

fields: {

‘Task’: ‘Pixel Check: TM Artist/Event’,

‘Show Name’: n{id: projectId}],

’Assigned To’:

},

])

output.text(‘Done!’);`

Hey @Shayda_Haddad,


To write to a single collaborator field, you need to pass in an object with the user id. You can get all of the collaborators for a base via base.activeCollaborators. One way to make this easier to consume is to construct a mapping:


let collaboratorIdByName = {};

for (let collaborator of base.activeCollaborators) {

    collaboratorIdByName[collaborator.name] = collaborator.id;

}

This object maps collaborator names to ids. You could also use collaborator.email as the key, especially if a base has multiple collaborators with the same name. Once you have this mapping, you can do the following:


await tasks.createRecordsAsync([

    {

        fields: {

            ‘Task’: ‘Pixel Check: TM Artist/Event’,

            ‘Show Name’: o{id: projectId}],

            ’Assigned To’: {id: collaboratorIdByNameaname]},

        },

    },

])

You can read more about the cell formats and field options here: Airtable Scripting

Reply


Terms & Conditions