Re: Image previews not showing for attachments

JLindem · ‎Mar 24, 2023

Hello!

I am trying to automate the following process: when a file is uploaded to a specific Dropbox folder, a new record is created in Airtable with the file attached. This works fine, but there is no preview in Airtable. I have created the following automation in Make (formerly Integromat):

Here are the details of each step:

Below is what is seen in Airtable. As you can see, no preview is shown.

I have already done some troubleshooting myself:

I have tried uploading manually. This works fine and a preview shows up.
I checked the limitations in Airtable's documentation: the image is not more than 1 million pixels.
The image is uploaded to Airtable as .png, and not as a .zip file.
I currently use Chrome, and I have tried using Safari as well.
I have added another contributor to the Workspace, and they cannot see the preview either.

The error message I see is: "Previews for this filetype are not available".

Does anyone know a solution to this? If I cannot get the previews to work, or find a work-around/bodge, then we cannot use Airtable for this.

JLindem · ‎Mar 24, 2023

Solved thanks to this answer by @Jacob_Wheeler in a separate thread:

@Jacob_Wheeler wrote:
‎Jan 28, 2020 10:36 PM
Fixed. You can’t upload with query strings normally, so you have to use Integromat and add ?raw=1 to the end of the URL (remove ?dl=0 or =1 if it’s there). What I did is a find and replace. replace(URL,?dl=0,?raw=1).

I added the following to the automation:

The following function fix the issue; now image previews are displayed:
replace(2.downloadURL;?dl=0;?raw=1)and replace(2.downloadURL;?dl=1;?raw=1).

See Solution in Thread

JLindem · ‎Mar 24, 2023

Solved thanks to this answer by @Jacob_Wheeler in a separate thread:

@Jacob_Wheeler wrote:
‎Jan 28, 2020 10:36 PM
Fixed. You can’t upload with query strings normally, so you have to use Integromat and add ?raw=1 to the end of the URL (remove ?dl=0 or =1 if it’s there). What I did is a find and replace. replace(URL,?dl=0,?raw=1).

I added the following to the automation:

The following function fix the issue; now image previews are displayed:
replace(2.downloadURL;?dl=0;?raw=1)and replace(2.downloadURL;?dl=1;?raw=1).

Joseph_Steenso1 · ‎Aug 13, 2023

Anyone having issues with this again? As of the 8/8/23 this fix doesn't seem to be working anymore for me in multiple scenarios. Will keep troubleshooting it and post if I find a solution.

Joseph_Steenso1 · ‎Aug 13, 2023

Looks like the ? need to be replaced with & now.

replace(13.downloadUrl;&dl=1; &raw=1) instead of replace(13.downloadURL;?dl=1;?raw=1).

Jason_Jakarta · ‎Nov 20, 2023

Thanks Guys, same problem and all working after the modification Joseph noticed.