Mar 24, 2023 03:45 AM
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:
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! Go to Solution.
Mar 24, 2023 06:28 AM
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).
Mar 24, 2023 06:28 AM
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).
Aug 13, 2023 02:00 AM
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.
Aug 13, 2023 02:16 AM
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).
Nov 20, 2023 07:17 PM
Thanks Guys, same problem and all working after the modification Joseph noticed.