Help with Concatenate and LinktoRow expression

[Jared12345]

Hi I put this expression together for an action to send an email, as I want to send a notifcation when a collection note has been created but I am struggling to get it to give me the entire URL.

What am I doing wrong?

EncodeURL(concatenate("Please take a look at the Collection Note relating to purchase order, ",
[CN_PO_#],"
",
LINKTOROW([CN_ID], "Collection Notes Reordered_Detail", "ProductiontrackerforKremFoodservicesInc-2892034"),"Click here for details"))

[Joseph_Seddik]

LINKTOROW() is a navigation function that let's you navigate to another app view. I don't understand what this has to do with sending an email.

[Jared12345]

Hi, thanks for the response. 

Sorry that I wasn't clear.

The concatenate is in the body of the email, with the intention that once a user completes a collection note he can drop the admin an email to notify her that this has happened and she can click on the linktorow to be taken to the detail view for that record. 

The email action works, it just doesn't complete the URL as desired. 

The concatenate returns this in the body of the email.

Please take a look at the Collection Note relating to purchase order, 9904196

ProductiontrackerforKremFoodservicesInc-2892034#control

[Steve]

The output of LINKTOROW() should not be subject to ENCODEURL().

You;ll also need to use HYPERLINK() to get "Click here for details" to work (though I don't know if it will here).

[Joseph_Seddik]

Further to @Steve's advice, please also check this post:

Deep link URL - Google Cloud Community  

[Jared12345]

Good morning, further to this issue I went back to trying to put it together like this,

concatenate("Please take a look at the Collection Note relating to purchase order, ",
[CN_PO_#], "
",

"https://www.appsheet.com/start/933f1126-4186-4bcd-a929-58d961f296aa#appName=ProductiontrackerforKrem...",[CN_ID],"&sort=%5B%7B%22Column%22%3A%22Date%22%2C%22Order%22%3A%22Ascending%22%7D%5D&table=Collection+Note&view=Collection+Note_Detail" )

But in the email body it cuts off at https://www.appsheet.com/start/933f1126-4186-4bcd-a929-58d961f296aa#appName.

So I tried the following.

"https://www.appsheet.com/start/933f1126-4186-4bcd-a929-58d961f296aa#appName","=ProductiontrackerforKremFoodservicesInc-2892034&group=%5B%7B%22Column%22%3A%22Date%22%2C%22Order%22%3A%22Ascending%22%7D%5D&page=detail&row=",[CN_ID],"&sort=%5B%7B%22Column%22%3A%22Date%22%2C%22Order%22%3A%22Ascending%22%7D%5D&table=Collection+Note&view=Collection+Note_Detail" )

During both tries when I run a test I get this result...

Please take a look at the Collection Note relating to purchase order, 9904196 https://www.appsheet.com/start/933f1126-4186-4bcd-a929-58d961f296aa#appName=ProductiontrackerforKrem...

This works but when put into practice, it opens up Gmail and then cuts the link off at #appName.

Any ideas?

[Jared12345 · Accepted solution]

I needed to add ENCODEURL(concatenate("Please take a look at the Collection Note relating to purchase order, ",
[CN_PO_#], "
",

"https://www.appsheet.com/start/933f1126-4186-4bcd-a929-58d961f296aa#appName=ProductiontrackerforKrem...",[CN_ID],"&sort=%5B%7B%22Column%22%3A%22Date%22%2C%22Order%22%3A%22Ascending%22%7D%5D&table=Collection+Note&view=Collection+Note_Detail" ))