fetch lookup data in email notification
Hello.
I don't understand
what's wrong, please help:
I have Form1
named "ICD" with lookup field "surgeon" to
field "surgeon_add" in other form named
"Surgeons_add .
So i tried to fetch data to
show
the actual data in lookup
field on email notification
form ICD > On Success:
-
surgeons
= ICD [ID == surgeon];
-
test
= surgeons.surgeon;
then in sendmail I tried all variations
- sendmail
- [
-
from:zoho.adminuserid
-
to:"ill@gmx.com"
-
subject:"123"
-
message:test + "<br />\n" + surgeons +
"<br />\n" + surgeons.ID +
" <br />\n" + surgeons.surgeon
-
content type:HTML
- ]
In script builder this code are:
-
<%=test%>
-
<%=surgeons%>
-
<%=surgeons.ID%>
-
<%=surgeons.surgeon%>
Mail text:
null
ICD[ No
Matching ]
null
null
In script builder:
- input.surgeon.surgeon_add
Error
at line number : 1 surgeon_add doesn't exist in
surgeon fields dependency form Surgeons_add |
In forms and reports data show me correctly.
Any ideas?