I've created a custom function which is linked to a custom button which pulls a date from our contacts module and searches a date field in our quotes module and returns all records matching the date.
My issue is, how to I get this to display the results to the front end user either in a pop up or message window?
{
//Get the customer ID from the contacts module
customerID = zoho.crm.getRecordById("Contacts",ContactID.toLong());
//
//Get Proposed Event Date
EventDate = customerID.get("Proposed_Event_Date");
//
// Show in console the correct Start Date ready for search
info EventDate;
//
//Search Bookings Module for all bookings that are confirmed for the Event Date pulled form customer record
response = zoho.crm.searchRecords("Quotes","(Event_Date:equals:" + EventDate + ")and(Quote_Stage:equals:Confirmed)or(Quote_Stage:equals:Outsourced - Confirmed)");
info response;
for each record in response
{
info record.get("Event_Type") + " - " + record.get("Alternative_Subject") + " (" + record.get("Venue_Name") + ") Booking Status: " + record.get("Quote_Stage") + " | Booking Value: £" + record.get("Total");
}
return "";
}