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.
I just want to seek your advice on this problem I am experiencing with regards to the pdf being uploaded via Softr, then on the backend in Airtable, a code is run to read every attachment uploaded, once it has been extracted, the attachment when downloaded is not viewed as a PDF.
What can be added in the script to read the file name extension with pdf through my base?