I have a table that has a text column containing filenames. Each record has a single filename in it.
On my computer, stored locally, I have a folder that is full of the actual files referenced by the filename field.
What I want to do is create a script that goes through each record, attempts to match the filename to one of the files in the local folder, and then if there is a match uploads the matching file as an attachment to the record.
Does this sound possible? Or am I dreaming impossible scripting-block dreams?
I am doing something similar but was planning to first use the gallery view bulk upload (purple X) that gives the option to create a record for each image rather than hosing elsewhere. The gallery attachment upload uses the filename as the primary field. My quandary is how to do what @hgld is asking I think - how then to match to a field name in a separate table, link and attach these images to their corresponding field name. Here are screenshots from a screencast showing how I am doing it manually with linked record. But I have 5,000 sketches I have to match up.