Search - Joel Lipman .Com

21. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... The trick in this solution was more about the process and what that process was. Reading the brief, and having written many custom functions for other Zoho apps, it would stand to reason that ...; Created on 10 December 2020
22. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... Workflow > Functions > New Function: give the function a name select "Deluge" as the language give it a Namespace (for this example I will leave this on "Default") and set the return type (again in ...; Created on 06 December 2020
23. Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Div: / Zoho /; ... the Zoho Creator page. Functions are read by Zoho and certain CSS attributes (such as position and float) will be removed automatically. The code has to be pasted directly in the Page and then the CSS ...; Created on 22 October 2020
24. Zoho Deluge - Pad with leading Zeros: / Zoho /; ... ", "0"); } This looks like pretty old code and not wanting to cause offence, it isn't the JavaScript style or chain I like which appends the functions instead and is clearer for me personally to ...; Created on 07 February 2020
25. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; ... is a function I find myself using more and more called equalsIgnoreCase() which could be used: ... l_ProductDetails = Product[Product_Name.equalsIgnoreCase(v_Name)]; ... Other Functions of ...; Created on 21 November 2019
26. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; What? This is a quick article on how to generate a 5 letter code from several functions: one which returns 5 randomly selected characters and another two which convert a number to 5 letters. Why? ...; Created on 09 May 2019
27. Zoho Deluge - Get Current User ID: / Zoho /; ... being deprecated (end of life at the end of this year). So I'm familiar with the methods in API v2 or just using newer functions. Method #1: API v1 userResp = getUrl(("https://crm.zoho.com/crm/private/xml/Users/getUsers?authtoken=xxxxxxxxxxx&scope=crmapi&type=ActiveUsers")); users ...; Created on 08 April 2019
28. 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
29. Zoho Deluge - Get English Ordinal: / Zoho /; ... built-in functions of Zoho deluge. Method #1: Using a list/array, I'm going to check the date against the 3 exceptions to this rule (11th, 12th and 13th of each month): // get the date (eg. 1, ...; Created on 08 November 2018
30. Google Authentication - OAuth 2.0 using PHP/cURL: / Google /; What? This is an article which lists the functions necessary to process Google Authentication using OAuth2.0. These functions allow a script to simply be loaded and to either create a token file, or ...; Created on 31 October 2018
31. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library): / Google /; ... for PHP. So no classes or built-in functions that you didn't write or know what they're doing. Why? The objective here is to upload a video file to my Google Drive. This assumes you have already ...; Created on 29 October 2018
32. Foreign Characters create symbols in PHP and MySQL: / Personal Home Page /; ... Conclusion: The final fix in my case was due to me not specifying some extra parameters on the htmlentities or htmlspecialchars PHP functions. My database stored the foreign characters as the ...; Created on 25 January 2016
33. Joes Quicklist Weblinks (JQW) Downloads: / Downloads /; ... Jul 2014 Download 3.1 AdrianaV/Vincent - Enhancement: Does not display more images then are available. - Enhancement: Auto-Check for cURL functions enabled on server. - ...; Created on 07 September 2015
34. Joes Word Cloud (JWC) Download: / Downloads /; ... Date Uploaded: Mon, 27th Jun 2011 1.5.2 - Modified core script for PHP4 compatibility: - - Replaced mb_strtolower with LOWER... - Modified core script for performance. - - Reduced 3 functions into ...; Created on 07 September 2015
35. AHK Countdown Tooltip: / AutoHotkey /; ... RETURN ; ********************************************************************************************************************************************************************** ; MAIN FUNCTIONS ; ...; Created on 17 July 2014
36. Regular Expressions in SQL: / Databases /; ... '[^a-zA-Z0-9\'']') -- returns all rows where the student surname contains non-alphanumeric characters and does not contain apostrophes -- eg. O'Brien will NOT be returned -- Other REGEXP Functions ...; Created on 09 January 2014
37. Autohotkey Count Number of Files/Folders in a Directory: / AutoHotkey /; ... usage (see functions below) TotalFileCount := CountFilesRecursive( "C:\" ) MsgBox, TotalFiles %TotalFileCount% -- functions to put at bottom of script CountFilesRecursive(Folder){ static ...; Created on 04 June 2013
38. Cheat Sheet for mySQL vs t-SQL: / Databases /; Some memory aids for me so that I don't have to keep looking them up: /* .joe_subtable td .joe_subtable i .joe_subtable .jst_label .joe_subtable .jst_pre .joe_subtable .jst_fn */ MySQL ...; Created on 31 January 2013
39. Data Randomization Function in Oracle PL/SQL: / Oracle PL/SQL /; ... equivalent functions have to be written up all in the name of "seamless integration"... How? Previously I had tried to write a smart function which could determine the datatype automatically but ...; Created on 22 August 2012
40. No rows returned in Oracle causes SP to fail: / Oracle PL/SQL /; ... are returned, and not a row of NULL/blank/empty values. Sounds confusing? That's just me, the answer was using two NVL functions which allowed the stored procedure to return no rows without erroring (ie. ...; Created on 24 January 2012