Automation to remove a single linked record, not all

Can’t think of a way to do this directly without using the scripting extension. If you have a paid plan you can run a script from an automation.

@Zack_S Thanks. I’m not the best scripter in the world but it’s good to hear some validation that it doesn’t look possible outside a script. I’ll let you know how it goes.

Yo, I think I have this one solved for you.

We have a Product Table

And a Tags Table;

I wrote two Automations to manage the Linked “Tags” field.

The first Automation adds the “New Product” tag to any newly created record in the Product Table - fairly straight forward to do with no-code Automation.

And then finally, we have another Automation with the trigger “When a record is updated” that monitors the “Tag” field in the Products table - where a script is executed upon a change being detected.

Below is my script, which looks to be working as hoped in my brief testing;

//Get the record with the "Tag" field change
const inputConfig = input.config();
const productsTable = base.getTable("Products");
const myRecord = await productsTable.selectRecordAsync(inputConfig.recordId);

//Get the recordID for the "New Product" Tag
const tagsTable = base.getTable("Tags");
const tagRecords = await tagsTable.selectRecordsAsync({fields: ["Name"]});
let [newProductTagRecord] = tagRecords.records.filter( record => (record.name === "New Product"));

//Logic for if the Tags Field is empty, in this case "null"
if (myRecord?.getCellValue("Tags") == null) {
    await productsTable.updateRecordAsync(inputConfig.recordId, {
        "Tags" : [{id: newProductTagRecord?.id}]
    })
} ;

//Logic for if the Tags Field is 2 or more tags, then remove the "New Product" tag.
if (myRecord.getCellValue("Tags").length >= 2) {
    
    let removeProductTagRecord = myRecord.getCellValue("Tags").filter( record => (record.name != "New Product"));
        
    await productsTable.updateRecordAsync(inputConfig.recordId, {
        "Tags" : removeProductTagRecord
    })
};

//Get the record with the "Tag" field change
const inputConfig = input.config();
const productsTable = base.getTable("Products");
const myRecord = await productsTable.selectRecordAsync(inputConfig.recordId);

//Get the recordID for the "New Product" Tag
const tagsTable = base.getTable("Tags");
const tagRecords = await tagsTable.selectRecordsAsync({fields: ["Name"]});
let [newProductTagRecord] = tagRecords.records.filter( record => (record.name === "New Product"));

//Logic for if the Tags Field is empty, in this case "null"
if (myRecord?.getCellValue("Tags") == null) {
    await productsTable.updateRecordAsync(inputConfig.recordId, {
        "Tags" : [{id: newProductTagRecord?.id}]
    })
} ;

//Logic for if the Tags Field is 2 or more tags, then remove the "New Product" tag.
if (myRecord.getCellValue("Tags").length >= 2) {
    
    let removeProductTagRecord = myRecord.getCellValue("Tags").filter( record => (record.name != "New Product"));
        
    await productsTable.updateRecordAsync(inputConfig.recordId, {
        "Tags" : removeProductTagRecord
    })
};

@Karlstens This looks great! I think this does achieve what we’re trying to do. I’m just not getting it to work in my environment – I’ve not really used scripting much to this point.

In my case:
-the products table name is “Product Catalog Reference”
-the tags table name is “Official Tags Table”
-the field that houses the tags on the product table record is called “Product Tags”
-instead of using the watching field, I am using a trigger of when a particular fields date is greater than 30 days
-in the input config area I added the record Id and labeled as you have in your script and I added the “Product Tags” field as well.

Finally, here is how I amended your code to try to fit my environment:

//Get the record with the “Tag” field change
const inputConfig = input.config();
const productsTable = base.getTable(“Product Catalog Reference”);
const myRecord = await productsTable.selectRecordAsync(inputConfig.recordId);

//Get the recordID for the “New Product” Tag
const tagsTable = base.getTable(“Official Tags Table”);
const tagRecords = await tagsTable.selectRecordsAsync({fields: [“Name”]});
let [newProductTagRecord] = tagRecords.records.filter( record => (record.name === “New Product”));

//Logic for if the Tags Field is empty, in this case “null”
if (myRecord?.getCellValue(“Product Tags”) == null) {
await productsTable.updateRecordAsync(inputConfig.recordId, {
“Product Tags” : [{id: newProductTagRecord?.id}]
})
} ;

//Logic for if the Tags Field is 2 or more tags, then remove the “New Product” tag.
if (myRecord.getCellValue(“Product Tags”).length >= 2) {

let removeProductTagRecord = myRecord.getCellValue("Product Tags").filter( record => (record.name != "New Product"));
    
await productsTable.updateRecordAsync(inputConfig.recordId, {
    "Product Tags" : removeProductTagRecord
})

};

It runs “successfully” but when I test it, it does not remove the tag. Where have I gone wrong?

Thanks SO much for your help.

console.log(removeProductTagRecord )

@Karlstens Very sorry for the super slow response.  Finally got around to re-implementing and this did work just as advertised.  Thanks and super helpful in helping me learn exactly what happening in the script too.  

No problem. One further technique I tend to do for all my scripting is "destructuring" of the input.config() object, for direct creation of the variables that carry the input values.

So where you see this.

It's better to do this instead.

If you had multiple inputs, you can destructure them as such;