I am having a similar situation, although it might be the other way, sort of… I have an Airtable base for my postage stamp collection. I am now entering into the phase of deciding what is the best way to automatically insert URL’s (I am not really looking forward to doing this manually), since I have about 2,000 records to enter URL’s into the field, for website addresses, in my base. I should mention that I am using the free version on my iPads iOS 10 &11 and MacBook High Seirra 10.13.
The website is:
Then, from there the Integration/Zapier app would need to select a year the stamp was issued, in this case, there are some years that it’s just some of the stamps, but over the past 3 or 4 years, it will be pretty much all of them, i.e.:
Then the integration app would need to match up to the actual stamp that I need, which in this case is the link below, and it’s this page that I want the URL copied into the Airtable base (Website field):
It appears that the 5 digit number (in the above link: 15568 is a unique number, in sequence, although there might be some missing numbers, but it’s still in numerical sequence, assigned to each stamp. The next stamp in order is: 15569, but the next one jumps to 15571. I don’t know if this helps, but I thought I should mention it.
If an integration app (Integromat or Zapier) will not be able to do this directly, then perhaps I could do this indirectly, by using Excel or Google Sheets to populate Airtable, Either, directly into my original base or in a separate base, preferably with an image, so than I can easily copy and paste the URL into the main stamp collection base, using the images as a guide to match to the record, or if any of the above processes used, it can match it directly to the record in the original base, that would be even better. I don’t need to copy the images, since I have a separate field for that purpose. The images (for matching only) would be in its own field in a temporary base or new table within the original base, and a second field would be created (next to the temporary images field) so all the URL’s will be copied or uploaded automatically into each record.
Or maybe I am asking for the moon. ️
I only need the the temporary images that are connected with the URL’s for a visual guide, so I can match them correctly with the record in the main stamp collection base.
Also, please keep in mind that this process would be very new for me, so there might be a learning curve involved, but I like to learn new things.
I hope this makes sense.