-------------------------- MY EMAIL TO ZOHO -------------------------- I have 2 applications: SARONTI PHOTO FORMS and SARONTI OMS SARONTI PHOTO FORMS is used for customers to go and upload photos. SARONTI OMS is used for us as an order management system. I would like to know if it is possible (and how) to link the [Form "UK Family Book" from the SARONTI PHOTO FORMS application] so that when it is submitted successfully by a customer, it changes the ["Order Status" drop down of the form "New Family Orders" in the "SARONTI OMS" Application]. Both forms have identical fields such as "order number" and "customer email address" which would make it easy to link them to each other. -------------------------- ZOHO'S REPLY -------------------------- Greetings from Zoho Creator support. Yes, it is possible to link the Form "UK Family Book" from the SARONTI PHOTO FORMS application to the "Order Status" drop down field of the form "New Family Orders" in the "SARONTI OMS" Application with a unique value ("order number" or "customer email address"). Below are the sample steps. * Go to ""SARONTI OMS" Application". * Create a new function (update) with the parameter ("order number" or "customer email address"). * Write the code to fetch and update records by comparing the parameter and the value inside the "UK Family Book" form. The sample script is, rec = New_Family_Orders [order_number == input.order_number]; rec.Order_Status == "the required status"; * Click on Save script. * Go to "SARONTI PHOTO FORMS application". * Go to the On Add -> On Validate part of the Form "UK Family Book". * Call the function (update) from the ""SARONTI OMS" Application". * Pass the "order number" number to it. (As in the function script example I have mentioned order number, i requested you to pass the order number here. You can also use the customer email address in both the places) * Click on Save script. * You can follow the same steps for On Edit -> On Validate part of the Form "UK Family Book". Below are the help links you can refer. * http://help.creator.zoho.com/Defining-a-Function.html * http://help.creator.zoho.com/Invoking-a-Function.html * http://help.creator.zoho.com/Fetch-and-Update-Records.html * http://help.creator.zoho.com/On-Validate.html -------------------------- MY REPLY: -------------------------- This is fab thank you! One last question - as well as changing status of the order to "photoform received" in "SARONTI OMS", is it possible for a field to be created with a direct weblink to the photo form in "SARONTI PHOTO FORM" ? So when viewing SARONTI OMS form, all we need to do is click on a link to open up the relevant photoform in SARONTI PHOTO FORM? -------------------------- ZOHO'S REPLY: -------------------------- Yes, you can access the individual record. Every record can be accessed using a specific link. You can generate the required link and access it from the SARONTI OMS form. Alternatively, you can create an HTML view and populate the required records based on the record ID (of the record in SARONTI PHOTO FORM) which is unique for every single record. -------------------------- SO I JUST NEED SOMEONE TO DO THIS FOR ME PLEASE AS I DON'T KNOW HOW TO CREATE FUNCTIONS. PLEASE SEND QUOTE FIRST.