Search - Joel Lipman .Com

1. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; What? A very quick article on how to check what the statement execution limit is on the Zoho application you are working in. Why? Our use-case is that an application we built in Zoho Creator was ...; Created on 31 July 2024
2. Zoho Deluge: Determine if Daylight Savings are in effect: / Zoho /; What? If you're lucky enough to build an application for a client based in a country that changes its clocks twice a year, then I'm opening this article without a 100% certain solution as I need to wait ...; Created on 03 July 2023
3. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... missing associated purchase orders altogether. I had to break this down into several queries to generate the dataset, then use these as pseudo-subqueries. The first task was to determine the cost ...; Created on 03 November 2022
4. Zoho Deluge - Determine Quarter from Date with Fiscal Year: / Zoho /; What? This is a quick article on what should be a simple mathematics equation: Determine the quarter from a given month. Why? Fine if you are determining the quarter by the month and your Fiscal ...; Created on 31 January 2020
5. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... */ // // crmAPIRequest v_DebugMessage = ""; v_RequestID = 0; m_Body = ifnull(crmAPIRequest.get("body"),Map()); v_DebugMessage = "Body: " + m_Body + " "; // // determine type of document done if(!isNull(m_Body.get("requests"))) { v_RequestName ...; Created on 06 August 2024
6. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; What? A quick article on how to get the pricebook entry using Zoho Deluge for a specific product in your ZohoBooks or ZohoInventory instance. Why? This took me the best part of an hour to determine ...; Created on 23 May 2024
7. Zoho Books: Error 7008: There are no contact persons associated with this Invoice: / Zoho /; ... != null) { m_ZB_InvoiceDetails = r_ZB_InvoiceDetails.get("invoice"); // // determine recipients l_ZB_InvoiceRecipients = List(); r_ZohoBooks_CustomerDetails = zoho.books.getRecordsByID("contacts",v_BooksOrgID,m_ZB_InvoiceDetails.get("customer_id"),"zbooks"); if(r_ZohoBooks_CustomerDetails.get("contact") ...; Created on 07 March 2024
8. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... each r_Tax in r_Taxes.get("taxes") { m_Taxes.put(r_Tax.get("tax_percentage").toString(),r_Tax.get("tax_id")); } // // ---------------------- DETERMINE ZOHOBOOKS CUSTOMER ID ---------------------- if(!isnull(r_QuoteDetails.get("Account_Name"))) { v_AccountID ...; Created on 18 September 2023
9. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... system to determine whether to update or create. - Check if SalesOrder already exists on system to determine whether to update or create. - Check if Invoice already exists on system to determine ...; Created on 27 April 2023
10. 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
11. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... / determine name of logged in user (and make owner?) v_LoggedInUserID = 0; l_Users= List(); m_UserType = Map(); m_UserType.put("email",zoho.loginuserid); r_Response = zoho.crm.invokeConnector("crm.getusers",m_UserType); if(!isnull(r_Response.get("status_code"))) { if(r_Response.get("status_code")==200) { l_Use ...; Created on 06 March 2023
12. ZohoCRM: Get All eBay Active Listings: / Zoho /; What? Another one of these articles talking about getting all the active product listings from eBay for a specific client. Why? Our use-case scenario here is that we want to get an inventory ...; Created on 01 March 2023
13. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... GraphQL The key value to retrieve is "cursor"; we're also going to use "hasNextPage" to determine if we need to keep looping: { productVariants(first: 10, query: "updated_at:>'2023-02-20T00:00:00+0000'") ...; Created on 20 February 2023
14. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... where our client wants to query Zoho Recruit via the API but couldn't find a database table to determine who has been associated to what job. In Zoho Recruit reports (Analytics), you can include the "Associate" ...; Created on 08 February 2023
15. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... 10); json_Arg.End_Date = v_EndDateFormatted; } // add currency code into column "Agreed Currency" json_Arg.Agreed_Currency = v_CurrencyCode; // the rate values we determine ...; Created on 09 December 2022
16. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... ID v_BooksOrgID = 20221234567; // // determine URL of file to download (note the DC here is EU but yours might be COM) v_Url = "https://inventory.zoho.eu/api/v1/items/" + input.Zoho_Inventory_ID ...; Created on 31 March 2022
17. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... if I click on Tuesday10March, this code will match "10" to the map and determine what index or offset this is from the starting date, which is "2". It can then determine which CSS element to highlight ...; Created on 09 March 2022
18. 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 ...; Created on 21 January 2022
19. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng): / Zoho /; ... be searched for with the "State" field on the Lead record. // // ************************************************ // determine customer timezone: BEGIN // v_CustomerTimeZone = ""; // // build ...; Created on 15 December 2021
20. Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestamps: / Zoho /; ... determine days v_Days = floor(v_UnixSeconds / 1000 / 60 / 60 / 24); info v_Days; v_UnixSeconds = v_UnixSeconds - (v_Days * 1000 * 60 * 60 * 24); // // determine hours v_Hours = floor(v_UnixSeconds ...; Created on 21 September 2021