Help with workflow link to app

Two related questions.
I have a workflow that emails me when the user submits something I need to approve. I get the email just fine. I want to include a link that would take me to the App, not in the browser, and to the specific record that prompted the email. That way I can quickly approve it.

I’m doing something wrong. The link takes me to my app, in the browser, but not to the the view I specified.

  1. can I have the link open in the App not in the browser?

  2. how can I get it to go to the specific form I want?

<<[Encouragement_NO]>>
Title: <<[Title]>>
Text: <<[Text]>>
By: <<USEREMAIL()>> on <>

<a href="<<CONCATENATE(“https://www.appsheet.com/start/xxxxxxxxxxMyApp#xxxxxxx”,LINKTOROW([Encouragement_NO],“ Admin_User_Submitted_Encouragements_Form”))>>">Link to the User Submitted Encouragement

Thanks.
Lucinda

You might be better off using one of these:

Thanks Steve.

That does take me directly to the form, slick.

Is there a way to have it open the App on my phone instead of going to the browser version of the app?

I’m using: <<_ROW_WEB_LINK>> : Hyperlink that refers to the added or updated record in your app. For example, you can include this URL in a workflow email to allow the email recipient to easily open the added or updated record, displayed as ‘Click Here’ hyperlinked.

Which makes it sound like it would open the app. (refers to the added or updated record in your app)

I honestly do not know. :frowning:

No way! If not you, who should I ask? @praveen?

support@appsheet.com?

1 Like

Sent them an email.

1 Like

This is Support’s reply: My understanding from engineering is:

If you write it like <<"[https://www.appsheet.com/start/xxxxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx#control=TableName_Detail&row="&ENCODEURL([ID])]>>

it should ask to open it either with the browser or Appsheet app.

I haven’t had a chance to try this. I need to research ENCODEURL to see what to put there. Any suggestions before I go hunting?

I think the idea/expectation is that your device will recognize a URL that begins https://www.appsheet.com/start/ as one that should be handled by the app rather than the browser. I’d have the same expectation if the app is properly installed and you haven’t tinkered the device’s deeper settings. So the question is: how do we generate such a URL? I would have expected <<_ROW_WEB_LINK>> to provide that.

Please right-click on the link provided by <<_ROW_WEB_LINK>> and cut and paste it here so we can inspect it.

1 Like

This is what I get when I click and copy the link from the email produced by the workflow.
https://mandrillapp.com/track/click/30578143/www.appsheet.com?p=eyJzIjoiYzhSeEc2cXdyRlRQVElfb0I5aXNaMk9qMGdBIiwidiI6MSwicCI6IntcInVcIjozMDU3ODE0MyxcInZcIjoxLFwidXJsXCI6XCJodHRwczpcXFwvXFxcL3d3dy5hcHBzaGVldC5jb21cXFwvbGlua1xcXC85ZDQwZTA4OS0wNzhkLTQxNjktYjJhMC0xMTM4NDJlYzBjMmM_X2FwcE5hbWU9UmVxdWVzdHNfRmFtaWx5LTEyOTY2NzcmX3Jvdz03ODY2MTk2MyZfdGFibGU9VXNlcl9TdWJtaXR0ZWRfRW5jb3VyYWdlbWVudHMmdXRtX21lZGl1bT1lbWFpbCZ1dG1fc291cmNlPXRyYW5zYWN0aW9uYWwmdXRtX2NhbXBhaWduPVdvcmtmbG93K0VtYWlsXCIsXCJpZFwiOlwiNWU1ZGQ0ZjBhM2QyNGEyMGJlYjM0YzE3ZjllNzMyMjRcIixcInVybF9pZHNcIjpbXCI5ZWQwNDNhYjYzZGRiMTMyMTJmNWUzMDk2ZjgxZWMzMmY5Njg2ZjE4XCJdfSJ9

This is what appears in the browser when you click on the link on my iPhone;
https://www.appsheet.com/start/9d40e089-078d-4169-b2a0-113842ec0c2c?refresh=1&wipe=1#_appName=Requests_Family-1296677&_row=78661963&_table=User_Submitted_Encouragements&utm_campaign=Workflow+Email&utm_medium=email&utm_source=transactional&page=detail

Any idea why the difference?

I copied the second one, the one that appeared in the browser, when I clicked the link on the iPhone and pasted that into the workflow, instead of the <<ROW_WEB_LINK>> and it opened the app. It DID NOT take me to the specific record/view in the app where I can approve the item. The previous link did take me to that specific record/view in the web browser.

There must be a bug causing the creation of the URL behind <<ROW_WEB_LINK>> that adds in all that extra stuff.

The first allows the company that handles sending the app emails, mandrillapp.com, to track when the email recipient clicks on the email link. The click is logged, then the user is sent to the URL you finally ended up on. It’s that final URL that matters here (hopefully).

Hooray! Progress!

Boo! Setback!

Let’s go back to what you tried originally:

<a href="<<CONCATENATE(“https://www.appsheet.com/start/xxxxxxxxxxMyApp#xxxxxxx”,LINKTOROW([Encouragement_NO],“ Admin_User_Submitted_Encouragements_Form”))>>">Link to the User Submitted Encouragement

Instead, let’s try:

<a href="<<CONCATENATE(“https://www.appsheet.com/start/9d40e089-078d-4169-b2a0-113842ec0c2c”,LINKTOROW([Encouragement_NO],“Admin_User_Submitted_Encouragements_Form”))>>">Link to the User Submitted Encouragement</a>
1 Like

Hi @Lucinda_Mason and @Steve,
Im doing something similar to this for a WhatsApp message. The idea is to send a link to a particular row of the app via a WhatsApp Message.
With help of this post, some other posts, and a couple of hours, this is what worked for me, hope it works for you too:

CONCATENATE(“https://www.appsheet.com/start/a47408ed-c648-4d73-b43d-d02b9499fa9d”,encodeurl(LINKTOROW([_THISROW], “Servicios_Detail”)

This is the result im getting, with all the preformatted text in the message:
image

2 Likes

Thanks Nicolás. I’m glad you got something working. Does yours open the app or in the browser?

I’m still having issues with my current link actually syncing when I explicitly have it syncing. On my phone, I click it and it shows the App syncing but it only takes me to the opening view of the App, regardless of whether the app was open or not. Then, if I click the link again, it takes me to the exact view I need.
It ONLY happens on this link.
<a href="https://www.appsheet.com/start/922dbed2-5196-4caa-9581-401fc815a472#appName=Requests-1778436&page=detail&row=<<[Encouragement_NO]>>&table=Admin_User_Submitted_Encouragements&view= Admin_User_Submitted_Encouragements_Form&at=<<ENCODEURL(NOW())>>">Click here to Approve User Submitted Encouragement</a>

Another table and view and this link format works perfectly here. The only difference is ‘page=detail’ versus ‘page=form’ above. Though I tried that as well in the example above and it didn’t change anything.
<a href="https://www.appsheet.com/start/922dbed2-5196-4caa-9581-401fc815a472#appName=Requests-1778436&page=detail&row=<<[PR_NO]>>&table=All_Active_Private_Requests_Visible_to_User&view=All_Active_Private_Requests_Visible_to_User_detail&at=<<ENCODEURL(NOW())>>">Please click here to add your prayer for this request.</a>

Why, oh why, is this so complicated?

Does yours open the app or in the browser?

Depending on what device Im using. If I´m in my computer, then its the browser. If I´m using my phone, it opens the app.

Although it seems that it doesnt run as smooth for browsers, since sometimes I get the same result as you,

I click it and it shows the App syncing but it only takes me to the opening view of the App, regardless of whether the app was open or not.

and some other times it does take me directly to the row, Im not sure why.

1 Like