Solved: Get Image path to put in an email - Page 2

Rene_Casana_Ama · 02-16-2020 02:09 PM

I connected Zapier to send a report to the user’s email but I want to embed the image stored in my appsheet app.

My Zapier’s email format is HTML and the path my databse shows is the following:
"Actividades_Images/024e79b3.Foto1.221009.jpg"

I don’t know how what to put before Actividades_Images/024e79b3.Foto1.221009.jpg so that the end user will see the picture loaded on the email.

Koichi_Tsuji

Or you create virtual column with app formula ;

CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=”, ENCODEURL(“YOURAPPNAMEANDID”), “&tableName=”, ENCODEURL(“YOURTABLENAME”), “&fileName=”, ENCODEURL([YOURIMAGEORFILECOLUMN]))

For example, you name this column as [URL]

Then on your email body template, you place

<<[URL]>>

or

<<hyperlink([URL], “Link to file”)>>