Link to the current report
I have this formula to create a link to the report. URLRoot() & "db/" & Dbid() & URLEncode("?a=dr&rid=") & ToText([ID]) It works sometimes and sometimes it is blank
Forum Discussion
what am i doing wrong here?
The link is correct but when i put it in the body:
"Please Note a Supplier Corrective Action Report (SCAR) " &[CAR ID] & " has been assigned to you."&
"%0D%0A" &
"%0D%0A" &
"Finding/ Issue: " &[Finding / Issue _] &
"%0D%0A" &
"%0D%0A" &
"To complete the Corrective Action click on this Link: " &
[Link to record] &
"%0D%0A" &
"%0D%0A" &
"If you have any questions please reply to this email."&
"%0D%0A" &
"%0D%0A" &
"Thank you!"
That then gets put into the email to the supplier:
"mailto:"&""&[Supplier E-Mail Address]
&"\n"&"?Subject="&"\n"&[Subject]
&""&"&body="&"\n"&[Body]
Something goes wrong.
"Please Note a Supplier Corrective Action Report (SCAR) " &[CAR ID] & " has been assigned to you."&
"%0D%0A" &
"%0D%0A" &
"Finding/ Issue: " &[Finding / Issue _] &
"%0D%0A" &
"%0D%0A" &
"To complete the Corrective Action click on this Link: " &
[Link to record] &
"%0D%0A" &
"%0D%0A" &
"If you have any questions please reply to this email."&
"%0D%0A" &
"%0D%0A" &
"Thank you!"
That then gets put into the email to the supplier:
"mailto:"&""&[Supplier E-Mail Address]
&"\n"&"?Subject="&"\n"&[Subject]
&""&"&body="&"\n"&[Body]
Something goes wrong.