Welcome to the community, @Randi_Travers! :grinning_face_with_big_eyes:

I think that I see the problem. You’re directly passing the existing cell value to the new one, which (unfortunately) won’t work with multiple select fields:

(BTW: when sharing code, it’s helpful to format it as preformatted text using the </> button in the post editor toolbar)

Earlier in your script you’re doing the right thing with the {Task Status} and {Task Type} single select fields and passing objects with a name property. Multiple select fields are similar, but they require an array of such objects. To properly set that up, you’ll need to get the names of the chosen items from the original. The original cell value returns an array of objects that also contain an id property, and those IDs are unique to each field.

This should work:

"Test Multi-Select Copy": templateRecord.getCellValue("Test Template Multi-Select Copy") === null

  ? null

  : templateRecord.getCellValue("Test Template Multi-Select Copy").map(item => { return {name: item.name} })

This uses the ternary operator, which is a shortcut way of doing an if...else statement. In short it’s saying, “If the cell is empty, assign an empty value; otherwise map the existing array of objects to a new array of objects that will work for record creation.” (Ternary operators are not often split across multiple lines, but if that weren’t done the whole line would be crazy long. Most of the time for lengthy calculations like this I assign the result to a variable before building the object to use for record creation specifically to avoid such long lines. )

@Justin_Barrett - thank you for your reply. Your line of code does the trick and now I know how to handle other data if we don’t require data to be in the template. Sorry about the messy post I couldn’t figure out why mine looked so different than the other posts but I also couldn’t delete it after I posted it either. Anyways, do you have any recommendations on how to code a linked field for predecessor information. We are planning on having a column in our Template Table to have the user pick (from the drop down) which row is the row before - but then when I use my script to ‘copy’ this over the record id won’t be the same? I’ve started reading through posts in the Airtable community to try to figure this out and I saved some code on Friday that may work but none of it was quite right. Not sure if we even need to have the user do that first part. Anyways - thanks in advance for any advice

Not sure if anyone has any good sample code for predecessor columns? I have the column set up in my task template but I can not figure out how to copy that information over in my script when I copy over all of the other tasks in my template and now my boss would like to know if I can figure out the due date of the current task by the start date of the next task - yes I know that both of these questions are going in different directions of looking forward and backwards but any ideas would be welcome. I have searched through the community and haven’t found anything yet so I’m thinking that I need to solve these out of the box as no one else has come across this yet. Thanks in advance for any advice

Sorry for the delay in getting back to this. I’ll try to put some thought into this tomorrow and get back to you.

I’m so close (hopefully I’m formatting the code correctly) below is the new loop I created for filling in the predecessor information. I’m having the user tell me the task order in their template set up and then I’m using that number to figure out which rows should be linked to which row. If I’m on row one - I just need to save the information about the row and then if I’m at any row after that - update the row with the previous row’s id and then save it’s own id. But it throws no errors but doesn’t populate either. I’ve searched and searched for some coding error to why the data isn’t populating, I’m sure that it is something minor but I can’t find any example to assist me with this. This is the final piece for this script. So if anyone can help me that would be wonderful. Thanks in advance

…

//need to loop back through and set up the predecessor field if the column: Order of Task is not empty

const taskTable = base.getTable(‘Tasks’);

const taskView = taskTable.getView(‘Predecessor Column’);

let taskQuery = await taskView.selectRecordsAsync();

    let filteredTasks = taskQuery.records.filter(record => {

        let filteredProjectName = record.getCellValueAsString('Project')

        return projectName === filteredProjectName

    });

    let savedRecord

    if (filteredTasks.length > 1) {

        for (let recordLoop of taskQuery.records) {

            if (projectName === recordLoop.getCellValueAsString("Project")) {

                //do logic in here

                let taskOrder = recordLoop.getCellValueAsString('Order of Task')

                if (taskOrder = '1') {

                    //save record but don't do anything else

                    savedRecord = >{id: recordLoop.id}] ;

                }

                else {

                    //update current row with last row then save current id for next one

                    await taskTable.updateRecordAsync(recordLoop, { "Predecessor Task": savedRecord } )

                    savedRecord = recordLoop;

                }

            }

        }

    }

...

    let filteredTasks = taskQuery.records.filter(record => {

        let filteredProjectName = record.getCellValueAsString('Project')

        return projectName === filteredProjectName

    });

    let savedRecord

    if (filteredTasks.length > 1) {

        for (let recordLoop of taskQuery.records) {

            if (projectName === recordLoop.getCellValueAsString("Project")) {

                //do logic in here

                let taskOrder = recordLoop.getCellValueAsString('Order of Task')

                if (taskOrder = '1') {

                    //save record but don't do anything else

                    savedRecord = >{id: recordLoop.id}] ;

                }

                else {

                    //update current row with last row then save current id for next one

                    await taskTable.updateRecordAsync(recordLoop, { "Predecessor Task": savedRecord } )

                    savedRecord = recordLoop;

                }

            }

        }

    }

...

//need to loop back through and set up the predecessor field if the column: Order of Task is not empty



const taskTable = base.getTable('Tasks');



const taskView = taskTable.getView('Predecessor Column');



let taskQuery = await taskView.selectRecordsAsync();



let filteredTasks = taskQuery.records.filter(record => {



    let filteredProjectName = record.getCellValueAsString('Project')



    return projectName === filteredProjectName



});



let savedRecord =>]



if (filteredTasks.length > 1) {



    for (let recordLoop of taskQuery.records) {



        if (projectName === recordLoop.getCellValueAsString("Project")) {



            //do logic in here



            let taskOrder = recordLoop.getCellValueAsString('Order of Task')



            if (taskOrder === '1') {



                //save record but don't do anything else



                savedRecord = b{id: recordLoop.id}] ;



            }



            else {



                //update current row with last row then save current id for next one



                await taskTable.updateRecordAsync(recordLoop, { "Predecessor Task": savedRecord } )



                savedRecord = b{id: recordLoop.id}];



            }



        }



    }



}

I figured out the couple of small mis-types that I did to solve my problem so this item is now fully closed