Search - Joel Lipman .Com

1. Clicking on a weblink returns a 404 error: / Joomla /; If you are in the administration panel and you are editing your weblinks and you come across this error: "404 - An error has occurred. Joomla! was unable to locate the stated resource." ...; Created on 06 November 2009
2. $_SERVER['http_referer'] returns blank in Internet Explore: / Microsoft /; Thought I'd put a note about this as I spent ages rewriting an entire system. The HTTP_REFERER environment variable can be changed by the user anyway but I was using it as an additional validation check. ...; Created on 19 October 2009
3. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... key it returns you. eg. https://creatorapp.zohopublic.eu + zoho.appuri + report-perma/Download_File_Report/abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKL ...; Created on 02 February 2021
4. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... Created: 2020-10-27 (Joel Lipman) - Initial release - Workflow to calculate 80% dept workforce - Returns response as popup - Cancels submit with ...; Created on 10 December 2020
5. AutoHotkey: Get Media Information and Display: / AutoHotkey /; ... ) MsgBox % a_MediaObject["System.Media.Duration"] // note this returns in 100ns units (= 100 nanoseconds) as per Microsoft Docs. 100ns Units So the following snippet of code will convert your ...; Created on 07 August 2020
6. Zoho Deluge: Duplicate/Clone a Record: / Zoho /; ... for "Invoices": /* Function: fn_Button_CloneInvoice Purpose: This function duplicates a CRM invoice Parameters: p_InvoiceID (CRM ID of the invoice) Returns: Nothing Author: Joel Lipman Date Created: ...; Created on 17 March 2020
7. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; ... exists because it is searching with case-sensitivity enabled. It tries to insert into the product table, but returns the error "Result: Error on Execution" > "Error details: Execution Failed Due to invalid ...; Created on 21 November 2019
8. Zoho Deluge - Get distance between two coordinates: / Zoho /; ... from the JavaScript library figuring if it supports cos() then try this standard function. Note this has only been tested in Zoho Creator rather than Zoho CRM. How? This function returns the distance ...; Created on 11 June 2019
9. Zoho Deluge - Get User Timezone, Country and Location: / Zoho /; ... v_Url ); Returns something like: { "ipAddress": "147.188.254.175", "continentCode": "EU", "continentName": "Europe", "countryCode": "GB", "countryName": "United Kingdom", ...; Created on 03 June 2019
10. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; ... = v_MyString.replaceAll("\r","",false); // carriage returns v_FormattedString = v_MyString.replaceAll("\n","",false); // line feeds v_FormattedString = v_MyString.replaceAll("\f","",false); // form ...; Created on 31 May 2019
11. Convert Past Date to Time Ago in PHP: / Personal Home Page /; ... largest unit) $v_ReturnStr = $a_UnitPairs[0].' ago'; // return return $v_ReturnStr; } Usage $v_Str = getTimeAgo('2019-05-16 19:30:00'); // If (at time of print) this date ...; Created on 16 May 2019
12. 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
13. URL Alias uniqueness with PHP & MySQL: / Personal Home Page /; ... "$2", trim($v_Output, "_")); // returns a string return $v_Output; } and the MySQL is a trigger which executes before the record is inserted and increments the value of url_alias: DROP ...; Created on 06 May 2019
14. GDPR Privacy Policy: / Static Items /; ... POLICIES, MODIFICATION, AND SEVERABILITY Please review our other policies, such as our Shipping and Returns policy, posted on this site. These policies also govern your visit to MYCOMPANY. We reserve the ...; Created on 14 February 2019
15. Excel - Check a column for values found in another column: / Excel /; ... is a function returning a boolean. Returns false if a cell value has been formatted to a text type. Returns true if the cell value is a number AND the cell data type is numeric. Search( is a case-insensitive ...; Created on 14 February 2019
16. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... function that is skipping the SSL checks and returns a PHP array function send_request($url, $header, $data, $method="GET") { $ch = curl_init(); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); ...; Created on 02 February 2019
17. 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
18. Zoho Deluge: Loop through List: / Zoho /; ... returning an hour value (eg. "08:00") and thisServiceRecord.Closing_Time returns an hour value (eg. "20:00"). This will output a picklist which populates as: 08:00, 08:30, 09:00, 09:30 ... 19:30, 20:00. ...; Created on 30 November 2018
19. Zoho Deluge - MD5 function: / Zoho /; ... writing a Creator function but found a shortcut playing with the base64encode function: v_Etag = zoho.encryption.base64encode(v_Combined_Fields); // returns error Error on Execution Execution ...; Created on 19 November 2018
20. Zoho Deluge - Get Full Day Name: / Zoho /; What? This is a very quick note with the code to retrieve the full day name from a date (eg. "Monday"). Why? If I use the toString() function to get the day, it only returns the first 3 letters ...; Created on 08 November 2018