Hi, Im looking to get the URL of the images c...

[Paul_Pillay]

Hi, Im looking to get the URL of the images captured by my mobile, so I can create the link in my SQL database.

I think the below formula is what I need, however, it there a predefined expression to get the AppName?

I may need to copy this App and would like to dynamically get the AppName.

The tablename will always be same.

=SUBSTITUTE(CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=",“AppName-Account#”,"&tableName=",“TableN...”,+ImageColumnCell), " ", “%20”)

Thanks

[Harry2]

@Paul_Pillay Hi Paul, could you explain why you need to use an expression to create image links? Each time you capture an image, AppSheet will automatically generate and store the path to the image in your cloud storage provider in your SQL table for you.

[Paul_Pillay]

Hi Dinh, when I checked the sql entry it only saved the “tablename/imagefilename”.

Im I missing something?

I created a column in my sql database (as text), then set the associated column’s datatype in Appsheet as ‘Image’. Thanks

[Harry2]

@Paul_Pillay Hi Paul, the image paths saved in the SQL table are only the relative paths of the images. The assumption is that the images will all be saved in the root folder of your app. Hence, the relative paths will only point to folder within the app’s root folder. So, if the path is “tableName_image/imageName.jpeg”, then this means that within the app’s root folder, there’s a folder named “tableName_image” that stores all images of the corresponding table, and within this image folder, there’s an image called “imageName.jpeg”. To find where the app’s root folder is, you can go to the Info > Properties tab in the editor, and check the “Default app folder” setting.

[Paul_Pillay]

I can see the images in the root folder in dropbox as you have described.

However, I am only using dropbox for the authentication to the app.

All the data is in my sql database which I have added as a datasource.

So the app works fine capturing and displaying the images.

However, I also have a windows application which also interacts with the sql database.

I am trying to show a direct URL link in my windows application to view the image captured on the app.

Im planning to roll out an sql database and associated app per customer, so I can’t hardcode the datasource path (dropbox, box etc) or app name.

I was hoping I could pull the appname when a image is captured, then use the formula to generate the URL link

[Harry2]

@Paul_Pillay I’m afraid there’s currently no expression to retrieve the app name dynamically, so you’ll need to hardcode it into the expression. Another thing to keep in mind is that you’ll need to URL encode the entire link generated by the expression. To do so, you can use the ENCODEURL({link}) function.

[Paul_Pillay]

ok thanks for your help

[Joel_Tjon-A-Tsi]

Guys!

What is the final Formula that u have created?

I have a Table where i save a drawing in a cell “Drawing image” and in the next cell “Drawing url” i want to create (automaticly) a url link that i can use as a background image for a XY column.

The “Drawing image” in the sql database the cell shows only the “table_map/image_name”.

Now my search has lead me up to use: =SUBSTITUTE(CONCATENATE and some where ENCODEURL({link}), …but how further,…

thnx in advance!

[Fabian_Weller]

Hi @Joel_Tjon-A-Tsien maybe this is helpful?

Convert an image to XY Questions

I found a solution. Please correct me if I’m wrong. In the XY Column you can use the “Background image for the XY coordinates” expression: CONCATENATE( "https://www.appsheet.com/template/gettablefileurl?appName=My_App-12345&tableName=My_Table&fileName=" , [Ref_Column].[Image_Column]) This would produce a link that will not work: https://www.appsheet.com/template/gettablefileurl?appName=My_App-12345&tableName=My_Table&fileName=My_Table::My_Table_Images/0afb8fcb.Image_Column.091309.jpg …

[Joel_Tjon-A-Tsi]

Hi Guys,

Is there a way to disable the zoom button in the map view of a XY Column?

kind regards Joel,

[Steve]

I don’t believe so.

[Joel_Tjon-A-Tsi]

Hi @Fabian,

Thnx for your response,

Yes i think so. But i have to solve the Public access issue first. The app that we build with appsheet is based on a sql data base. And because we use our microsoft account to login to the app, the images are stored in the microsoft one drive,…which is not public accessible,…

i am trying some options now, i will be back when i have some concrete questions.

thnx, joel