Search - Joel Lipman .Com

21. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... the Zoho Deluge team... Well, they realised they would get the same results, and then suggested looping through all records and creating a distinct list variable... But what if there are 20000+ records? ...; Created on 08 October 2021
22. Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestamps: / Zoho /; ... Deluge. How? We're going to make use of the .toLong() function applied to a datetime datatype variable which will return the Unix seconds. // the now time v_NowTime = zoho.currenttime; // // ...; Created on 21 September 2021
23. ZohoCRM: zoho.crm.searchRecords only returns certain records: / Zoho /; What? This is an article to hopefully resolve for you quicker than it took me, why a zoho.crm.searchRecords() returns some of the records but omits others. Why? The use-case was that we were creating ...; Created on 29 July 2021
24. Zoho Creator: Receive JSON via a Shopify Webhook: / Zoho /; ... replace the my_owner and my_app with your Zoho Creator owner and app name respectively) Update 2022: I've included the code to verify the webhook came from Shopify: // // declare response variable back ...; Created on 15 July 2021
25. Zoho Creator: Add a subform while creating a record: / Zoho /; ... form is called "Quotes" and my subform is called "Line_Items": // initialize variables // ... this is a demo so ... do your own ... // // get source data r_QuoteDetails = zoho.crm.getRecordById("Quotes", ...; Created on 14 July 2021
26. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API: / Zoho /; ... on line 86 Rather than assuming Zoho Deluge maps and lists are JSON variables, let's send a strange hack instead: m_NestedRequest = Map(); m_NestedRequest.put("auth[key]",v_AuthKey); m_NestedRequest.put("auth[secret]",v_AuthSecret); m_NestedRequest.put("data[member_id]","123456"); m_NestedRequest.put("data[channel_name]","shopify"); m_NestedRequest.put("data[item_name]","Joel ...; Created on 03 February 2021
27. Zoho Deluge: Sort a Map by a specific field: / Zoho /; What? This is a quick article to template some code to me on sorting a map variable in Zoho Deluge, specifically Zoho Creator. Why? I do this a lot but in the following example, I want to sort ...; Created on 29 January 2021
28. Expecting ZC_SUBFORM_250 expression found COLLECTION: / Zoho /; ... for inserting a row into a subform: // declare a variable to hold the collection of rows = Collection(); // declaring the row = .(); // assigning values for various subform fields in the ...; Created on 19 October 2020
29. AutoHotkey: Get Media Information and Display: / AutoHotkey /; ... ) { ; v.90 By SKAN on D1CC @ goo.gl/jyXFo9 Local Static xDetails If ( sFile = "" ) { ; Deinit static variable ...; Created on 07 August 2020
30. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... to work on the CRM record: // assuming I have a creator form called "myForm" // that the ID of the record is the value of the variable "myRecordID" // that a subform exists in the form called "Attachments" // ...; Created on 15 May 2020
31. Zoho Deluge - Compare time and currenttime with timezone: / Zoho /; What? This is a quick article to demonstrate how to compare two datetime values with the timezone specified. Why? A client's ZohoCRM had a different timezone setting than the user a script would ...; Created on 13 January 2020
32. Zoho Deluge - Get Refresh/Access Token API v2: / Zoho /; ... // NOTE: convert this to a JSON Array r_RecordUpdate = invokeUrl [ url :v_EndPoint type :PUT headers: m_Header parameters:m_Data.toString() ]; // NOTE: convert parameters variable to a string ...; Created on 17 July 2019
33. CSS Printing - Page Break Inside with Headers and Footers: / Cascading Stylesheets /; ... and the next page has a table which is of variable length. Fine when the table was short and didn't have many rows. But the client will pick up the phone to you when the table has too many rows to fit ...; Created on 22 February 2019
34. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... logic and highlight any changes you may need to make. 1. First: the variables are in arrays Well mostly. Simply because we'll be working with JSON data and this encodes/decodes easily into PHP ...; Created on 02 February 2019
35. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
36. Google Authentication - OAuth 2.0 using PHP/cURL: / Google /; ... being this script. Complete the global variables at the beginning of the code specific to your app and the rest should work... // specific to this app $CLIENT_ID = ''; // expecting *.apps.googleusercontent.com $CLIENT_SECRET ...; Created on 31 October 2018
37. Pure JS - Display Time Elapsed & Remaining: / JavaScript /; ... and how long ago was the last token created. How? So almost pure JS. I'm working out the seconds remaining and seconds elapsed in PHP first then passing these as two variables to the below code ...; Created on 30 October 2018
38. Import Excel CSV file as JavaScript array: / Excel /; ... 'text/csv'); // send request to the server xhr.send(); // return contents of target file to JS variable var my_csv_file_contents = xhr.responseText; // ...; Created on 05 October 2015
39. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... as a local variable. -- Specify v2.5.x admin ID and v3.4.x admin ID SET @v25_admin_id=42; -- Set this to the ID number of the user in your Joomla 2.5.x SET @v25_admin_alias='Webmaster'; -- Set ...; Created on 12 September 2015
40. Joes Quicklist Weblinks (JQW) Downloads: / Downloads /; ... text translation.- Date Uploaded: Wed, 2nd Nov 2011 1.5.3.4 - Fixed Bug: More variables now defined- Date Uploaded: Fri, 30th Sep 2011 1.5.3.3 - Fixed Bug: Undefined variables now defined- Date Uploaded: ...; Created on 07 September 2015