I’m using a Zapier and connecting to dropbox. In my Zap, it drops the a URL of the file uploaded into dropbox back into my Airtable table. Problem is, I don’t want my users to have to use dropbox. Luckily there is a feature through Dropbox that allows you to turn any share link into a direct download link by adding a “1” at the end of the URL instead of the 0.
Problem is, the Zapier API is giving me a shortened dropbox link… I can’t change this…
is there anyway that I could expand the short link in another cell?
That would allow me to create a formula that’d change the last digit of the URL into a direct download link.
Thanks in advance!