I have an image field type and I want it as a hyperlink in my workflow report.
How do i achieve this?
Please advise.
Thanks.
John
@John_Henry_Joseph
OR
EXPRESSION
HYPERLINK(
CONCATENATE(
"https://www.appsheet.com/template/gettablefileurl?appName=",
ENCODEURL("YourAppName-YourAccountID"),
"&tableName=",
ENCODEURL("YourTableNameHere"),
"&fileName=",
ENCODEURL([ImageColumnName])
),
"Click HERE to view the image"
)
IN TEMPLATE
<<HYPERLINK(CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=“,ENCODEURL(“YourAppName-YourAccountID”),”&tableName=“,ENCODEURL(“YourTableNameHere”),”&fileName=",ENCODEURL([ImageColumnName])),"Click,%22Click) HERE to view the image”)>>
EXAMPLE
<<HYPERLINK(CONCATENATE(“[https://www.appsheet.com/template/gettablefileurl?appName=“,ENCODEURL(“OrderApp-123456”),”&tableName=",ENCODEURL("Product](https://www.appsheet.com/template/gettablefileurl?appName=“,ENCODEURL(“OrderApp-123456”),”&tableName=",ENCODEURL("Product) Table”),“&fileName=”,ENCODEURL([Product_Images])),“Click HERE to view the image”)>>
2 Likes
Try this
[How to generate direct image URLs](https://community.appsheet.com/t/how-to-generate-direct-image-urls/34160) Tips & Tricks ?
TEXT([Image]) Put the express in a virtual column with “URL” type. If you need to store the link itself, you might need to make some changes to the row after the image is uploaded like example below. [image] [image] There’s another option to create the image URL CONCATENATE( “https://www.appsheet.com/template/gettablefileurl?appName=”, ENCODEURL(“AppName-AccountID”), “&tableName=”, ENCODEURL(“TableName”), “&fileName=”, ENCODEURL([ImageColumn]) ) But if you like to share the imag…
1 Like
I used the below code.
<
But I got the below result
The browser address is also correct.
Can you please help me out?
Thanks.
@John_Henry_Joseph
Can you please check this setting?
Security > Options > Required Image and File URL Signing is explicitly set to OFF
2 Likes
I disabled now.
But still same result.
Please advise.
Thanks.
John
Can you also verify that you have a ab9bc4a2.SamplePhoto.194702.jpg image file under appsheet > data > ERSystem-57572 > Tbl_ERChild_Images folder?
1 Like
@John_Henry_Joseph
Can you also check and verify that the default app folder property is inline with your structure?
1 Like
The default app folder … /appsheet.
But the data is being stored in different folder.
Should I change this path? like what?
please…
John_Henry_Joseph:
The default app folder … /appsheet.> But the data is being stored in different folder.> Should I change this path? like what?> please…
Definitely you shall change that, otherwise Workflow will return error as there is no any Tbl_ERChild_Images folder exists under your default app folder. As your current app folder is set under gDrive root, you can change the path string like this:
/ER SYSYEM
1 Like
@John_Henry_Joseph
May be you also need to adjust the expression in the workflow. Before changing the expression, test the previous one initially:
EXPRESSION
HYPERLINK(
CONCATENATE(
"https://www.appsheet.com/template/gettablefileurl?appName=",
ENCODEURL("ER SYSTEM"),
"&tableName=",
ENCODEURL("Tbl_ERChild_Images"),
"&fileName=",
ENCODEURL([ImageColumnName])
),
"Click HERE to view the image"
)
IN TEMPLATE
<<HYPERLINK(CONCATENATE(“[https://www.appsheet.com/template/gettablefileurl?appName=",ENCODEURL("ER](https://www.appsheet.com/template/gettablefileurl?appName=",ENCODEURL("ER) SYSTEM”),“&tableName=”,ENCODEURL(“Tbl_ERChild_Images”),“&fileName=”,ENCODEURL([ImageColumnName])),“Click HERE to view the image”)>>
EXAMPLE
<<HYPERLINK(CONCATENATE(“[https://www.appsheet.com/template/gettablefileurl?appName=",ENCODEURL("ER](https://www.appsheet.com/template/gettablefileurl?appName=",ENCODEURL("ER) SYSTEM”),“&tableName=”,ENCODEURL(“Tbl_ERChild_Images”),“&fileName=”,ENCODEURL([Product_Images])),“Click HERE to view the image”)>>
I am Sorry Mr. Levent. I failed after many attempts.
I did the following.
-
Change the default location as “/ER System”
-
Change the expression as you advised.
<
Where [SamplePhoto] is the column name.
However, I am failed and getting the same error " 404 - File or directory not found."
Please bare with me.
Thanks.
@LeventK,
Is it possible to shift my tables from “ER System” to appsheet default folder?
Because, when I tested the Image Url, it worked from default location.
https://www.appsheet.com/template/gettablefileurl?appName=ERSystem-575724&tableName=Tbl_ERChild&fileName=Tbl_ERChild_Images%2Fd64bba00.SamplePhoto.194646.jpg_q50.webp
here, Instead of appName=ERSystem-575724, i put “ER System”… the link is not working.
No idea… how do I manage.
@John_Henry_Joseph
The image URL had worked with me as well.
I may advise not changing the appname parameter in the image URL and leave it as it’s. Can you post me a screenshot from appsheet > data > ERSystem-575724 folder as well? Sorry for bothering you with these.
1 Like
Yes. You are certainly right. Physically changed the default location as you advised. But in the url coding, I kept the appname as ERSystem-575724 and you know what… its working nicely.
Love You & Appsheet.
Thanks for your continues effort in this regard.
John
2 Likes
@John_Henry_Joseph
I’m glad to hear that the issue is resolved now. Congrats for your efforts. Provided you can mark my post as the solution, other community members with similar problems might benefit from it as well. Thanks for your consideration.
2 Likes
@John_Henry_Joseph
I believe you have marked the wrong post as the solution. Post#2 shall be the correct one I believe.