Creating url link of a list of pictures in an email

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

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

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:
hyperlink
The full formula is:

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

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:

  1. Your account id
  2. The app name
  3. The workflow rule name