Dec 07, 2019 06:12 PM
I wasted a few hours on this so I figured i would save someone the same headache.
Step 1. Create a shareable gridview link on your table
Step 2. Create a Google Sheet
Step 3. Click on the “Add-on” link in the main menu bar, on the dropdown select “Get Add Ons”
Step 4. Search for “Airtable” and on the dropdown select “Airtable Importer by Railsware”
Step 5. Install it, it’s free, but it works (I have no relationship with this company)
Step 6. After you install it, refresh your Google Sheet, then go to “Add Ons” link again
Step 7. Select the “Airtable importer” on the dropdown, on the flyout menu, select “Open Sidebar”
Step 8. On item 4, paste your shareable gridview link and select import into current sheet
The importer will only import the image URLs in the column’s cell(s). It uses link breaks in the cell to separate the URLs.
If you need to remove the line breaks and replace them with a comma,
Step 1. Select the column range with the URLs
Step 2. Press “Command + Shift + H” on Mac or “Control + Shift + H” on Windows".
Step 3. The search modal will open and in the find box enter
Step 4. In the replace box enter a comma if that is what you want to replace the line break with or anything you prefer
Step 5. Select the check box “Search using regular expression”
Step 6. Hit “Replace All”
I’d like to add that I can’t believe Airtable does not provide the simple option of exporting a spreadsheet with the attachment URLs, without the thumbnail URL or the additional syntax, I don’t feel I should have to write an entire API script just export my images or fiddle around with regular expression for an hour trying to figure out how to remove the thumbnails and additional syntax.
Jan 19, 2020 09:04 AM
We solved this problem in another way (fewer steps too). We made this tool: miniextensions.com/airtable-attachments-to-urls. It extracts the URLs of all attachments and saves them in field on Airtable. It separates URLs by commas if you have multiple attachments in one record.
Jan 19, 2020 01:52 PM
That’s a cool tool.
Since there’s no easy way to split and render lists from a text field, I recommend you consider adding the option of dropping these into a rich-text field as bulleted link items - will make for a much more chummier presentation and utilization of the URL list.
In a rich text field you could also display the file name as a link and hide all the ugliness of the URL. Airtable - after all - is all about pretty and URLs are the opposite of pretty.
And, why abandon the file name? If users are using this mini-extention to escape from the sometimes insane aspects of storing the document in Airtable, help them escape fully so they can delete the attachments field altogether.
Apr 25, 2022 03:58 PM
Hi, it’s really simple to get only urls from images without paying anything.
Here’s how to do it:
At this point, you should have fields containing a lot of blabla, as well as direct links to your images; you will have to extract them.
Of course the regex can be improved in case there are several images, but in my case I do not need it.