Search - Joel Lipman .Com

1. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; What? A quick article on determining the week number of the year if your week starts on a Monday and not a Sunday. Why? I think it's the US system which generally says that a week starts on a Sunday ...; Created on 06 July 2023
2. Zoho Deluge: Calculate start and end of Daylight Savings Time: / Zoho /; What? An article to document how I calculated the start and end dates of when Daylight Savings Time is in effect. Why? Admittedly, most of Zoho apps have this built-in but here's some snippets ...; Created on 07 December 2021
3. CharIndex Reverse - find occurrence starting from end of string in TSQL: / Transact-SQL /; ... right, as we got the last occurrence counting from the beginning rather than the end, so we still need to work out the starting point: SELECT LEN(@Haystack) - CHARINDEX(@Delimiter, REVERSE(@Haystack)) -- ...; Created on 28 January 2013
4. Set default parameter dates to start and end of month: / SQL Server Reporting Services /; Situation The requirement in a lot of my reports in SSRS has always been a date range rather than just the one date. The user must be allowed to select all results between two dates instead of just ...; Created on 05 April 2011
5. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... rID = "0"; if(!isNull(r_RecordDetails.get("Attending_Engineer"))) { m_Data.put("Attending_Engineer",r_RecordDetails.get("Attending_Engineer").get("name")); } if(!isNull(r_RecordDetails.get("Service_Start_Time"))) { m_Data.put("Service_Start_Time",r_RecordDetails.get("Service_Start_Time").replaceAll( ...; Created on 06 August 2024
6. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... when records were last modified and if a synchronization process starts to fail, there should be images or icons warning or advising of failures. How? The key trick to use here the ability for Zoho ...; Created on 25 July 2024
7. Zoho Projects: Get All Events: / Zoho /; ... are events in the past; status is a mandatory field // NB: range is an integer and the number of records to return (default=100; max=200) // NB: index is an integer and is the offset or starting index ...; Created on 22 July 2024
8. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... "Scheduler" header information such as the name, description, start date/time, frequency, and timezone. While you're here, click on "Connections" at the top of the IDE (where you paste the code) and ensure ...; Created on 02 July 2024
9. 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
10. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... w Up Non Converted Lead"); m_NewTask.put("Due_Date",v_EndTime.toDate()); m_NewTask.put("Status","Not Started"); // // configure reminder on task to run daily at the same time as creation time m_Remind ...; Created on 14 May 2024
11. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... of "Schedule - Shopify Webhooks" It has the code standalone.fn_Shopify_RestoreWebhook(); Starts ASAP; with a frequency of Hourly (run every 2 hours); and never ends. Save and done. Error(s ...; Created on 22 April 2024
12. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... more than 100 categories so let's start counting r_Categories = invokeurl [ url: v_EndpointCategories + "?" + l_ConnectionParams.toString("&") + "&" + l_PaginationParams.toString("&") type: GET ]; v_TotalProducts ...; Created on 15 April 2024
13. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... the JavaScript These are the contents of main.js and is working at time of print: // Start with Zoho SDK stuff ZOHO.CREATOR.init() .then(function(data) { // Initialize ...; Created on 14 March 2024
14. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... to a field that is simply of datatype: date (eg. Valid_Till) The supported operators are equals, starts_with, in, not_equal, greater_equal, greater_than, less_equal, less_than and between. The supported ...; Created on 14 November 2023
15. Zoho Deluge: Proper Case for Names: / Zoho /; ... other entry does not... This article is a start and adaptation of my previous article Convert to Proper Case in T-SQL which I had previously used for the migration of a HR system. This is intended ...; Created on 13 July 2023
16. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... = Map(); l_JsonOrders = List(); // // start preparing CSV file to email for export v_ReportCSV = "Date,Order ID,Status,Amount,Currency,Notes"; l_CsvFileRows = List(); l_CsvFileRows.add(v_ReportCSV); // // ...; Created on 29 March 2023
17. 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
18. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... s = r_Response.get("response").get("users"); for each v_User in l_Users { v_LoggedInUserID = v_User.get("id"); } } } // // start building conversation trail l_ConversationMessages = List(); // ...; Created on 06 March 2023
19. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... page to start from v_StartingPageIndex = 1; // // specify the maximum number of products you think you have on eBay // the actual number will be less than this but this is for pagination estimates v_MaximumProducts ...; Created on 01 March 2023
20. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... API.fn_ShopifyQuery_UpdateAllProducts() { // init v_CountTotal = 0; v_CountUpdated = 0; v_PerPage = 10; b_HasNextPage = true; v_Cursor = ""; l_CsvFileRows = List(); // // start preparing ...; Created on 20 February 2023