On Grid upon submitting a record send email including some of the fileds

[cibsrk]

Hi All,

I'm testing Alpha5 version 11 :

Using Grid\ Web Component\Grid\Enter record Form(DBF),
We would like to send email upon submitting a record.

There are some fields that need to be included with in the Email:

User_name
Last_name
case_num

Any help would be nice.

Thanks,

Ebi

[billamidon]

Re: On Grid upon submitting a record send email including some of the fileds

Have you seen this thread?
http://msgboard.alphasoftware.com/al...ord-is-inerted

[cibsrk]

Re: On Grid upon submitting a record send email including some of the fileds

Yes I did try :

function AfterInsertRecord as v (e as p)
addr = "[email protected]"
subject ="this is a test"
body = "This is a test"
email_send(addr,subject,body,"","","",.T.,"","","default",.F.,.T.)
end function

But nothing happens, just the database table "DBF" gets updated.
If I change "email_send" to "email_send2"
then, upon submitting the record I get error:

Error executing afterInsertRecord event handler: command: email_send2(addr,subject,body,"","","",.T.,"","","default",.F.,.T.) Variable is of different type


in addition to the above code, I have setup the "Web Components" \ Project Prosperity\Email Settings:

SMTP Server: smtp.servername
SMTP Server port: 465
SSL Option: SSL
E-mail Account User Name: my username
E-mail Account password: my email password
From address: my address
From Alias: my Alias

Also, setup the E-mail OutBox and Repository Settings as "DBF".

Any idea why system is not sending an email?

Thanks in advance,

Ebi

[cibsrk]

Re: On Grid upon submitting a record send email including some of the fileds

Yes, I did try the example but no email get send out, the only changes happens is the table gets update with the submitted record.
In adddetion to this setup I also setup the �web Components\Project Properites\E-mail Settings\E-mail Outbox with all the requirements.

If I change the :
function AfterInsertRecord as v (e as p)
addr = "[email protected]"
subject ="this is a test"
body = "a test this is"
email_send(addr,subject,body,"","","",.T.,"","","default",.F.,.T.)
end function

to:
function AfterInsertRecord as v (e as p)
addr = "[email protected]"
subject ="this is a test"
body = "a test this is"
email_send2(addr,subject,body,"","","",.T.,"","","default",.F.,.T.)
end function

Then I get the following error:
Error executing afterInsertRecord event handler: command: email_send2(addr,subject,body,"","","",.T.,"","","default",.F.,.T.) Variable is of different type



Thanks for any help.

Ebi

[cibsrk]

Re: On Grid upon submitting a record send email including some of the fileds

I was able to use “edit Filed Rulles\Record Events\OnsaveRecord” using “Built-in Alpha Five e-mail client”

So, on Save record Alpha5 sends email, but I still need to add some fields within that email.
How can I add some fields from that table?
Thanks for any help.

Ebi