Scripting - filter by "Link to another record" fie...

[Brent_del_Rosar]

We’re using Airtable as a PIM for clothing and we sometimes do modifications that creates a new style code. A lot of the information is the same (as it’s just a modification), but I don’t want to copy over any linked fields or certain notes on an item.

I was wondering if it was possible to create a script that would let you select an item you want to modify and create a new item with select information from the base item. The links are in the same table FYI.

[Kamille_Parks · Accepted solution]

You could use a script like this:

let table = base.getTable("Table Name")
let query = await table.selectRecordsAsync()
let records = query.records

let fields = table.fields

let exclude = ["Field 1", "Field 2"]

let filteredFields = fields.filter(x => !exclude.includes(x.name) && x.isComputed == false)

let original = await input.recordAsync("Original Record", table)

let obj = {}

filteredFields.map(x => {
    Object.assign(obj, {[x.name]: original.getCellValue(x.name)})
})

await table.createRecordAsync(obj)

The above script lets you add as many fields to the exclude array as you want. When you run the script it will ask which record you want to duplicate, then it will make a new identical record with all the fields filled in except for the fields you added to exclude.

[Brent_del_Rosar]

That worked beautifully! This may be asking too much, but is there a way to add the link to the base item? @Kamille_Parks

[Kamille_Parks]

What do you mean by link, the url for a particular record, or updating the value of a link-record field?

[Brent_del_Rosar]

@Kamille_Parks either really, but a link-record field was what I had in mind.

[Kamille_Parks]

In your original post you said

Brent_del_Rosario:

I don’t want to copy over any linked fields

regardless, adjust the filteredFields.map section to the following:

filteredFields.map(x => {
    let fieldValue = original.getCellValue(x.name)
    let method = fieldValue && x.type=="multipleRecordLinks" ? fieldValue.map(y => ({id: y.id})) : fieldValue
    Object.assign(obj, {[x.name]: method})
})

[Brent_del_Rosar]

Kamille_Parks:

filteredFields.map(x => {
    let fieldValue = original.getCellValue(x.name)
    let method = fieldValue && x.type=="multipleRecordLinks" ? fieldValue.map(y => ({id: y.id})) : fieldValue
    Object.assign(obj, {[x.name]: method})
})

Thank you! I just want to have a link to the base item.

[Den1155]

This code doesn't work.