Search - Joel Lipman .Com

41. Zoho Deluge: Associate/Link an Invoice to a Sales Order: / Zoho /; ... updating multiple fields at the same time. How? Through sweat and perseverance. The trick is to update both the sales order id and to update the invoice line items with their respective sales ...; Created on 10 March 2020
42. Autohotkey - Chrome Profiles in Alphabetical Order: / AutoHotkey /; ... the multiple profiles in alphabetical order like it used to be... but to date they have not. So I made a program that lists the profiles in alphabetical order and can be double-clicked to open the Chrome ...; Created on 07 January 2020
43. CSS Ordered List 1, 1.1...1.10 Formatting and Alignment: / Cascading Stylesheets /; What? A quick article to remind me on how create an multi-level ordered list that indents and aligns correctly. Why? I'm finding that I need to do this quite often for some clients who want to ...; Created on 10 July 2019
44. Zoho Deluge - Get distance between two coordinates: / Zoho /; ... = v_CalcDist * 60 * 1.1515; } return round(v_Miles,2) + " miles"; } For kilometres, simply multiply the miles value by 1.609344 if (unit=="K") // kilometers if (unit=="N") // nautical ...; Created on 11 June 2019
45. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; ... yields list of [1,2,3,4,5] Replace any multiple spaces with a single space: v_MyString = "Hello World!"; v_FormattedString = v_MyString.replaceAll("[ ]+"," ",false); // yields Hello World! ...; Created on 31 May 2019
46. Excel - Check a column for values found in another column: / Excel /; ... is a function to multiply two ranges together (must be the same size) and return the total of these results. -- is a double hyphen/dash which converts a boolean true to 1 and boolean false to 0. IsNumber( ...; Created on 14 February 2019
47. MS Excel - Split Workbook into separate files per sheet: / Excel /; What? This article serves to explain how to split a spreadsheet consisting of multiple sheets into separate files per sheet. Why? The Excel file in question was about 36000 rows and had a file ...; Created on 11 February 2019
48. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... arrays. I can also output any of the variables and responses for debugging purposes. I can also unset multiple branches of variables with fewer commands than unsetting specific variables. Let's specify ...; Created on 02 February 2019
49. 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
50. Zoho Deluge - MD5 function: / Zoho /; ... be done via the documented methods (base64, urlencode or AES) as this exceeds 255 characters (it could be a multiline but this would defeat the objective of an Etag). How? Well I was going to documen ...; Created on 19 November 2018
51. Header (Transparent): Created on 01 January 2018
52. Header (Flex): Created on 30 December 2017
53. Header (Centered): Created on 17 April 2017
54. Header (Adspace): Created on 17 April 2017
55. Modals: Created on 17 April 2017
56. Header (Background Video): Created on 10 January 2016
57. Feature Box: Created on 08 October 2015
58. Person: Created on 08 October 2015
59. Tabs: Created on 17 April 2015
60. Slick Slider: Created on 17 April 2015