Links to Images in PDF WorkFlow

[Jonathan_S]

Hello Everyone,

Im creating a workflow template and am in need of displaying the links to images.

Ive set the image columns in the Workflow template format as text.

This is whats happening when clicking on the link.

In my template Im just putting in the Column name Packing Slip: <<[Delivery Slip Image]>>

Thing is, if its in the email body, the link does work?
Any suggestions?

[Jonathan_S]

Seems like the link is not wrapping itself around the cell. It is just a partial link. Any ideas on how to fix this?

Partial link in PDF

Full link in Email body

[Fabian_Weller]

Hi @Jonathan_S try using Hyperlink to an Image as mentioned at the bottom of this page:

help.appsheet.com

Template Image, Thumbnail, Drawing, and Signature Display

Displaying images, thumbnails, drawings, and signatures in templates

Or try this: Packing Slip: <<CONCATENATE([Delivery Slip Image])>>.
Or try to set the font size to 1px.

[Jonathan_S]

Ive tried the 1px,
Been trying everything. Ill try the Concatenate.

Edit: Concatenate breaks the link.

[Jonathan_S]

Im using the fuction of setting the format to text exactly for what it has been designed to do. Makes a link to the app sheet server. Anything else breaks this link.

The main problem is the text is not wrapping and at 1pt the link is unclickable, at 2pt it overflows the page.

[Fabian_Weller]

So I think it’s time to send an E-Mail to support@appsheet.com

[Jonathan_S]

Working with them all day. Was hoping someone here would have input

[Marc_Dillon]

I’ve made specific virtual columns to hold links to my images, for use in PDFs.

CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=”, ENCODEURL(“app name”), “&tableName=”, ENCODEURL(“table name”), “&fileName=”, ENCODEURL([Image]))

Then use the HYPERLINK expression in the template.

<<HYPERLINK( [imgLink] , ”IMG” )>>

Of course now you’ll have to disable a security option for this to work, as per the following post:

Call to Action for Apps Constructing URLs to GetTableFileUrl Announcements

We recently made a security enhancement wherein image and file type columns have signed URLs generated for them. This enhancement prevents an app user from changing the table name or file name parameters in order to access app files that they should not. In the near future, we are going to start requiring calls to the gettablefileurl and getappfileurl endpoints to have valid signatures. What does this mean for you? If you have an app where you are manually constructing a link to a gettablefileu…

[Jonathan_S]

Why is it that this formula Works for some images but not others?

The first one I did works, shows up bright blue in pdf,

I did 2 others from a differant table and they show up purple-ish, as in they have already been clicked on or somthing and there is no link associated with them?

Did the same thing, they all have there own virtual column, when I test the formula out in appsheet it works perfect, I can copy and past the results from the editor into my browser and I get beautiful images, but in the template, 2 of the 3 links dont work.

Any insight? You seem to have a ton of experience with this.

Edit So Trying it in a Email Template Makes it look like a Hyperlink like the working one, but doesant function.

The images are in a child Table. But Im pulling allot of other stuff from this child table with no issues. So Im not to sure.

This is my functioning one.

Non functioning. Ive tried this without checking if the Column where the Hyperlink is created from is blank etc.

In my Email Body Template Top one works, Bottom link does not work.

In My PDF Template Image A & B dont work, Delivery Slip one does.

[Jonathan_S]

@Aleksi Thank you for helping me for the past 4-5 hours to try to get this figured out.
@Marc_Dillon Thank you as well. Your Formula should be put into official documentation.

In the end Still not sure what it was, Will keep tinkering around and trying things. @Aleksi

I do believe the wrapping issue should be resolved by the team. @praveen

[Marc_Dillon]

Jonathan_S:

@Marc_Dillon Thank you as well. Your Formula should be put into official documentation.

It is. https://help.appsheet.com/en/articles/961605-displaying-images-and-documents

Jonathan_S:

Why is it that this formula Works for some images but not others?

Uh, not really much info to go on here. You can check the raw HTML output of the workflow template with the workflow Test button, see if that has any clues as to what is actually being output. Are these other images in a different spot in the template?

[Jonathan_S]

See above. Kind of different spot? Same template though.

Here @Marc_Dillon

[Jonathan_S]

Marc_Dillon:

Uh, not really much info to go on here. You can check the raw HTML output of the workflow template with the workflow Test button, see if that has any clues as to what is actually being output. Are these other images in a different spot in the template?

Ive done this and the output is good. I can copy and paste this in browser and get beautiful images. Never mind, this was with the virtual column Test. Let me try this.

Edit Ive highlighted the Difference in Bold

class=“c1”><td class=“c23” colspan=“1” rowspan=“1”><p class=“c35”><span class=“c17”><span class=“c17”><span class=“c9 c22”><a href="">Click Here - Image A

<td class=“c23” colspan=“1” rowspan=“1”><p class=“c35”><span class=“c17”><span class=“c17”><span class=“c9 c22”><a href="">Click Here - Image B<td class=“c48” colspan=“1” rowspan=“1”><p class=“c16”><span class=“c7”>Total:<td class=“c28” colspan=“1” rowspan=“1”><p class=“c16”><span class=“c9”>32,000<tr class=“c45”><td class=“c50” colspan=“2” rowspan=“1”><p class=“c8”><span class=“c0”><p class=“c11”><span class=“c26”><span class=“c9”><td class=“c48” colspan=“1” rowspan=“1”><p class=“c16 c32”><span class=“c5”><td class=“c28” colspan=“1” rowspan=“1”><p class=“c16 c32”><span class=“c9”><p class=“c8”><span class=“c0”><p class=“c8”><span class=“c0”><p class=“c8”><span class=“c0”><p class=“c8”><span class=“c0”><p class=“c8”><span class=“c0”><p class=“c8”><span class=“c0”><p class=“c8”><span class=“c0”><p class=“c8”><span class=“c0”><a id=“t.8b4b50b2f0b4052d29324”><a id=“t.16”><table class=“c12”><tr class=“c1”><td class=“c34” colspan=“1” rowspan=“1”><p class=“c11”><span class=“c7”>Received By: <span class=“c17”>Henry<td class=“c47” colspan=“1” rowspan=“1”><p class=“c8”><span class=“c9”><td class=“c25” colspan=“1” rowspan=“1”><p class=“c11”><span class=“c5”>Signature:<tr class=“c1”><td class=“c30” colspan=“1” rowspan=“1”><p class=“c11”><span class=“c17 c22 c42”><a href=“https://www.appsheet.com/template/gettablefileurl?appName=Recing-1160&tableName=Recieving%20Forms&fi...”>Click Here for Delivery Slip

Seems likes its not making a link???
Its coming from a Child Table but this really should not make a difference, I’m able to get everything else from this child table, Evan the images direct. + grandchild table.

[Fabian_Weller]

Just do double-check:

Signature is being converted to text Questions

I figured it out! Apparently the next <<If: has to start on a new line. I changed the format to: <<If: AND(NOT([Employee Refusal]), [Employee Available])>> <<[Employee Signature]>> <<EndIf>> <<If: OR([Employee Refusal], NOT([Employee Available]))>> <<IFS( [Employee Refusal], “EMPLOYEE REFUSED”, NOT([Employee Available]), “EMPLOYEE UNAVAILABLE” )>> <<EndIf>> After I moved that to a new line I received the error for the missing on the employee signature, regardless, it works as intended now. Th…

[Jonathan_S]

OK, been trying out allot of random stuff.

I Instead of putting the hyperlink in, i change 1 of the 2 to the acual image where the hyperlink is being build from.

The one in greed works, while the one in red just makes a broken link. Does-ant function. Im completely lost here

[Jonathan_S]

@Aleksi Im not able to message you. Conversations Closed. but I tested with new image and record and old image and record.
Also tried contacting support, filled everything in 3 times and it just says url broken,

[Jonathan_S · Accepted solution]

Guys,

You wont believe this facepalm.
I just figured it out.
It was not in one of my slices. Usually this doesn’t matter but I was using a slice to rearrange a grandchild table.

Hopfully this will help save some grief from someone else,

Stay safe everyone,

Thanks!!! Awesome support.

[Fabian_Weller]

Slices are killing me too on a regular basis