Search - Joel Lipman .Com

1. Ordered List of over 1000 Items: / Cascading Stylesheets /; What? So many people asking this when the solution is a bit of aesthetic styling. ol -- yields 995. 996. 997. 998. 999. 000. 1000 Ordered list resets to zero after the ninth item ...; Created on 08 February 2013
2. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... v_Iteration; } // yields an incremental count from 0 to 4999 Statement Execution Limit is 10000 If the below runs successfully, then the limit is at least 10'000: // v_Counter = 0; l_Loop ...; Created on 31 July 2024
3. 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
4. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... 1000 ]) // the actual number may be less than this but this is for pagination estimates v_MaximumOrders = 10000; v_Year = 2022; // // set the filter for orders by status to return: All, Active, Cancelled, ...; Created on 29 March 2023
5. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... = zoho.currenttime.toLong() / 1000; // // by default gets last 100 messages (doesn't return anything if no parameters specified) v_Endpoint = "https://cliq.zoho.eu/api/v2/chats/"+v_ChatID + "/messages?fromtime=" ...; Created on 13 February 2023
6. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... work) v_ClientID = "1000.ABCDEFGHIJKLMNOPQRSTUVWXYZ1234"; v_ClientSecret = "aaaabbbbccccddddeeeeffff111122223333444455"; v_RefreshToken = "1000.aaaabbbbccccddddeeeeffff11112222.33334444555566667777888899990000"; // // ...; Created on 17 October 2022
7. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... of mine (see my pinterest) to build a nicer looking computer and I was given £1000 towards a new computer... It's more than enough to get a running White Snow Edition PC but I put in some more to get the ...; Created on 12 March 2022
8. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... : 5, "actualQueryCost": 5, "throttleStatus": { "maximumAvailable": 1000, "currentlyAvailable": 995, "restoreRate": 50 } } } } Additional Note th ...; Created on 14 February 2022
9. Zoho CRM: searchRecords with sorted results: / Zoho /; ... SEARCHRECORDS **************** // // init v_RecordID = 1234567890123456789; // // loop through 5 pages of 200 records = 1000 records l_Pages = [1,2,3,4,5]; // // set search criteria v_SearchCriteria ...; Created on 10 February 2022
10. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; What? A quick article to demonstrate code that creates a task in CRM based on the time logged against an Event/Meeting. Why? As developers, we're keep account of our time and we are currently ...; Created on 02 December 2021
11. 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
12. ZohoCRM: Process all records of a module: / Zoho /; ... to 200) and 1000 records is the sweet spot in which case the loading bar disappears but the function usually completes all 1000 every 5-10 minutes: // init v_CountFound = 0; v_CountUpdated = 0; l_Pages ...; Created on 24 August 2021
13. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... Not symbol 0172 ± Plus/minus 0177 µ Micro 0181 ‰ Per Mille (1/1000th) 0137 Website © Copyright symbol 0169 ® Registered symbol 0174 ™ Trademark 0153 • List Dot 0149 § Section Symbol ...; Created on 03 June 2021
14. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... Billable"); v_WorkNotes = ifnull(input.Work_Notes,""); v_TaskOrIssue = if(input.Type == "Task", "tasks", "bugs"); // // eval v_HoursDecimal = (v_EndTime.toLong() - v_StartTime.toLong()) / 1000 / 60 ...; Created on 30 April 2021
15. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; What? So I thought I'd write a quick article to remind me and to develop a simple notification system that will popup for any user on the submit of a form, or on the click of a button or on the click ...; Created on 06 November 2020
16. AutoHotkey: Get Media Information and Display: / AutoHotkey /; ... v_100NsUnits ) { v_NanoSeconds100 := v_100NsUnits * 1 v_MicroSeconds := Floor( v_NanoSeconds100 / 10) v_MilliSeconds := Floor( v_MicroSeconds / 1000) v_Seconds ...; Created on 07 August 2020
17. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... Create GUI Gui, New, %Options%, %Title% v%Version% Gui, Color, %BgColor% Gui, Font, s8, Verdana Gui, Add, Button, Default w110 h30 x10 y10 gGenerateList vButton1, 1. Generate List ; 0x1000 adds ...; Created on 08 July 2020
18. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... r_Response; // yields: } info r_Response.get("item"); // yields: "item_id": "2124100000000081031", .... info r_Response.get("item").get("item_id"); // yields: Value is empty and 'get' function cannot ...; Created on 06 February 2020
19. Zoho Deluge - Get Refresh/Access Token API v2: / Zoho /; ... snippet: v_ClientID = "1000.ABCDEFGHIJKLMNOPQRSTUVWXYZ1234"; v_ClientSecret = "aaaabbbbccccddddeeeeffff111122223333444455"; v_RedirectUri = "https://www.zoho.com/books"; // can be any endpoint that ...; Created on 17 July 2019
20. Zoho Deluge - Get User Timezone, Country and Location: / Zoho /; ... code is dependent on these being online and working... The quickest I found [limit 1000 per day | Incorrect Location]: v_Url = "http://api.db-ip.com/v2/free/"+ zoho.ipaddress; v_Response = getUrl( ...; Created on 03 June 2019