I have been through several of the pages that describe how to fetch records from 1 form and use in another, but I still am having a problem. Here's the set-up:
Form 1 collects the name of projects in Project_Name field
Form 2 collects a list of tasks and due dates for various projects. Form 2 uses a look-up field to provide a drop-down of the Project_Name field from form 1 - in form 2, this field is labeled Project - below is the code, which is still returning a numeric value for Project_Name in the email instead of the text name of the project. I also note when I use form builder it says that "Project" is a numerical field.
Any help would be appreciated. Thanks.
- Temp = Form_1 [ID == input.Project];
- sendmail
- (
- To : zoho.adminuserid, "yourname@domain.com"
- From : zoho.adminuserid
- Subject : "A task for " + Temp + " has been updated"
- Message : Temp + " has an updated task."
- )