Quick Tips (Easy) : Expression to construct URL to reach to your files

Manually constructing URL to reach out to your file with expression is found painful, when we need to get the app id, table name etc statically, and push into the part of expression. Sometime decode/encode issue is throw the additional pains to us.

To remove all those pains and concerns, this expression could be the most efficient and effective to construct the URL, most importantly automatically and dynamically.

CONCATENATE(‘https://www.appsheet.com/template/gettablefileurl?appName=’, ENCODEURL(CONTEXT(AppName)), ‘&tableName=’, ENCODEURL(CONTEXT(Table)), ‘&fileName=’, ENCODEURL([IMAGE]))

Symply the change of the column name which refer to your file/image type field at the last part of the expression.

Even after copying the app (new app will have different name), this expression will not be broken up. Low and least maintance as well.

16 Likes

A beautiful use of CONTEXT() my friend! partyparrot (Appsheet)


Just FYI, throwing this in here for good reference.

7 Likes

Updated with your suggestion (among other updates):

7 Likes

This tip is VERY valuable to me. Earlier, I wrote about how to collate images from students who were all using a copied version of a sample app I made:

Now I know that I no longer need to ask them to do this. I’ve just added an action to automatically record the app name in to the associated sheet after a student begins to use it. Then, because I have my students share their sheets with me, I can very easily collect it there – with no need to explain anything to the students or correct errors that they inevitably make.

Thanks so much for saving me (and my students) a good deal of time and trouble!!!

3 Likes

Hi. May i know where to put this formula. I know in appsheet but for which column name? In my case i want the signature image automated appear in the spreadsheet. Hope to hear from you soon. TQ

https://www.appsheet.com/samples/How-to-have-images-show-up-in-your-Google-Sheet?appGuidString=e161a3d2-8b5f-4246-957b-61677be0e81f

You need to push the Google Spreadsheet calculation and re-generate the table.
Above sample app should be addressing your question.

1 Like

What do you mean by 'You need to push the Google Spreadsheet calculation" . I’ve already copy the apps and change some of the column. For example, image column I’ve change to signature. But when it save to spreadsheet the the URL shown is still using the original app name not the one I’ve changed. End up i have to change manually the apps name in the spreadsheet column just to try if the signature can be display in the spreadsheet.

On the copied spreadsheet, you need to change the app-id to your app.

1 Like

So meaning everytime record is updated i’ve to change manually the app id. I tried to change the apo id, by changing the app name but it still shown the origiinal app id(imageinsheet)

So stressfull i cant even make it work out :sweat_smile: i want it to be automated, image/signature shown in the spreadsheet

Ah Okey, I looked into this sample. Actually it was strange settings was there.

Go to column setting for image url. You will find hard coded expression. You change the app-id onto yours.

1 Like

Ok will try later. But what is the exact formula should i use and where the formula should i put in the appsheet. Since i want the signature to be automated shown in the spreadsheet. I want to use the formula straight from my app if possible, i don’t want the copy app(imageinsheet).

Is it the formula concentrated?

And van i copy the formula and paste to the signature url in my app

On the top of this thread, you will find the exact formula.

Ok i will try. Will update you. Thanks for your help

Can you check for me what went wrong with my formula?