Automate changing the file name of an attachment

@greenant Thanks a Million

And thanks Heavens for rollback 😎

Worked like a charm!

Very clear directions!

// Setup
let config = input.config()
let table = base.getTable("Table Name")

// Get the extension and add it to the new name.
let parts = config.filename[0].split(".")
let ext = parts[parts.length - 1]
let newName = `${config.newName}.${ext}`

// Reattach the item with the new filename
await table.updateRecordAsync(config.recordID, {
    "Attachment Field Name": [{url: config.fileURL[0], filename: newName}]
})

I realize I am 4 years behind here and things have probably changed, I am just all over the place trying to figure out how to automate the name change of some QR codes that are automated by airtable.

In my table called Computers-Devices, I need the QR Code field images to be renamed to match the data in my SN/ST field.  So rename it by appending what is in the SN/ST field for each record.  Help!?!

Use @greenant code. It still works.

Dump it in Google translate, if you don't know Spanish. (Like myself)

// Setup
let config = input.config()
let table = base.getTable("Table Name")

// Get the extension and add it to the new name.
let parts = config.filename[0].split(".")
let ext = parts[parts.length - 1]
let newName = `${config.newName}.${ext}`

// Reattach the item with the new filename
await table.updateRecordAsync(config.recordID, {
    "Attachment Field Name": [{url: config.fileURL[0], filename: newName}]
})

This script really helped, however I have an issue sometimes when trying to go back once a record is already created and add a new attachment, it links the attachment as an HTML instead of jpg. I’ve tried to find fixes for this, and haven’t been successful, any ideas on what could be causing that?

Here is my script : 
 

// Setup

let config = input.config()

let table = base.getTable("Expenses")

// Get the extension and add it to the new name.

let parts = config.filename[0].split(".").pop()

let ext = parts[parts.length - 1]

let newName = `${config.newName + "_" + config.userName + "_" + config.expenseTotal + "_" + config.expenseType}.${ext}`

// Reattach the item with the new filename

await table.updateRecordAsync(config.recordID, {"Receipt": [{url: config.fileURL[0], filename: newName}]

})

For anyone who is getting the “new” error where the file extension is part of the name but the file is saving as html:  the ​@greenant code does seem to work. As someone with very little coding experience. the combination of format of the code and language made it hard for me to put into use. Google Translate wasn’t enough.  I eventually put it into ChatGPT and that outputted this below, which did work!

// Setup
let config = input.config();
let table = base.getTable("ClientDocuments");

// Define the variable newName and assign it the value of "Adjusted Name"
let newName = config.newName;
console.log(config.newName);

// Create a variable to store the submitted record's data
const record = await table.selectRecordAsync(config.recordID);
console.log(record);

// @ts-ignore
// Ignore the error due to the possibility of the record being null,
// but the automation's trigger conditions guarantee it will not be

// Store the attachment(s) from the "Document" field in an array
let attachmentField = record.getCellValue("Original File");

// Create a new empty array to hold the renamed document(s)
// This will overwrite the existing ones with original names
let newAttachment = [];

// Loop through the attachments in the attachmentField array
for (let [attachmentNumber, attachment] of attachmentField.entries()) {
    console.log(attachmentNumber, attachment);

    // Extract the file extension from the original filename
    let findExtension = attachment.filename.match(/\.\w+$/) || [""];
    let extension = findExtension[0];
    console.log(extension);

    // If there are multiple attachments, add a sequential suffix to the filename
    let fileSpecificName = attachmentNumber > 0 ? "_" + (attachmentNumber + 1) : "";

    // Push the adjusted attachment into the newAttachment array
    newAttachment.push({
        url: attachment.url,
        filename: newName + fileSpecificName + extension
    });
}

console.log("New attachment field array", newAttachment);

// @ts-ignore
// Ignore the error due to the possibility of the record being null,
// but the automation's trigger conditions guarantee it will not be

// Update the "Document" field with the modified attachment(s)
await table.updateRecordAsync(record.id, {
   "New File": newAttachment
});