Working with URL in an email

Is it possible when I send an email (notification) and put an URL in the email message which points directly to record in de form.
I know I can use the friendly URL to come to the form, but then the last step is go to the record to which the receiver of the email should look to.
Kind regards, Bert Steinebach

[QUOTE=ctmservice;22714]Is it possible when I send an email (notification) and put an URL in the email message which points directly to record in de form.
I know I can use the friendly URL to come to the form, but then the last step is go to the record to which the receiver of the email should look to.
Kind regards, Bert Steinebach[/QUOTE]

You need to call the appropiate url with parameters to guide the sql statement. So pass it like myapp.php?myparm=10 Then in your application you can refer to $_GET[‘myparm’]; Next you can assign it to a global var which is used in your sql.

Ok Albert, thanks

This is $_GET[‘myparm’] is new for me but in this way I learn every day.
Again it seems for me that there are no limits with sc
Cannot wait to implement it.

Met vriendelijke groet, Bert

Sorry, one question:

Ok I have to write a php but how to implement this in sc.
Should I make an url lik this: 127.0.0.1:98/scriptcase/app/crmdemo/communicatie/myapp.php?myparm=1o
In this “communicatie” is the friendly URL of the form
And where to put this php? In an event inside this form or where?

Regards, Bert

It’s the regular php to retrieve an url parameter. Don’t forget to use isset() to find out if the parameter you expect is there, otherwise you will get errormessages.

i want new users.to verify their email inbox. … so make an app with $_get , copy paste the url in email body which requests verification of valid email id, and email rece8ver will be able to click on link (and value in mysql will chqnge from unverifiednto verif8ed email). seems tuff…i ll try…plz make a video on dis someone…

i want new users.to verify their email inbox. … so make an app with $_get , copy paste the url in email body which requests verification of valid email id, and email rece8ver will be able to click on link (and value in mysql will chqnge from unverifiednto verif8ed email). seems tuff…i ll try…plz make a video on dis someone…

I’ve heavily customized my security module but if you create the security module and look at it you will find what you are looking for. Take a look at the form to add users (it’s called 'form_sec_users_add" or something similar); it contains all of this code:

Generate activation code (see Programming > phpMethods > act_code)
Send the mail - with the activation code (see Programming > phpMethods > send_mail_to_new_user)
User clicks that link in the email - returning to the form that created it where the activation code is verified and the user redirected (see EVENTS > OnScriptInit)

1 Like