I am wanting to hard code the table variables into the script airtable provides to convert URL’s into attachments, so that I can run it via an automation.
This is the script:
let settings = input.config({
title: "Convert URLs to attachments",
description: `This script will download all attachments from a URL into an attachment field. The
source field can be a URL field or any text field containing a URL. Each cell should only contain a single URL.`,
items: [
input.config.table("table", { label: "Table" }),
input.config.field("urlField", {
parentTable: "table",
label: "URL field",
}),
input.config.field("attachmentField", {
parentTable: "table",
label: "Attachment field",
description: "URLs will be downloaded into this field",
}),
],
});
async function convertURLsToAttachments() {
let { table, urlField, attachmentField } = settings;
if (attachmentField.type !== "multipleAttachments") {
output.text(
`${attachmentField.name} is not a attachment field.\nRun the script again when you have an attachment field.`
);
return;
}
let skipAlreadySet = await input.buttonsAsync(
"Skip attachment entries that already have files?",
[
{ label: "Yes", value: true },
{ label: "No", value: false },
]
);
let updates = [];
for (let record of (
await table.selectRecordsAsync({ fields: [urlField, attachmentField] })
).records) {
let existingAttachments = record.getCellValue(attachmentField) || [];
if (skipAlreadySet && existingAttachments.length) continue;
let urls = record.getCellValueAsString(urlField);
if (typeof urls !== "string") continue;
let attachmentsFromUrls = urls.split("\n").map((url) => ({ url }));
updates.push({
id: record.id,
fields: {
[attachmentField.id]: [
...existingAttachments,
...attachmentsFromUrls,
],
},
});
}
for (let i = 0; i < updates.length; i += 50) {
await table.updateRecordsAsync(updates.slice(i, i + 50));
}
}
await convertURLsToAttachments();
