Search - Joel Lipman .Com

1. Zoho Deluge: Convert Hex to RGB: / Zoho /; ... value v_HexValue = v_HexGiven.replaceAll("#", "").toUpperCase(); // // using a regular expression: split into pairs of characters or if short hex given, then split into 3 characters l_HexParts = v_HexValue.replaceAll("(?)",",",false).toList().subList(1,4); if(v_HexGiven.toString().len()>4) { l_HexParts ...; Created on 11 October 2024
2. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... + ".csv"; f_UploadCsvFile = l_Csv_File.toString(v_NewLineChar).toFile(v_UploadFilename); // // upload the file r_UploadResponse = zoho.workdrive.uploadFile(f_UploadCsvFile,v_WorkdriveFolderID,v_UploadFilename,FALSE,"my_workdrive_connection"); if(!isNull(r_UploadResponse.get("data"))) { / ...; Created on 11 September 2024
3. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... e complete the following Credit Application Form or forward to the person within your company responsible for completing this."); m_Actions.put("recipient_phonenumber",""); m_Actions.put("recipient_countrycode",""); m_Actions.put("verify_recipient",false); m_Actions.put("recipient_name",v_RecipientFullName); m_Actions.put("recipient_email",v_RecipientEmail); l_Actions.add(m_Actions); ...; Created on 06 August 2024
4. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... k = false; } // // my app is the only one using the inventory_levels/update webhook topic/trigger if(m_ThisWebhook.get("topic").equalsIgnoreCase("inventory_levels/update")) { b_RestoreInventoryLevelWebho ...; Created on 22 April 2024
5. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... catch (e) { // return error (don't display it, just show it in the logs) console.log(e); //ZDK.Client.showMessage("Client Script error"); } // unfreeze the GUI ZDK.UI.freeze(false); ...; Created on 13 December 2023
6. Zoho Deluge: Proper Case for Names: / Zoho /; ... + " "; // // affix exceptions l_Exceptions = ; for each v_Exception in l_Exceptions { v_LastName = v_LastName.replaceAllIgnoreCase(v_Exception, v_Exception, false); } v_LastName = v_LastName.trim(); // // ...; Created on 13 July 2023
7. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; ... 15, "is_default": false, "payment_terms_label": "Net 15" }, { "payment_terms_id": "123456000000000124", "payment_terms": 30, "is_default": false, ...; Created on 06 July 2023
8. Zoho Deluge: Determine if Daylight Savings are in effect: / Zoho /; ... "GMT"), true, false); info b_IsDSTInEffect; // v_TimeZoneOffset = if(b_IsDSTInEffect, "+01:00", "+00:00"); // // usage v_SendToCRM_DateTime = zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ss","Europe/London" ...; Created on 03 July 2023
9. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
10. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... "days": "Saturday", "business_timing": [ "09:00", "15:00" ] } ], "daily_timing": null, "week_starts_on": "Monday", "same_as_everyday": false, ...; Created on 28 March 2023
11. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... Alternative get request: r_ShipmentDetails = getUrl(v_Endpoint, m_Header, false); Not done yet! Of course, it would help if when something was delivered, that was conveyed back to the system ...; Created on 21 March 2023
12. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... = Map(); m_Params.put("amount",v_StripeAmount); m_Params.put("currency","gbp"); //m_Params.put("automatic_payment_methods[enabled]", false); m_Params.put("payment_method_types[]","card_present"); m_Params.put("capture_method","manual"); v_DescriptionString ...; Created on 16 March 2023
13. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... / exclude other lists m_Exclude = Map(); m_Exclude.put("Include", false); m_Params.put("DeletedFromSoldList",m_Exclude); m_Params.put("DeletedFromUnsoldList",m_Exclude); m_Params.put("ScheduledList",m_Exclude); m_Params.put("SellingSummary",m_Exclude); m_Params.put("SoldList",m_Exclude); m_Params.put("UnsoldList",m_Exclude); // ...; Created on 01 March 2023
14. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... // update the record (note the API name being used here) r_Create = zoho.recruit.addRecord("CustomModule6",m_Create,0,false,"my_connection"); //info r_Create; } } } } Fo ...; Created on 08 February 2023
15. ZohoCRM: Import Attachments: / Zoho /; ... "" v_Message := "" v_YourDate := A_Year "-" A_MM "-" A_DD b_KeepOpen := false v_RunFolder := A_ScriptDir "\Run_" v_YourDate "_" A_Hour "-" A_Min ; -------------------------------------------------------------------------------------- ; ...; Created on 16 January 2023
16. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... = 390; v_DealRate2 = 465; v_DealRate3 = 535; v_DealRate4 = 590; b_ShowAlertMessage = false; } else if (v_RateCard == 'Old Rate Card (Pre Aug 22)' && (v_OppType ...; Created on 09 December 2022
17. Zoho Recruit: Rollup Number of Recruit Candidates to CRM Account: / Zoho /; ... School do you go to?_ID"); b_SchoolPaid = if(r_CandidateDetails.get("Paid School") == "true",true,false); // v_CandidatePlacedCount = 0; v_CandidateGraduatingCount = 0; v_CandidateGraduatingNextCoun ...; Created on 19 October 2022
18. ZohoCRM: ZDK Client Script to retrieve Contact Email: / Zoho /; ... } } catch (e) { // return error (don't display it, just show it in the logs) log(e); //ZDK.Client.showMessage("Client Script error"); } // unfreeze the GUI ZDK.UI.freeze(false); // ...; Created on 20 July 2022
19. Zoho Creator: Embed Forms/Reports on a Page: / Zoho /; What? Well known by most but this serves as a quick reminder to myself and anyone else on how to embed a form or a report into a Zoho Creator page. Why? Cos How? The below is a template ...; Created on 05 May 2022
20. Zoho CRM: Schedule a Meeting using Deluge: / Zoho /; ... day meeting m_ScheduleMeeting.put("All_day",false); // // meeting owner/host ID (can see any record related to this meeting) m_ScheduleMeeting.put("Owner",123456789012345678); // // related to what ...; Created on 02 March 2022