Zoho People: Reject an Application for Leave in Deluge based on Criteria https://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-reject-an-application-for-leave-in-deluge.html
10 December 2020
= v_ThisFrom || v_CompareDateFrom = v_ThisTill) { v_TotalClashes = v_TotalClashes + 1; v_ClashOrNot = "Clashes with "; } info v_ClashOrNot + r_TimeOff.get("Employee_ID") + ":" + v_ThisFrom + "-" + v_ThisTill; } } } Note: Play around with the Status,...
Type: Article
Author: Joel Lipman
Category: Zoho People
Language: *
Zoho Deluge: Convert Map to HTML Table without a FOR loop https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-convert-map-to-html-table-without-a-for-loop.html
11 January 2021
m_Data.put("Last_Name","Person"); m_Data.put("id","2"); l_Data.add(m_Data); v_Data = l_Data.toString(); info v_Data; // yields // {"First_Name":"Joel","Last_Name":"Lipman","id":"1"},{"First_Name":"Another","Last_Name":"Person","id":"2"} Some formatting...
Type: Article
Author: Joel Lipman
Category: Zoho Deluge
Language: *
Zoho Deluge: Sort a Map by a specific field https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-sort-a-map-by-a-specific-field.html
29 January 2021
= l_SortingKeys.sort(false); for each v_SortKey in l_SortedKeysDesc { m_ThisRecord = m_UnsortedRecords.get(v_SortKey); info m_ThisRecord; } Recap The original sample data l_MyListUnsorted looks something like this in a JSON parser: [ { "name": "Joel",...
Type: Article
Author: Joel Lipman
Category: Zoho Deluge
Language: *
Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html
03 February 2021
{ $v_PostedSecret = $_POST['auth']['secret']; } if($v_PostedKey == $v_Key && $v_PostedSecret == $v_Secret) { mail("info@joellipman.com","Post to AscentCloud","Successful Auth"); } } // yields: Successful Auth Caveat Unfortunately, I've titled this...
Type: Article
Author: Joel Lipman
Category: Zoho Deluge
Language: *
Zoho CRM: Update a custom field in line items / product details using REST API v2.1 https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-update-a-custom-field-in-line-items-product-details.html
17 May 2021
:"https://www.zohoapis.eu/crm/v2.1/Invoices/" + p_InvoiceID type :GET parameters: m_Params connection:"joels_connector" ]; info r_InvoiceDetails; Common Error(s): {"code":"MANDATORY_NOT_FOUND","details":{"api_name":"data"},"message":"required field not...
Type: Article
Author: Joel Lipman
Category: Zoho CRM
Language: *
ZohoCRM: Deluge: Map a custom field from user profile https://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-deluge-map-a-custom-field-from-user-profile.html
01 September 2021
= Map(); m_UpdateDeal.put("Division",v_DivisionID); r_UpdateDeal = zoho.crm.updateRecord("Deals",v_DealID,m_UpdateDeal); info r_UpdateDeal; } } break; } }
Type: Article
Author: Joel Lipman
Category: Zoho CRM
Language: *
Zoho CRM: Standard Setup for Tax Rates https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-standard-tax-rate-setup.html
02 September 2021
a CRM product record (you can do mass edit on a listview of products but for demo purposes, we'll do just one) Under Price Information, edit the field "Tax" (multi-select) and select both tax rates Now go to a transactional module that has line items...
Type: Article
Author: Joel Lipman
Category: Zoho CRM
Language: *
Zoho Creator: Public URL of an Image field / Upload to Shopify API https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html
17 October 2021
v_PositionIndex, v_ShopifyImageSrc); } v_PositionIndex = v_PositionIndex + 1; } info "Re-uploaded Photos to Shopify"; } } Correction / Additional The above solution means that for every photo uploaded, an API call is used up. If you have low limits,...
Type: Article
Author: Joel Lipman
Category: Zoho Creator
Language: *
Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time field https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-deluge-adding-10-minutes-to-a-crm-date-time-field.html
11 November 2021
m_UpdateLead.put("Check_Date_Time", v_LeadTimeDelay); r_UpdateLead = zoho.crm.updateRecord("Leads", p_LeadID, m_UpdateLead); info r_UpdateLead;
Type: Article
Author: Joel Lipman
Category: Zoho CRM
Language: *
Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense) https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-text-sms-using-twilio-api-localsense.html
16 December 2021
m_Data = Map(); m_Data.put("Body",v_Message); m_Data.put("From",v_OurTwilioNumber); m_Data.put("To",v_CustomerNumber); info m_Data; // // JSON request r_TwilioResponse = invokeurl [ url :v_Endpoint type :POST parameters:m_Data ]; } Error(s) Encountered...
Type: Article
Author: Joel Lipman
Category: Zoho Deluge
Language: *
Zoho CRM: searchRecords with sorted results https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-searchrecords-with-sorted-results.html
10 February 2022
an ID on this record to avoid looping through error messages if(!isNull(r_Result.get("id"))) { // do stuff to each record... info r_Result.get("id"); } } // // stop looping if less than 200 records on this page if(l_SearchResults.size()...
Type: Article
Author: Joel Lipman
Category: Zoho CRM
Language: *
Zoho Deluge: Generate a loop or list of any size https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-generate-a-list-of-any-size.html
21 October 2022
{ if(v_Index>0) { l_CheckDates.add(zoho.currentdate.addDay(v_Index).toString("yyyy-MM-dd")); } } // // output info l_CheckDates; // // outputs: 2022-10-22,2022-10-23,2022-10-24,2022-10-25,2022-10-26,2022-10-27,2022-10-28
Type: Article
Author: Joel Lipman
Category: Zoho Deluge
Language: *
ZohoDeluge: Get All eBay Orders Given a From and Till Date https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zohodeluge-get-all-ebay-orders-given-a-from-and-till-date.html
28 February 2023
I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this function too often either for debugging/monitoring purposes but it's easier to use...
Type: Article
Author: Joel Lipman
Category: Zoho Deluge
Language: *
ZohoDeluge: Inserting a new line character in a CSV https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zohodeluge-inserting-a-new-line-character-in-a-csv.html
01 March 2023
// // yields: // Me,Myself,I // a,b,c Additional Adding to a screen output: eg. a button response or response of info: try holding down the ALT key and pressing 255, then releasing the ALT key and save the change to your code. This will not display a...
Type: Article
Author: Joel Lipman
Category: Zoho Deluge
Language: *
Zoho Deluge: Determine if Daylight Savings are in effect https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-determine-if-daylight-savings-are-in-effect.html
03 July 2023
b_IsDSTInEffect = if(zoho.currenttime.toString("HH:mm", "UTC") != zoho.currenttime.toString("HH:mm", "GMT"), true, false); info b_IsDSTInEffect; // v_TimeZoneOffset = if(b_IsDSTInEffect, "+01:00", "+00:00"); // // usage v_SendToCRM_DateTime =...
Type: Article
Author: Joel Lipman
Category: Zoho Deluge
Language: *
Zoho Deluge: Proper Case for Names https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-proper-case-for-names.html
13 July 2023
false); } v_LastName = v_LastName.trim(); // // join all together v_FullName = trim(v_FirstName + " " + v_LastName); info v_FullName; // // yields: Billie-Jo McDonald-O'Leary II of Cambridge-Worcester-Oxford Caveat(s): This solution does not cater for...
Type: Article
Author: Joel Lipman
Category: Zoho Deluge
Language: *
Zoho Creator: Sendmail a list of attachments https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-send-mail-a-list-of-attachments.html
20 July 2023
type: GET ]; r_Download2.setParamName("file"); l_Downloads.add(r_Download2); // sendmail [ from: zoho.adminuserid to: "info@joellipman.com" subject: "Test File: List" message: "This is just a test" attachments: file: l_Downloads ] } Yields
Type: Article
Author: Joel Lipman
Category: Zoho Creator
Language: *
Zoho Deluge and Wordpress/WooCommerce API: Get All Products https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html
15 April 2024
on retrieving all the products from a WooCommerce instance on a client's Wordpress website. Why? A client of ours wants the information entered against products in their WooCommerce to display on their estimates in Zoho Books; such as product image,...
Type: Article
Author: Joel Lipman
Category: Zoho Deluge
Language: *
Zoho Creator: Render to PDF with margins and page numbers https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html
07 May 2024
0, 0, 0), rgba(0, 0, 0, 0.75), rgba(0, 0, 0, 0)); } My Company Ltd Test Street, Test County TEST1 ZIP1 +44 (0)1234 567890 info@mycompany.com www.mycompany.com QUOTE Quote For: Quote Date: Quote By: Item Description Quantity Unit Price Unit Discount 0)...
Type: Article
Author: Joel Lipman
Category: Zoho Creator
Language: *
ZohoDeluge: eBay marketplace account deletion/closure notifications https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html
13 March 2025
(Joel Lipman) - Initial release Date Modified: 2025-03-13 (Joel Lipman) - Validated Webhook - Send email to client More Info: https://developer.ebay.com/marketplace-account-deletion metadata.topic topic of the notification metadata.schemaVersion schema...
Type: Article
Author: Joel Lipman
Category: Zoho Deluge
Language: *