@greenant Thanks a Million
And thanks Heavens for rollback 😎
Found the solution... For those who are interested, check my video above to see the fields and the base structure to understand...
The inputs used from input.config() were:
recordID
newName
The rest is not necessary. There are some comments that explain the code, use google translator from Portuguese PT-BR to your language.
// Setup
let config = input.config()
let table = base.getTable("Lista mestra")
// Define a variável newName e atribui a ela o valor Nome ajustado
let newName = config.newName
console.log(config.newName)
// Cria o vetor para armazenar as infos do registro submetido
const record = await table.selectRecordAsync(config.recordID)
console.log(record)
// @ts-ignore > Ignora o erro devido a possibilidade do registro ser nulo, pois as condições gatilho da automação garantem que não será.
// Armazena as informações do(s) anexos no vetor attachmentField
let attachmentField = record.getCellValue("Documento")
// Cria um novo vetor vazio que receberá o(s) documento(s) renomeados para sobrescrever os existentes com nome original
let newAttachment =t]
// Vai executar o for para a quantidade de anexos que houver dentro do vetor attachmentField
for (let
attachmentNumber, attachment] of attachmentField.entries()){
console.log(attachmentNumber,attachment,)
// Quebra a string do nome original do anexo em um vetor onde a extensão está separada em um endereço desse vetor
let findExtension = attachment.filename.match(/\.\w+$/) || /""]
let extension = findExtensionf0]
console.log(extension)
// Se o número de anexos é maior que 1, então ele renomeará os anexos e acrescentará um incrementador sequencial ao final
let fileSpecifcName = attachmentNumber>0 ? "_" + (attachmentNumber+1) : ""
// Alimenta o vetor newAttachment com a url e o nome do anexo com os ajustes feitos
newAttachment.push({
url:attachment.url,
filename: newName + fileSpecifcName + extension
})
}
console.log("New attachment field array", newAttachment)
// @ts-ignore > Ignora o erro devido a possibilidade do registro ser nulo, pois as condições gatilho da automação garantem que não será
// Atualiza o campo Documento com o(s) anexo(s) modificado(s)
await table.updateRecordAsync(record.id,
{
Documento: newAttachment
})
Worked like a charm!
Very clear directions!
Welcome to the community, @Cameron_Goldberg! :grinning_face_with_big_eyes: While attachments can be manually renamed, Airtable’s scripting options—in the Scripting app, or in the scripting action in an automation—only allow you to set the filename when first adding an attachment with a script. There’s no option for changing the filename of an existing attachment.
That said, you could use a process similar to what @ScottWorld described: collect the current URL of the attachment, then submit that as a new attachment in the same field with the name you want to use. I just ran a test using an automation, and it works surprisingly well. (NOTE: this will only work for a single attachment, which sounds like it’ll work for your use case; if anyone needs multiple attachments renamed, the setup will require some more detailed tweaking which I don’t have time to explore at the moment.)
I made a new automation using the “When record matches conditions” trigger, with the condition being that the attachment field is not empty. The scripting action requires four input variables from the triggering record:
recordID - The record ID
filename - The filename property of the attachment field
fileURL - The URL property of the attachment field
newName - The new name that you wish to assign to the attachment
The code for the scripting action step is below. This finds the existing file extension for the attachment and uses that for the new name, so your new name formula should not include the extension. That way it doesn’t matter what file type someone attaches (.gif, .jpg, .pdf, etc) because the script just uses the current extension, and only changes the rest of the name.
// 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": m{url: config.fileURLr0], 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!?!
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)
. Ultimately, I’m not sure and was hoping you (the community) might know.