Creating url link of a list of pictures in an emai...

Lucas_Cuypers · 05-15-2019 06:07 AM

HI all,

i have an app where the user is taking many pictures to create a report of a machine.
this report (pdf) is send together with the pictures in HD in attachment.

the problem is that these pictures are to heavy and that the system can not sent it wen to many pictures have been created.

the user can add as many pictures as needed.

is there a way to write a code so i get them as a list of links to my google cloud so they are not that heavy ?

I have one table for pictues with diffrent reference fields depending of the topic of the picture.
the timestamp of the report is looked up and if the picture is a match it is added to the email as an attachment.

select(Machine_Transfer_Pictures[Picture],
or([Picture Typeplate]=[_THISROW].[Timestamp],
[Pictures all sides ( MIN 5 )]=[_THISROW].[Timestamp],
[Picture Display with hours]=[_THISROW].[Timestamp],
[Picture Fuel & ADBLUE level]=[_THISROW].[Timestamp],
[Detail pictures abnormalities / damage]=[_THISROW].[Timestamp]))

is there a way to create url links of this for each picture so it will not be that heavy.

thanks

Phil

You can display the image value as URLs.
I have updated the following article to explain how to do this.

Vivian_Nowka-Ke

Hi Phil,
When using a workflow template format rule for an image column, changing the size works, but when I changed it from “Small” to “Text”, the workflow data all changed to text value. Hopefully these pictures explain more.
Here’s a capture of an email showing the image as “Small”:

And here’s a capture of the format rule now set to “Text”:

And then, after no change to the workflow template, here’s a capture of an email:

Any advice on how to show the image URL instead of the image?
Thanks,
- Vivian.

UPDATE: I got it working using HYPERLINK(). I had trouble with it because the AppSheet help site seemed to cut off the formula as shown below:

The full formula is:

<<HYPERLINK(CONCATENATE("https://www.appsheet.com/template/gettablefileurl?appName=YourAppName&tableName=YourTableName&fileName=", TEXT([Image Column])), "Link Name")>>

Phil

Hi Vivian,

I am glad you got it to work, but you should not need to hand construct a Hyperlink.

Can you provide the following:

Your account id
The app name
The workflow rule name

kalanshovka

Hello, please tell me the solution to the problem is not to manually create a hyperlink

Koichi_Tsuji

I understand Phil is saying we should use select expression to generate table with multiple rows with hyper link to image files.

kalanshovka

Hello. Is it possible that when you click on an image it opens in a browser???

Koichi_Tsuji

In the template and PDF? I don’t think so.

kalanshovka

Inaccurately asked a question. Sorry.

kalanshovka

I need the hyperlink to look like an image in the application and when I click on the image a browser opens.

kalanshovka

Is it possible

kalanshovka

the browser opens the image by link

kalanshovka

Help me please, I really need it

Phil

Koichi is correct. It is not currently possible, to the best of my knowledge. The Hyperlink can contain clickable text but not an image.

Creating url link of a list of pictures in an email