Link from email to Apsheet view

[dariusw]

I'm constantly facing problem with simple need. I want to sent confirmation email to the user after [status] value is changed in column. Bot is working properly, after new position is edited and user runs action "send to another user" an email run to proper email box. I want to have basic info inside email body and I did it corretly. The problem is that I want to ad link to email body to make it possible to use it by user and run to proper view in app. There is one condition - it have to be universal solution. I tried:

HYPERLINK(
CONCATENATE(
"https://www.appsheet.com/template/AppDef?appName=",
TEXT(
LINKTOVIEW(
"potrzeby_szkoleniowe",
CONTEXT(
AppName
)))),
"link"
)

but it gives me link as it is below, without link name but all information visible. It is not sending me back to view, too:

https://www.appsheet.com/template/AppDef?appName="my proper aplication id"#control="name_of_my_view"

Any idea whats wrong?

[AleksiAlkio]

It sounds like you would want to open the app for the user, not through the editor. Try to use something like..

<<CONCATENATE(
"https://www.appsheet.com/start/YourAppID",
LINKTOVIEW("potrzeby_szkoleniowe"))>>

[dariusw]

Thank you. I did like that but it is not expected solution. Its hardcoded
into app settings. If I copy app I will have to change it. Im looking for
solution to automatically check full path from "http" to combine full link
to view from outside. I can see that kind of links in views deeplinks but
only to copy it and use. But app knows that path. Question is if app is
keeping it as a variable accessible by some function.

Z poważaniem / Best regards


Dariusz Wierzbowski
Specjalista ds Elektroautomatyki
Dział Techniczny

(PII Removed by Staff)
<>
Plastica Sp. z o.o.; NIP 878 172 84 90;
Frydrychowo 55, 87-410 Kowalewo Pomorskie, Polska;
zarejestrowana w Sądzie Rejonowym w Toruniu, VII Wydział Gospodarczy; KRS
nr 0000173291; BDO nr 000018502;
kapitał zakładowy (kapitał wpłacony): 150 000 000 zł.
[image: [TZMO]] <>

--
Spółka posiada status dużego przedsiębiorcy w rozumieniu ustawy z dnia 8
marca 2013 r. o przeciwdziałaniu nadmiernym opóźnieniom w transakcjach
handlowych.

[AleksiAlkio]

Try with https://www.appsheet.com/start/?appName=YourAppName-1234567#control=potrzeby_szkoleniowe

[dariusw]

Guys, thank you for help but I dont look for static solution. I want to
have my app independent and automatically detect http path for every
localization, after app is shifted from previous pos without editing that
path by hand.

Z poważaniem / Best regards


Dariusz Wierzbowski
Specjalista ds Elektroautomatyki
Dział Techniczny

(PII Removed by Staff)
Plastica Sp. z o.o.; NIP 878 172 84 90;
Frydrychowo 55, 87-410 Kowalewo Pomorskie, Polska;
zarejestrowana w Sądzie Rejonowym w Toruniu, VII Wydział Gospodarczy; KRS
nr 0000173291; BDO nr 000018502;
kapitał zakładowy (kapitał wpłacony): 150 000 000 zł.
[image: [TZMO]] <>

--
Spółka posiada status dużego przedsiębiorcy w rozumieniu ustawy z dnia 8
marca 2013 r. o przeciwdziałaniu nadmiernym opóźnieniom w transakcjach
handlowych.

[AleksiAlkio]

Well.. as you know, the app name you can read dynamically. 
<<"https://www.appsheet.com/start/?appName="&CONTEXT(AppName)&"#control=potrzeby_szkoleniowe">>

[dariusw]

I will try that again. It have sent not valid link address to email body
last time and I was looking for full variable starting from http.....
Z poważaniem / Best regards


Dariusz Wierzbowski
Specjalista ds Elektroautomatyki
Dział Techniczny

mobile:(PII was Removed by Staff) email:(PII was Removed by Staff) [image: [TZMO]]
<>
Plastica Sp. z o.o.; NIP 878 172 84 90;
Frydrychowo 55, 87-410 Kowalewo Pomorskie, Polska;
zarejestrowana w Sądzie Rejonowym w Toruniu, VII Wydział Gospodarczy; KRS
nr 0000173291; BDO nr 000018502;
kapitał zakładowy (kapitał wpłacony): 150 000 000 zł.
[image: [TZMO]] <>

--
Spółka posiada status dużego przedsiębiorcy w rozumieniu ustawy z dnia 8
marca 2013 r. o przeciwdziałaniu nadmiernym opóźnieniom w transakcjach
handlowych.

[dariusw]

Ok, I have found working solution. I used concatenate() and context(AppName) to construct proper string. It was wrapped without success by Hyperlink()  and, in the end, in email body I put simple <a href....> html construction. After email was sent to recipients they can see and use "link to App" only with hidden http.... path. Not elegant but working. Thak you for help. 

[AleksiAlkio]

Excellent!