Emailing lookup field but placing this as an ID or number rather than text
Hi there,
First time poster and have been a user of Zoho Creator for approx 6weeks so forgive my ignorance as I learn to code.
We have a need to send an email to a specific email address with some of the fields triggered by the submission of a form.
In the form their is a lookup field that pulls a 'Chlild_Name' from another APP. When i place the simple code snippet of input.name into the deluge code for the email. It displays as a series of digits. Any chance I can change this?
The below is the code that I am using to send the email:
sendmail
[
from :zoho.loginuserid
to :"email address"
subject :"Payment Completed for" + input.Municipality
message :"Hi there Accounts please find attached a payment for <div><br></div><div>" + input.Child_Name + input.Sport_Club + input.Cost_Centre + input.Cost_Centre + input.Amount
content type :HTML
Attachments :file:input.Invoice_Submission
]
It also appears to rename the attachment with that string too, anyway to change this?
Help much appreciated.
Cheers
L