Skip to main content

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.

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).

 

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).

 


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.

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.


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).

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).


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

Reply


Terms & Conditions