Search - Joel Lipman .Com

21. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; What? An article on how 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 ...; Created on 28 February 2023
22. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... query which will now retrieve 10 products per page and loop through 3 pages for use in Zoho Deluge. If this works, we can increase the number of pages as well as the number of products per page: The ...; Created on 20 February 2023
23. ZohoCRM: Import Attachments: / Zoho /; ... := v_FilesTotal + 1 RowNumber := A_Index ;get first selected row RowChecked := LV_GetNext(RowNumber - 1 , "Checked" ) If ( RowNumber = RowChecked ) { v_FilesCopied := v_FilesCopied ...; Created on 16 January 2023
24. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... in the subform: // initialize var v_CalculatedNumberOfSkills = 0; // get the Opp stage var v_OppStage = ZDK.Page.getField('Stage').getValue(); // get the Skills subform var l_SkillsSubform = ...; Created on 09 December 2022
25. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... charges and other discrepancies. I'm calling this dataset "My Purchase Order Items" SELECT DISTINCT po."Purchase Order Date" AS "PO Date", po."Purchase Order Number" AS "PO Ref", poi."Produc ...; Created on 03 November 2022
26. Zoho Deluge: Generate a loop or list of any size: / Zoho /; ... it to a list, then lets you generate an array or list of any size. Why? My use case here is to run a schedule that will populate a list with the upcoming dates for the next week (and for any numbers ...; Created on 21 October 2022
27. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... = invoice.get("invoice_number"); v_BalanceDue = ifnull(invoice.get("balance"),0.0); // // search payments m_SearchCriteria = Map(); m_SearchCriteria.put("customer_id",v_CustomerID); m_SearchCriteria.put("sort_order","A"); m_SearchCriteria.put("sort_by","payment_number"); // // ...; Created on 17 August 2022
28. Zoho Inventory: Mark a package slip as delivered and shipped: / Zoho /; ... HH:mm")); m_Params.put("tracking_number","N/A"); l_UrlParams = List(); l_UrlParams.add("salesorder_id=" + v_SalesOrderID); l_UrlParams.add("package_ids=" + v_PackageID); l_UrlParams.add("is_delivered=true"); l_UrlParams.add("organization_id= ...; Created on 14 July 2022
29. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... an Integer/Long/Number datatype As the first part of your code, enter the following as code (you'll need to speify your own App Owner and App Name): // // ************************************************** ...; Created on 31 March 2022
30. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... the value of each radio item will be populated using deluge and what's important to note here is that each picklist/dropdown option includes some HTML, specifically a SPAN tag surrounding the date number ...; Created on 09 March 2022
31. Zoho CRM: searchRecords with sorted results: / Zoho /; ... listed here, the standard searchRecords() and then the getRecords() functions: Set the record ID to your own record ID. Set the list of pages to the number of pages you want to search. Keep ...; Created on 10 February 2022
32. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; What? A very quick article on a cool snippet of code, another regular expression, I've been trying out to round up a number or at least to remove the trailing zeros. I could have added this to my Zoho ...; Created on 08 February 2022
33. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... include fixed price items m_Pagination = Map(); m_Pagination.put("PageNumber",v_Page); m_Pagination.put("EntriesPerPage",v_PerPage); m_Params.put("Pagination",m_Pagination); //m_ActiveList.put("Sort","ItemID"); m_Params.put("ItemID",p_ItemID); // // ...; Created on 22 January 2022
34. 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
35. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; ... Transfer Protocol on a Port number of your choosing: Set for new imports to append, replace, or check if exists then insert/replace: Schedule to repeat: Every X Hours, Every Day, Weekly, Monthly: ...; Created on 12 January 2022
36. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense): / Zoho /; What? A very quick article to remind me how to send a text message using Twilio API in Zoho Deluge. Why? The use-case here is that we want local sense dialing where specific numbers are used both ...; Created on 16 December 2021
37. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; ... display confirmation text v_ResultInformation = ""; v_ResultInformation = v_ResultInformation.concat("Customer: " + input.Name + " "); v_ResultInformation = v_ResultInformation.concat("Phone: " + input.Phone_Number ...; Created on 07 December 2021
38. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; ... it the following scopes: ZohoCRM.modules.ALL ZohoCRM.users.READ ZohoCRM.coql.READ // // set to the number of hours minus the ones to be logged on Friday (40 - 8) v_RemindeMeAtHoursLogged = ...; Created on 02 December 2021
39. Zoho Deluge: Today, Tomorrow, Day After but Skip Sunday: / Zoho /; ... dates given a number of days So here's another scenario where you have a start date and you are asked to list the working days, 7 days after the start date. I'm aware of the method .workdaysList(): date1='2022-07-21'; date2='2022-07-29'; info ...; Created on 02 November 2021
40. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... syntax, add these to a list, and then submit as the subform name, like in the following example (note I have applied a regex to use US/UK numbering format with 2 decimals and thousandth separator, eg. ...; Created on 21 October 2021