Solved: Action button to sent row detail with Link of the ...

G_S · 12-29-2020 11:02 PM

If user click the action button ,
Whats app will open and the row details will be prefilled as shown in below image

I want the link, attached to that which user can click and view the row
Suggest any expression to achieve this.

MultiTech

Still in the works (I have other projects I’m working on, all my time here is volunteered - plus it was New Years lol), but here’s the formula that I used for the action to launch into WhatsApp

concatenate(
	"https://wa.me/", 
  [Phone Number],
  "?text=",
  EncodeURL(concatenate(
  [Output],"

", "https://www.appsheet.com/start/5bd75778-0f27-480a-bef7-83f849bd487d#appName=WhatsAppMessageLauncher-96620&group=%5B%5D&page=detail&row=",
    [Key],
    "&sort=%5B%5D&table=Messages&view=Message_Detail"
)))

You’ll need to modify the URL portions of things so they work right.

View solution in original post

MultiTech

LinkToRow() will provide you with the URL needed to get to a specific row in your app;

I think in order for the text of the URL to be interprested by WhatsApp as a URL, you’ll need to send that link separately - otherwise the link might be just included in the string and considered text. (I have no idea, just guessing; please let me know either way. )

I would use a formula like this for the message and details (including the link):

CONCATENATE("https://api.whatsapp.com/sent?&text=", 
EncodeURL(Concatenate(
"Match Organized by: ", [Organiser Name], "
Match Date: ", [Match Date], "
City: ", [City], "

", HYPERLINK(
  LinkToRow([RowID], "Table_Detail_View"), 
  "Click here for details"
))))

Notice at the end of some of the lines, I’ve got a single double quote, then a line break - this works just like you would think: the link break is included in the output. (^_^)

If the link wasn’t rendered in WhatsApp as an actual URL that you can click on, I would separate it out and try that way.

If that didn’t work, I would remove the HYPERLINK() from things and just use LINKTOROW() - but that will produce a nasty looking URL, but you have to do what you have to do.

Hope it helps!

G_S

I am Getting this Error.

Steve

G_S

I am getting same Problem ,can you help me with the expression

Steve

LINKTOROW() produces a value of type App, not of type Url or Text. You could try wrapping it in CONCATENATE() to convert it to Text:

CONCATENATE(LINKTOROW(...))

Also, LINKTOROW() does not produce a fully-qualified URL. You’ll need to explicitly prefix its result with your app’s base URL.

MultiTech

Apologies for the delay; upon checking this functionality, I found it was more complex of a solution than originally anticipated.

I’m in the process of building a sample app with the solution; should be ready later today/this evening.

G_S

Sure, share me the sample app, it may useful

G_S

Can you please help me with the sample application ,if ready can you share me the link
I am still getting hyperlink error

MultiTech

Still in the works (I have other projects I’m working on, all my time here is volunteered - plus it was New Years lol), but here’s the formula that I used for the action to launch into WhatsApp

concatenate(
	"https://wa.me/", 
  [Phone Number],
  "?text=",
  EncodeURL(concatenate(
  [Output],"

", "https://www.appsheet.com/start/5bd75778-0f27-480a-bef7-83f849bd487d#appName=WhatsAppMessageLauncher-96620&group=%5B%5D&page=detail&row=",
    [Key],
    "&sort=%5B%5D&table=Messages&view=Message_Detail"
)))

You’ll need to modify the URL portions of things so they work right.

G_S

Tqsm ,Its working now, happy new year

Action button to sent row detail with Link of the row in what's app