How to make a url for downloadable image?

[FREDY_ORTEGON]

Hi everyone, someone knows how to create a link similar to this:

“https://www.appsheet.com/template/gettablefileurl?appName=MisredesCars-294588&tableName=Publicaacion...”

but what for a downloadable image? similiar to this:

“https://drive.google.com/uc?id=1zMWoVPV7xXHCGm7u9Icu0QbM2VcknAIm&export=download&authuser=0”

[Koichi_Tsuji]

https://www.appsheet.com/samples/Public-Sample-App?appGuidString=0adc8d7e-94fb-4712-87d0-fa37f03cc22...

I created sample app which guide to construct the expressions to generate the publich URL for image in an instant way. I published for the benefit to the community, as it may help those who are looking for it like you.

Just copy app and enter

“App Name, Table Name, Image Column”

to get the workable expression on your app.

[Koichi_Tsuji]

One thing I state is this is not “downloadable” URL.
Let the user of app to hold over the image, or right click then get the option to download the image working on.

This app is just prepread and help to construct the public image url for your guidance.

[FREDY_ORTEGON]

thanks @tsuji_koichi
Thanks for sharing your application, it will certainly help me.
What I want to do at this moment is not only the link of the public url but it is downloadable. I mean that as soon as you enter that link the image is downloaded similar to this:

“https://drive.google.com/uc?id=1zMWoVPV7xXHCGm7u9Icu0QbM2VcknAIm&export=download&authuser=0”

[Koichi_Tsuji]

As far as I know, it is difficult to generate the donwloadable URL, i.e. the user click the URL or hyperlink then start to download image, as it is backend service rather than client.

[FREDY_ORTEGON]

@tsuji_koichi or do you know how I can know the id with which the image is saved in google drive?

similar to this: 1zMWoVPV7xXHCGm7u9Icu0QbM2VcknAIm

[Koichi_Tsuji]

I dont think so.

Appsheet does not have a way to get the file ID of Google Drive through its expression.
But without ID of file, we can achieve what we can do mostly wihtout knowing the Google drive file id.

[Koichi_Tsuji]

Download an image Questions

@Aleksi You create virtual column to dynamically generate the hyperlink to the saved image file. When your user click the link app will open up image in browser . User hold down over the image and then download to device become available to save the file to local .

for your additional guidance to consider.

[FREDY_ORTEGON · Accepted solution]

@tsuji_koichi
the solution was to make an integration with zapier so that every time an image enters a specific folder in google drive, a new row is generated in an excel where it returns the id, with this id I can obtain the downloadable url