I need some help from a developer to use the Airtable API to upload a spreadsheet of entries but to simultaneously attach a corresponding JPEG file for each record.
I work in picture post production, and the purpose of this is to provide shot information for every shot in an edit. The text data is easy to export, but I need to add a thumbnail of each shot / event as a visual reference. At the moment this is incredibly manual, when there can be hundreds of images to drag and drop onto each record.
The jpeg could be named the same as one of the columns of data (e.g. 001.jpeg). Example files available on request.
Any help gratefully received!