Changing file name script

Question

I have a script that runs without any errors but doesn't actually do anything. However, if I go to Test Automation and select a record to test, then run it, it works (almost) as expected. Therefore pretty confused what's going wrong. Image files are automatically downloaded from our server into the mockUpFiles field within a table. File names are like this 63eb679887a459_13030203recqKJDnAJSRJOsSL.jpeg. The script should use title + "_" + designTypeName + "_" + channel to change the filename to something which allows me to identify the contents. Can anyone help tweak this code to make it change the file name as soon as a record is created (Trigger is obviously set to run when a record is created)? const imageAttachment = base.getTable("Pre Mock Prod (PB)");

const recordid = input.config()["recordid"];

const recordToUpdate = await imageAttachment.selectRecordAsync(recordid);

let title = recordToUpdate?.getCellValue("mockup_id");
let designType = recordToUpdate?.getCellValue("designType");
let channel = recordToUpdate?.getCellValue("channel");
let imageField = recordToUpdate?.getCellValue("mockUpFiles");
let newImageField = [];

if (imageField) {
  for (let [imageNumber, image] of imageField.entries()) {
    console.log(image, imageNumber);
  
    let findExtension = image.filename.match(/\w+_\d+\.\w+$/) || [""];
    let extension = findExtension[0];
    console.log(extension);

let fileSpecificName = imageNumber > 0 ? "-" + (imageNumber) : "";
    fileSpecificName += designType;
    let designTypeName = designType ? designType.name : "";

newImageField.push({
      url: image.url,
      filename: title + "_" + designTypeName + "_" + channel
    });
  }  
  console.log("New Image Field Array", newImageField);

await imageAttachment.updateRecordsAsync([{
    id: recordid,
    fields: {
      mockUpFiles: newImageField
    }
  }]);
}

Alexey_Gusev · Accepted Answer

Hey Alexey, thanks so much for taking the time to rewrite this. However, I am getting an error when I run this - I'm sure I am missing something obvious...this is the error:

TypeError: Invalid arguments passed to table.selectRecordAsync(recordId, options):
• recordId should be a string, not undefined
    at main on line 3

Hi,

you should give first variable the same name, as it written in code. so, change 'recordID' to 'id' on the left side.

also, you are put all 4 values into the same variable, while you need to create separate variable for each

also check the right panel, after script run it should display input parameters like this (of course values are random data):

and by way, it doesn't matter how you will call them and how many - they all (except id) assigned to a variable rest and then joined into a string with given delimiter.

Alexey_Gusev · Answer

feels like a bit overengineering.you should acquire title, designTypeNamec, channel' in input parameters together with id,so you have 4 variables on the left side, from Automation code editor.I had to rewrite script. ternary operator on ix should have been easier, via + , but it didn't worked when testing, Array join solved it, but some simple way should exist here.   const table=base.getTable('Pre Mock Prod (PB)')const {id,...rest}=input.config()const files=await table.selectRecordAsync(id).then(rec=>rec?.getCellValue('mockUpFiles'))const names=Object.values(rest).filter(n=>n).join('_')const newnames=files?.map((f,ix)=>(Object.assign({},f,{filename:[names,ix? '_'+ix:''].join('')})))if (files) await table.updateRecordAsync(id,{'mockUpFiles':newnames})And by the way, your main problem is that files are being processed few seconds after upload, so your automation works before filename created and results then overwritten. So you can't see it on upload, but it looks good on test.

Changing file name script

4 replies

1 Attachments

1 Attachments

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded