Search - Joel Lipman .Com

1. Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd): / Zoho /; What? A quick article to remind me of the regex to change a date from the format dd/MM/yyyy to yyyy-MM-dd. Why? Irrespective of server, organization or user settings, the date handling can vary. ...; Created on 01 September 2021
2. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an order ...; Created on 21 January 2022
3. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; ... data per column (in this example, I highlight the Date column, it then prompted me what format this is in, eg. dd/MM/yyyy): You will then be shown a summary of your import: You can then ...; Created on 12 January 2022
4. Zoho Deluge: Calculate start and end of Daylight Savings Time: / Zoho /; ... Start Starts Second Sunday in March at 2:00 DST End Ends First Sunday in November at 2:00 // // Starts Second Sunday in March at 2:00 v_FirstMonthDate = toTime(zoho.currentdate.toString("yyyy") ...; Created on 07 December 2021
5. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; ... MMMM dd, yyyy @ h:mma") + " " + v_CustomerTimeZoneName + " "); v_ResultInformation = v_ResultInformation.concat("Agent's Appointment Date/Time: "); v_ResultInformation = v_ResultInformation.concat(" ...; Created on 07 December 2021
6. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; ... sunday but we want to start counting from Monday 00:00 v_FirstDateOfWeek = zoho.currentdate.toStartOfWeek().addDay(1).toString("yyyy-MM-dd"); // // build up COQL Query v_CoqlQuery = ...; Created on 02 December 2021
7. Zoho CRM: Schedule a Call using Deluge: / Zoho /; ... start in CRM format v_SystemAppointmentDateTimeStart = v_SystemCallTime.toString("yyyy-MM-dd'T'HH:mm:00") + v_ApplicationTimeOffset; // // set system/application date time start in US format v_CustomerAppointmentDateTimeStart ...; Created on 18 November 2021
8. Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time field: / Zoho /; ... timezone, add 10 minutes, re-assemble it in a format that CRM likes, and update the field: // // parse date into yyyy-MM-dd (using subString - reliable) v_LeadCreatedDate = r_LeadDetails.get("Created_Time").subString(0,4) ...; Created on 11 November 2021
9. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... , zoho.currentdate.toString("MMMM, dd yyyy")); m_Data.put("Organization.Name", r_ContactRecord.get("Account_Name").get("name")); // m_MergedData = Map(); m_MergedData.put("merge_data", ); // // to genera ...; Created on 21 October 2021
10. Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestamps: / Zoho /; ... correction: I want to specify a from datetime v_NowTime = '2021-09-21 21:27:15'; // // now specify a to datetime (we're doing a working day so we add 1 business day) v_NextTime = zoho.currentdate.addBusinessDay(1).toString("yyyy-MM-dd ...; Created on 21 September 2021
11. Zoho Deluge: Push a value to a datetime field in CRM: / Zoho /; ... some formatting examples: Creator to CRM: v_CreatorTime = zoho.currenttime.toTime(); v_CrmTime = v_CreatorTime.toString("yyyy-MM-dd'T'HH:mm:ss") + v_CreatorTime.toString("Z").subString(0,3) + ":" ...; Created on 10 September 2021
12. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... = ifnull(r_Result.get("Quote_Currency"),"GBP"); v_QuoteTotal = ifnull(r_Result.get("Total_Amount"),0.0).toDecimal(); v_ExchangeRate = ifnull(r_Result.get("Exchange_Rate"),1); v_ModifiedTime = ifnull(r_Result.get("Modified_Time"),r_Result.get("Added_Time")).toTime().toString("dd/MM/yyyy ...; Created on 30 July 2021
13. Zoho Deluge: Zoho Bookings Get Available Slots: / Zoho /; ... r_Staff in l_Staff { if(!isnull(r_Staff.get("id"))) { v_StaffName = r_Staff.get("name"); } } Get the Available slots: // // get available slots r_AvailableSlots = zoho.bookings.getAvailableSlots(v_ServiceID,v_StaffID,v_ThisDate.toString("dd-MM-yyyy"),"joels_connector"); l_AvailableSlot ...; Created on 23 June 2021
14. Zoho Deluge: Generate and Send a CSV via Email: / Zoho /; ... commas v_NewCSVline = "\"" + v_ThisEventTime.toString("yyyy-MM-dd HH:mm:ss") + "\",\"" + v_ThisEventNote + "\""; l_NewCSVrows.add(v_NewCSVline); } // // generate CSV v_CSVFilename = "audit-log-" ...; Created on 16 June 2021
15. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... ", "0"); v_HoursHHmm = v_TimeHour + ":" + v_TimeMinutes; // // build map m_CreateTimeLog = Map(); m_CreateTimeLog.put("date",v_StartTime.toDate().toString("MM-dd-yyyy")); m_CreateTimeLog.put("bill_status",v_Billable); m_CreateTimeLog.put("hours",v_HoursHHmm); m_CreateTimeLog.put("start_time",v_StartTime.toString("hh:m ...; Created on 30 April 2021
16. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... v_ThisFileSize = ifnull(m_ThisFile.get("file_Size"),"-"); v_ExpiryTime = zoho.currenttime.addMinutes(10).toString("dd-MMM-yyyy HH:mm:ss"); // // put your own Publish key here (publish th ...; Created on 02 February 2021
17. Zoho Deluge: Sort a Map by a specific field: / Zoho /; ... date format), arrange so it can be sorted alphabetically in reverse order v_DatePart = v_SortingKey.getPrefix("T").toDate().toString("yyyy-MM-dd"); v_TimePart = v_SortingKey.getSuffix("T").getPrefix("+").subString(0,5); v_SqlDateTime ...; Created on 29 January 2021
18. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... can book longer than a month): // set criteria to search for clashing annual leave dates (pre/post 1 month check) l_SearchCriterias = List(); m_SearchCriteria = Map(); m_SearchCriteria.put("searchField","From"); m_SearchCriteria.put("searchOperator","After"); m_SearchCriteria.put("searchText",v_GivenDateFrom.subMonth(1).toString("dd-MMM-yyyy")); l_SearchCriterias.add(m_SearchCriteria); m_SearchCriteria ...; Created on 10 December 2020
19. Zoho Deluge: Duplicate/Clone a Record: / Zoho /; ... now override fields specific to the newly cloned/duplicated record m_Clone.put("Invoice_Status","Repeated Invoice"); m_Clone.put("Invoice_Date",zoho.currentdate.toString("yyyy-MM-dd")); m_Clone.put("Due_Date",zoho.currentdate.addMonth(1).toStartOfMonth().subDay(1).toString("yyyy-MM-dd")); // ...; Created on 17 March 2020
20. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... time field in Deluge So annoying but sometimes you want to insert a date/time value into a date/time field and you get the error: v_MyDateTimeString = zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ssZ"); // ...; Created on 06 February 2020