Good day to all,
I am currently using both Airtable and Softr for my endorsement platform. Here, our internal team uploads more than 2 pdf reports via Softr with a sample file name convention: trinidad_franco_luis_cruz_CIBI_negrec_)511_h7tezeubi.pdf
However, once client has downloaded the PDF file in Softr, this is what will appear. The client can’t download the file in PDF.
Then these are the steps currently being done:
- Our internal team uploads several reports in the Softr page.
- Once uploaded, there is a script developed and placed in Airtable (please see screenshot) wherein the attachments uploaded are readable in the backend.
- Once an attachment has been extracted and read, it will automatically go through another table in Airtable for matching with the name endorsed by client.
- Once matched, the report will be viewed already by the client via Softr.
I believe that there might be an error when it comes to the script developed as I observed when I checked Step 1 in Softr, the reports are downloadable via pdf.
Here is the code developed for Step 2:
const { record_id } = input.config();
const sourceTable = base.getTable("Bulk Upload");
const destinationTable = base.getTable("Bulk Upload Extract");
const selectedField = sourceTable.getField("Attachments");
const nameField = destinationTable.getField("File name");
const attachmentField = destinationTable.getField("Attachments");
let record = await sourceTable.selectRecordAsync(record_id);
let recordAttachments = record.getCellValue(selectedField);
if (recordAttachments) {
let newRecords = recordAttachments.map(attachment => ({
fields: {
[nameField.id]: attachment.filename,
[attachmentField.id]: [{ url: attachment.url }]
}
}));
while (newRecords.length > 0) {
await destinationTable.createRecordsAsync(newRecords.slice(0, 50));
newRecords = newRecords.slice(50);
}
}
Thanks
