Re: Automate changing the file name of an attachment
0
8606
3
Just ran into a problem today with the script… thought i’d reach out and get your advice.
So, on the surface, the script is a game changer for us. It’s changing file names perfectly, it’s amazing!!!
In our use case, we’re re-naming files so that when a user downloads them, it’ll be in the correct format. The problem is occurring when we download the file. For some reason, if the script is active, it turns it into a “TextEdit Document” when it’s downloaded onto my computer (we’ve also tested out multiple computers). It is critical that the script doesn’t change the type of file, as it makes it unusable… :frowning:
IE:
This is an example when the script isn’t on and how it still is a real .MOV file (same happens with .mp4):
This is the same file downloaded with the script on:
Things i’ve tried:
- I’ve tried changing the file name on my computer to see if it was perhaps the naming convention I gave it, no effect.
More context (if helpful)
- The files we’re directing towards this script are mp4, .mov files.
- This is what the file name looks like, it still contains .MOV so i’m confused:
I edited the script a bit since our last message to get it working with the #1 and #2 convention. So, here is what the live version i’m using looks like:
let config = input.config()
let table = base.getTable("Self Tapes Submissions")
let query = await table.selectRecordsAsync()
let record = query.getRecord(config.recordID)
// Collect record data
let newPrefix = record.getCellValue("newName1")
let files = record.getCellValue("Self Tape #1")
// Get the extension and add it to the new name
let newFiles = []
for (let file of files) {
let parts = file.filename.split(".")
let ext = parts[parts.length - 1]
let newName = `${newPrefix}. ${ext}`
newFiles.push({url: file.url, filename: newName})
}
// Reattach the item with the new filename
await table.updateRecordAsync(record, {
"Self Tape #1": newFiles
})
I'm currently trying to implement this into my airtable base but it's throwing an error at me.
This is what the image file looks like after I run the automation. It changes the file name, but the file is unreadable. This was from me trying the first script you wrote out.
I tried the second script, but then it was telling me that
"let query = await table.selectRecordsAsync()"
is deprecated.
So now I'm at a loss on how to make it work. I also don't know if this script will fix the issue of not being able to read the file after reuploading. Here is everything that I'm currently working with:
Any help you can provide on this matter would be greatly appreciated!
