How to extract all URLs in a single attachment

[kennypurnomo]

Hello,

Can someone help me to write a code to extract all the URLs associated with my attachment in a particular record?

As you can see here, i have 3 photos where i need to generate “https://dl.airtablexxx1,https://dl.airtablexxx2,https://dl.airtablexxx3” in a field named “joined”

Thank you for helping me

[Rupert_Hoffsch1]

Hi Kenny, just wrote a script that does the job (please change table name in base.getTable("...") as well as the attachment field in const attField = record.getCellValue("..."); and the field to be updated at the end):

const table = base.getTable("Table 5")
const record = await input.recordAsync("Please select record", table);

// Select attachment field
const attField = record.getCellValue("Attachment 1");

// iterate over object and save as url
let urlArray = [];
attField.forEach(item => urlArray.push(item.url))
const urlString = urlArray.join(', ')

// update field
await table.updateRecordAsync(record.id, {
    "Joined": urlString,
})

This script works with a button as well as by selecting the record in the script. Please let me know if you have any questions!

[Rupert_Hoffsch1]

PS: Works for any number of attachments / URLs in a given field

[kennypurnomo]

Thanks for your effort. Can we RUN this script in the dashboard so that the script runs for the WHOLE records?

[Rupert_Hoffsch1]

I assume with “dashboard” you mean the app section on the right side? In this case we would need to iterate over all records instead of selecting a single record (via button or input in script). Then we run the script for every record just like before:

const table = base.getTable("Table 5")
const recordsQuery = await table.selectRecordsAsync();

// iterate over all records
recordsQuery.records.forEach(async record => {
    const attField = record.getCellValue("Attachment 1");

    // iterate over object and save as url
    let urlArray = [];
    attField.forEach(item => urlArray.push(item.url))
    const urlString = urlArray.join(', ')

    // update field
    await table.updateRecordAsync(record.id, {
        "Joined": urlString,
    })
})

You will still have to replace those field names in red of course.

[Rupert_Hoffsch1]

Sorry it was too early here and didn’t think about API rate limits :grinning_face_with_big_eyes: (15 writes per second and 50 records in one call). I changed the script and it should work for any number of records:

const table = base.getTable("Table 5")
const recordsQuery = await table.selectRecordsAsync();

let updateArray = [];

// iterate over all records
recordsQuery.records.forEach(record => {
    const attField = record.getCellValue("Attachment 1");

    // iterate over object and save as url
    let urlArray = [];
    attField.forEach(item => urlArray.push(item.url))
    const urlString = urlArray.join(', ')

    updateArray.push({id: record.id, fields: {"Joined": urlString}})
})

// update records
while (updateArray.length > 0) {
    await table.updateRecordsAsync(updateArray.slice(0, 50));
    updateArray = updateArray.slice(50);
}

[Hendrik_Yang]

Thanks mate! It’s very useful.

[kennypurnomo]

Rupert_Hoffschmidt:

const table = base.getTable("Table 5")
const recordsQuery = await table.selectRecordsAsync();

let updateArray = [];

// iterate over all records
recordsQuery.records.forEach(record => {
    const attField = record.getCellValue("Attachment 1");

    // iterate over object and save as url
    let urlArray = [];
    attField.forEach(item => urlArray.push(item.url))
    const urlString = urlArray.join(', ')

    updateArray.push({id: record.id, fields: {"Joined": urlString}})
})

// update records
while (updateArray.length > 0) {
    await table.updateRecordsAsync(updateArray.slice(0, 50));
    updateArray = updateArray.slice(50);
}

Rupert, i got strikethrough syntax there. Is it okay to proceed?

[kennypurnomo]

I got this error…

The “Joined” field is Single Text field in my side. Is this correct?

[kennypurnomo]

Is it because i have records which has empty attachment field? If yes, how can i ignore those records?