Performing a Look-up within a Function
Hi -
I'm having trouble fetching a string value in conjunction with a Function that uses a Form Object Argument. I have a Tasks Form that uses a look-up to Project_Name from another form....once a Task is Completed I would like to be able to press a custom action button to have it marked completed and logged in a separate Project_Notes form. The code below is working but it is giving me a numerical value for the Project_Name in the confirmation email. Normally I'd do a look-up but this doesn't seem to work within the Function section. Any tips on converting that Project_Name to a string value in the email subject line? Thanks
- void Completed(Tasks Completed)
- {
- Completed.Status = "Completed";
- insert into Project_Notes
- [
- Added_User = zoho.loginuser
- Document_Date = zoho.currentdate
- Name = Completed.Project_Name
- Notes = Completed.Task_Description
- ]
- sendmail
- (
- To : zoho.loginuserid
- From : "noreply@zohocreator.com"
- Subject : "A task for " + Completed.Project_Name + " has been completed"
- Message : zoho.loginuserid + " has marked the following task as completed:<div><br><div>" + Completed.Task_Description + "<br></div><div><br></div><div>This has been converted to a Project Note.</div></div>"
- )
- }