Skip to main content

I have a script running that has been working well, but 2 days ago it stopped working.

Where it used to take a file from 1 column, rename it, and reupload it to a next column, it now:
1) Takes the file
2) Renames it
3) But when it uploads on airtable, the filename becomes a string of gibberish like "70d5b867" and doesn't use the filename I had specificed. The puzzling thing is, in the record edit history I see that the file with the right filename has been uploaded. But when I actually find the file, it's not named right.

Here's the script:

 

 

// Dynamically retrieve the record ID from input

let recordId = input.config().recordId;



let table = base.getTable("Agenda");

let record = await table.selectRecordAsync(recordId);



// Define an array of sets with their respective WIP tray field, output tray field, and naming format

let sets = [

{

wipField: 'WIP IF Session Banner (Automated)',

outputField: 'IF Session Banner (Automated)',

namingFormat: 'if24_session_banner_${sessionSlug}.png'

}

];



// Check if the record exists

if (record) {

// Loop through each set

for (let set of sets) {

let files = record.getCellValue(set.wipField);



// Ensure the files array is valid before proceeding

if (files && files.length > 0) {

let newAttachments = [];

for (let file of files) {

let url = file.url;

console.log(url);



// Get 'Banner file name slug' and construct the new filename for each set

let sessionSlug = record.getCellValue('Banner file name slug') || "default-slug"; // Handle empty slug

let newFileName = set.namingFormat.replace('${sessionSlug}', sessionSlug); // Use dynamic slug and naming format



console.log(newFileName);

newAttachments.push({ url: url, filename: newFileName });

}



// Update the record if there are new attachments

if (newAttachments.length > 0) {

let update = {};

update[set.outputField] = newAttachments;

await table.updateRecordAsync(record.id, update);

}

} else {

console.log(`No files found for record: ${record.id} in ${set.wipField}`);

}

}

} else {

console.log(`Record not found: ${recordId}`);

}

 

 

 

Hi there,

I am currently having almost the same problem as you. My script sendig uploaded pictures to tinyjpg and after they came back the files get new naming. For a few days now the naming process has stopped working. I don't understand why because I haven't changed anything.

This is my code to rename the files:

if (attachments && attachments.length > 0) {

// Iterate through each attachment in the field.

for (let [i, attachment] of attachments.entries()) {

let newFileName = `${baseFileName}_${i + 1}`; // New file name based on "Name" and the attachment number

let recordAttachmentUrl = attachment['url'];



console.log(`Compressing ${baseFileName} (Image ${i + 1})`);

I suspect at this point that Airtable has changed something and our code is no longer valid.

Hi there,

I am currently having almost the same problem as you. My script sendig uploaded pictures to tinyjpg and after they came back the files get new naming. For a few days now the naming process has stopped working. I don't understand why because I haven't changed anything.

This is my code to rename the files:

if (attachments && attachments.length > 0) {

// Iterate through each attachment in the field.

for (let [i, attachment] of attachments.entries()) {

let newFileName = `${baseFileName}_${i + 1}`; // New file name based on "Name" and the attachment number

let recordAttachmentUrl = attachment['url'];



console.log(`Compressing ${baseFileName} (Image ${i + 1})`);

I suspect at this point that Airtable has changed something and our code is no longer valid.


Hmm interesting, I just tried the following and it seemed to work fine:

await table.updateRecordAsync(recordId, {

"Attachments 2": [{url: attachment.url, filename:"test"}]

})

Tried it as both a script extension and as an automation script

Reply


Terms & Conditions