Search - Joel Lipman .Com

1. Zoho Deluge - Compare time and currenttime with timezone: / Zoho /; ... for an API. How? All with deluge but we will split the date and time value obtained from a CRM field and compare it to the current time combined with a timezone. In this particular case, we will ...; Created on 13 January 2020
2. Zoho Deluge - Get Current User ID: / Zoho /; What? This is a quick article on different ways to get the current user ID in Zoho through code. How? I'm not a fan of method #1 but I only started developing in Zoho recently when API v1 was already ...; Created on 08 April 2019
3. Basic Android App using Google Maps and Current Location: / AndroidOS /; ... on creating an app which opens Google Maps at your current location. How? I couldn't find any instructions using the tools I had (Android Studio) which is why I've written this article. Start "Android ...; Created on 10 October 2014
4. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... = zoho.currentdate.toString("yyyy"); if(!m_SubfolderNames.keys().contains(v_WorkingFolderName)) { m_Attr = Map(); m_Attr.put("name", v_WorkingFolderName); m_Attr.put("parent_id", v_ParentFolderID); // m_Params ...; Created on 11 September 2024
5. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... = m_DocInfo.get("document_id"); // // Create Map for CRM Record - ZohoSign Documents m_ZCrm_ZSDoc = Map(); m_ZCrm_ZSDoc.put("Name",v_TemplateName); m_ZCrm_ZSDoc.put("zohosign__Contact",p_ContactID); m_ZCrm_ZSDoc.put("Email",v_RecipientEmail); if(!isNull(r_Contact.get("Account_Name"))) { m_ZCrm_ZSDoc.put("zohosign__Account",r_Contact.get("Account_Name").get("id")); } m_ZCrm_ZSDoc.put("zohosign__Owner",r_Contact.get("Owner").get("id")); m_ZCrm_ZSDoc.put("zohosign__Date_Sent",today); m_ZCrm_ZSDoc.put("zohosign__ZohoSign_Document_ID",v_DocumentId); m_ZCrm_ZSDoc.put("zohosign__Module_Name","Contacts"); m_ZCrm_ZSDoc.put("zohosign__Module_Record_ID",p_ContactID.toString()); m_ZCrm_ZSDoc.put("zohosign__Document_Deadline",zoho.currentdate.addDay(15)); m_ZCrm_ZSDoc.put("zohosign__Document_Status","Ou ...; Created on 06 August 2024
6. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... e order")) { v_PO_Ref = "PO-" + m_Comment.get("description").getSuffix("PO-").trim().getPrefix(" "); m_Details = Map(); m_Details.put("po_ref",); m_Details.put("po_date",zoho.currentdate.toString("dd-MMM-yyyy")); m_Details.put("last_modified",zoho.currentdate.toString("dd-MMM-yy ...; Created on 09 July 2024
7. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... zcpage-pagenumber, currentPageNumber, and totalPageNumber which will output the current page number and total count of pages respectively: Page of Copyright © My ...; Created on 07 May 2024
8. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... + zoho.currenttime.toString("yyyy-MM-dd HH:mm","Europe/London")); m_WebhookLog.put("Body",m_Payload.get("body")); m_WebhookLog.put("Event_Type","Inventory Update"); m_WebhookLog.put("Source","Shopify"); m_WebhookLog.put("Data_Format","JSON"); r_WebhookL ...; Created on 22 April 2024
9. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... = "applicable_products.txt"; f_CSVFile = l_CsvLines.toString(zoho.encryption.urlDecode("%0A")).toFile(v_CSVFilename); f_CSVFile.setParamName("file"); Get current file name (optional) To check ...; Created on 25 March 2024
10. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... }); */ /* ************************************ */ /* Some non-Zoho JavaScript */ /* Set Copyright Year */ var today = new Date(); var currentYear = today.getFullYear(); $('footer ...; Created on 14 March 2024
11. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... else use the current value var v_ProductWeightFormatted = fn_CountDecimals(v_ProductWeight) > 2 ? parseFloat(v_ProductWeight).toFixed(2) : v_ProductWeight; // set the field value to the formatted ...; Created on 13 December 2023
12. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... = List(); for each m_User in r_Users.get("users") { v_CurrentSignature = ifnull(m_User.get("signature"),""); // // criteria, only update signatures which aren't done? //if(v_CurrentSignature.length( ...; Created on 05 December 2023
13. Zoho Deluge: Proper Case for Names: / Zoho /; ... to work using Zoho Deluge. How? There are a number of combinations that I won't have thought of but the below code sufficed for my current task, common English and some European names: // // ...; Created on 13 July 2023
14. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... // returns 2020 You should also pad single digit week numbers if we're going to store a year week value: v_ThisCurrentWeekNumber = if(zoho.currentdate.toString("u").toLong() == 7,zoho.currentdate.subDay(1),zoho.currentdate).toString("w"); v_ThisCurrentWeekNumberPadde ...; Created on 06 July 2023
15. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; ... clients set their due dates differently. How? The following snippet of code will query the metadata api in Zoho Books and return a JSON of what the payment terms are. void fn_ReturnCurrentPaymentTerms() { v_BooksOrgID ...; Created on 06 July 2023
16. Zoho Deluge: Determine if Daylight Savings are in effect: / Zoho /; ... checking if daylight savings is in effect in the UK, we should be able to take Greenwich Mean Time and compare to UTC. b_IsDSTInEffect = if(zoho.currenttime.toString("HH:mm", "UTC") != zoho.currenttime.toString("HH:mm", ...; Created on 03 July 2023
17. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... enter your own organization ID here for ZohoBooks and ZohoInventory v_BooksOrgID = 12345678901; // // evaluate v_currentDate = zoho.currentdate.toString("yyyy-MM-dd"); v_OrderDate = zoho.currentdate.toString("yyyy-MM-dd"); v_Page ...; Created on 27 April 2023
18. Zoho Deluge: Get All Orders from eBay: / Zoho /; What? Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay. Why? Our use-case is a data migration from eBay to a fresh instance ...; Created on 29 March 2023
19. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... = zoho.currenttime.toString("yyyy-MM-dd ") + m_ShiftBuildUp.get(v_WorkDay).get("open").leftpad(5).replaceAll(" ", "0") + ":00"; v_FinishTime = zoho.currenttime.toString("yyyy-MM-dd ") + m_ShiftBuildUp.get(v_WorkDay).get("close").leftpad(5).replaceAll(" ...; Created on 28 March 2023
20. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... output to developer for debug purposes v_Date = zoho.currentdate.subDay(v_Index).toString("yyyy-MM-dd"); info v_Date; // // set criteria of what shipment orders to retrieve m_Criteria = Map(); m_Criteria.put("date",v_Date); // // ...; Created on 21 March 2023