Hyperlink in PDF template

[Quality_Assuran]

Hi community,

I have this expression in my PDF template

<<HYPERLINK(CONCATENATE( “https://www.appsheet.com/start/f8ed07d8-cca0-44d8-8b79-8d830837934a”,LINKTOVIEW("Equipment_Detail")),"Equipment List”)>>

The link works but it creates this text.

Please advise on where I might be going wrong?

[Aurelien]

Hi @Quality_Assuran 

What about this?

<<HYPERLINK(CONCATENATE( “https://www.appsheet.com/start/f8ed07d8-cca0-44d8-8b79-8d830837934a”,ENCODEURL(LINKTOVIEW("Equipment_Detail"))),"Equipment List”)>>

or

<<HYPERLINK(ENCODEURL(CONCATENATE( “https://www.appsheet.com/start/f8ed07d8-cca0-44d8-8b79-8d830837934a”,LINKTOVIEW("Equipment_Detail"))),"Equipment List”)>>

[Quality_Assuran]

@Aurelien thanks for the response. That fixed the way it looks in the PDF. Both times it looked like this

But it doesn't direct me to the PDF. I get these two errors

For the first one.

For the second one

[Aurelien]

Hi @Quality_Assuran 

At looking to the documentation: 

LINKTOVIEW() - AppSheet Help

Which makes me think that the HYPERLINK() expression could be this way: 

<<HYPERLINK(LINKTOVIEW("Equipment_Detail", "yourAppName"),"Equipment List”)>>

The app name can be found in the URL:

[Quality_Assuran]

I tried a bunch of different options

<<HYPERLINK(CONCATENATE(“https://www.appsheet.com/start/f8ed07d8-cca0-44d8-8b79-8d830837934a”,ENCODEURL(LINKTOVIEW("Equipment_Detail"))),"Equipment List”)>>
<<HYPERLINK(ENCODEURL(CONCATENATE(“https://www.appsheet.com/start/f8ed07d8-cca0-44d8-8b79-8d830837934a”,LINKTOVIEW("Equipment_Detail"))),"Equipment List”)>>
<<HYPERLINK(CONCATENATE(“https://www.appsheet.com/start/f8ed07d8-cca0-44d8-8b79-8d830837934a”,LINKTOVIEW("Equipment_Detail")),"Equipment List”)>>
<<HYPERLINK(ENCODEURL(CONCATENATE(“https://www.appsheet.com/start/f8ed07d8-cca0-44d8-8b79-8d830837934a”,LINKTOVIEW("Equipment_Detail"))),"Equipment List”)>>



<<HYPERLINK(CONCATENATE(“https://www.appsheet.com/start/f8ed07d8-cca0-44d8-8b79-8d830837934a”,LINKTOROW(index(Equipment[Equip_ID],1),"Equipment_Detail")),’Equipment List’)>>

These were the results

The ones that don't look good work and the ones that do, don't.

On another doc, I have this link and it works so I'm not sure why this one does not?

<<HYPERLINK( CONCATENATE( "https://www.appsheet.com/start/a90a4f18-11e0-4ca5-9e2b-9484d3be2450", LINKTOROW( [Meeting_ID], "Meetings_Detail" ) ), "Click here" )>>

[Quality_Assuran]

@Aurelien sorry I missed your other post, I tried that now did the following:

<<HYPERLINK(CONCATENATE(ENCODEURL(LINKTOVIEW("Equipment_Detail", "FSMS-3102900")),"Equipment List”)>>
<<HYPERLINK(CONCATENATE(ENCODEURL(LINKTOVIEW("Equipment_Detail","f8ed07d8-cca0-44d8-8b79-8d830837934a")),"Equipment List”))>>

<<HYPERLINK(LINKTOVIEW("Equipment_Detail","f8ed07d8-cca0-44d8-8b79-8d830837934a"),"Equipment List”)>>

And got this result 😞

Not sure what else to try?

[Suvrutt_Gurjar]

Could you please try 

<<HYPERLINK(“https://www.appsheet.com/start/f8ed07d8-cca0-44d8-8b79-8d830837934a#view="Equipment_Detail"),"Equipment List”)>>

[Quality_Assuran · Accepted solution]

So what I did to fix this was remove the "space" between Equipment and List. I added an underscore. Equipment_List and got this.

Which is way better than the alternative. Thanks for all the assistance @Aurelien 

[Suvrutt_Gurjar]

@Quality_Assuran 

Excellent. Could you share your final working expression for the benefit of the community?