I have a list of “Jobs” in Airtable, and a corresponding list of Files in a NAS drive, which have the
“Job number” field from Airtable in their filename. So it’s easily filterable by just looking for files with that “Job number” in their filename.
I would like to attach a script to a button that would automate that process. Basically, filter and download the files from the NAS when the user clicks the button. Is there someone who can point me in the right direction here?
There are several issues at play.
If you cannot make the files publicly accessible on the internet, then scripting cannot upload the file.
On the other hand, you can manually upload files in bulk using a gallery view, and then scripting can be used to move the attachments to their matching records.
You may also be able to use a third party system that integrates with a cloud storage system, such as DropBox, if you can get the files to the cloud storage system.