New Data Type: Image URL


#10

Yes please let me display images with a URL just like Awesome-table.com does. Thanks!


#11

Yes! Support for this feature.


#12

Google sheets supports this feature as well


#13

Yes, I would also love this feature, for instance, feeding from google sheets, via Zapier, a bunch of links that then display as thumbnails. Does not seem to happen right now.


#14

I want to add my vote for this feature as well. Would be incredibly useful for my organization.


#15

+1 Agree. This feature would be really useful. I can export user URL thumbnail from another service, but can’t actually see the pics.


#16

+1 I’m also voting for this feature request. Another idea on how to implement this is by introducing a new IMAGE function. Something like Google Sheet’s IMAGE function. You pass the URL on this function and then it displays the image on the cell of Google Sheet.


#17

+1 for this feature. Not being able to (automatically) display images from URLs is obviously a huge pain for everyone here!


#18

+1 for this. AirTable is great but it has incredibly limited support for sheets with pictures or images. I had to learn how to be an Excel VBS Rocket Scientist just to export images in a logical way that I could import into AirTable since CSV doesn’t support images.


#19

hi David, how did you do it? i want to do the same thing too!


#20

Unfortunately the process didn’t quite work like I had anticipated. It was an incredibly obnoxious process, and it may work better for you. Given the complexity of my situation it did not work. These are the steps I had to go through since AirTable doesn’t inherently support image upload with XSLX files.

  1. Run script that saves all Excel images and names the file based on the row it’s in (example 1.png, 12.png, 55.png etc). The script is on Stack overflow, I’ll paste it in here when I can. I’m having trouble logging in to my account right now.

  2. Save original Excel file as CSV

  3. Upload original Excel file.

  4. Manually upload images 1 by 1 into the column they are named after.

OR, if you are ok with linked images rather than having the image thumbnail appear on your sheet, you can bulk upload all the images into a new gallery view and use a linked column to manually link each image to their associated row. It’s mostly all manual.

It sucks.


#21

David did you have the script for this?

Image upload is such a pain in air table, I have a ton of image URL assets that I’d like to port in but can’t…

I would really like the image URL preview link so I can just use my own file attachments instead

The only thing I could possibly think of for uploading images into Airtable is the following workflow:

  1. Open up Airtable spreadsheet
  2. Open up Regular spreadsheet with URL images to port in
  3. Run a Mouse / Keyboard automation macro that grabs each item one by one, puts it over to the airtable link, checks PIXELS for upload successes, and then does each image one by one.

This would assume my airtable spreadsheet and regularspreadsheet have a 1:1 relationship, or that I could use a CTRL+F search for the same primary keys each one shares to grab the image URL

I can’t think of a better way to do this. Not even sure if this would even work correctly either

I would like to see what your script looks like though on SO

EDIT

for anyone reading this I ended up making a autohotkey macro on this thread:


#22

+1 for this feature! I’m so used to =IMAGE(“URL”) on regular spreadsheets.


#23

+1 I understand that this might be contrary to the AirTable pricing model to allow us to store our images in other clouds rather than uploading them, but there are so many other services that do this (google sheets etc.), I can’t imagine storage is the only way for AirTable to ensure that people purchase plans. In fact, I would pay for the ability to link directly to images stored on BOX or Dropbox, or a simple URL link.
There seem to be many people who want this. Can we get an official reply on why it is not implemented?


#25

+1 This would be incredibly useful in automating our marketing reports


#26

You can use a multi-step zap to copy an image URL created via formula to a true URL/link field, and then also an attachment field. When the attachment field contains a URL to an image, it will display it in-line. We use this to generate and display barcodes.


#27

#28

This is a great solution and thank you for sharing. I will definitely be using it.

It does annoy me that it works with zaps but not when importing a csv or pasting the URL in the attachment field. I have a list of 9000+ products that I’d have to run nicely timed zaps to get those images there and still would be a time saver–I already have ways to use Zapier to populate images for these existing products but it would be great not to use the 9000 tasks and simply paste, in a way that makes it more consistent with the Zapier action (which to ignorant me is like pasting the value in the field)


#29

@polen Agreed, for manual “copy and pastes” I’d argue the Attachment field should accept an Image URL. That said, for automation, you’d likely still need Zapier. In our case, we have a formula that generates a unique Image URL (barcode), which we then need to auto-populate within an Attachment field. Thus Zapier is truly required for us… At least until Airtable adds some sort of scripting.


#30

Yes please! I use air-table to process data that is exported from another software as a CSV, containing many many urls to photos.