Hyperlink in Database to link back to the app details

[Roger_Wareham]

Create a hyperlink automatically when an entry gets saved in the database to refer back to this entry in the app.

So when you are reviewing the data in another platform, it will show a hyperlink to select it to return to the app and the single entry. 

Now, we have to save the entry, copy the full web address, and open the same data to add a hyperlink to the form. Once saved, the hyperlink will appear in the database, and we can select it to return to the details in the app.

Can the system do this automatically? 

please help

[Mauricio_Bick · Accepted solution]

Check this out.  
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Building-own-URL-Link-to-a-Record-in-Email-SMS/...

These two formulas work.

<<HYPERLINK(CONCATENATE("https://www.appsheet.com/start/{AppID}?refresh=1&wipe=1", LINKTOROW([Key Goes Here],"Detail View Goes Here")), "Click Here")>>

<<CONCATENATE("https://www.appsheet.com/start/{AppID}?refresh=1&wipe=1", LINKTOROW([Key Goes Here], "Detail View Goes Here"))>>

[Mauricio_Bick · Accepted solution]

Check this out.  
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Building-own-URL-Link-to-a-Record-in-Email-SMS/...

These two formulas work.

<<HYPERLINK(CONCATENATE("https://www.appsheet.com/start/{AppID}?refresh=1&wipe=1", LINKTOROW([Key Goes Here],"Detail View Goes Here")), "Click Here")>>

<<CONCATENATE("https://www.appsheet.com/start/{AppID}?refresh=1&wipe=1", LINKTOROW([Key Goes Here], "Detail View Goes Here"))>>

[Roger_Wareham]

Can the result show the full web address in the database cell?

[Mauricio_Bick · Accepted solution]

Add a Column in your DB and name it URL or whatever you want.  Regenerate your table structure and add this CONCATENATE("https://www.appsheet.com/start/{AppID}?refresh=1&wipe=1", LINKTOROW([Key Goes Here], "Detail View Goes Here")) to the App formula of that the newly added column.