Search - Joel Lipman .Com

21. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... The example below is that we are going to search for some records in Zoho Creator and display these in either Zoho Books or Zoho CRM. For demonstration purposes, these have been simplified and will ...; Created on 30 July 2021
22. Zoho CRM & Zoho Creator: Query returns some fields missing other data on the record: / Zoho /; What? A super quick article to demonstrate how an idiot like myself can misread the documentation. This particular article shows you how to customize the search results or response from using zoho.creator.getRecordById(). ...; Created on 26 July 2021
23. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... that are to be entered in their specific order. Search for "Alt Codes" or "Symbol Codes" in a search engine for a full list. Meanwhile, here's some that you may need frequently: Currency ¢ Cent ...; Created on 03 June 2021
24. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Deluge: / Zoho /; ... relevant to this module: l_LinkedRecords = zoho.crm.searchRecords("Opportunities_X_Products","(Opportunity:equals:" + v_DealID + ")"); Find records relevant to this user: v_SearchCriteria ...; Created on 28 April 2021
25. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... belongs to Search for employees of the same department (team members) who have booked the same days off (ie count holiday clashes) Prevent an employee for applying for leave if over 80% of the department ...; Created on 10 December 2020
26. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... 2020 ; - Checks for duplicates done by searching its own column. ; - Also checks for duplicates if file exists. ; - Leaves original file as is. ; ; -------------------------------------------------------------------------------------- ; ...; Created on 08 July 2020
27. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... != "") { r_SearchResults = zoho.crm.searchRecords(v_CrmSoModule,"(Name:equals:" + v_CrmSoRef + ")"); for each r_Result in r_SearchResults { v_CrmSoID = r_Result.get("id").toLong(); } } // // ...; Created on 15 May 2020
28. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date String: / Zoho /; What? So this is a super quick note that I'll probably remember anyway but just in case, I'm writing this article so I don't spend time researching it later. Why? I'm synchronizing Xero Invoices with ...; Created on 04 May 2020
29. Joomla CMS: Register to Read More: / Joomla /; ... not only do we want to restrict read more content (full text) and just show intro texts to public but the default Joomla instructions do not include the search engine. I need the Joomla built-in search ...; Created on 11 April 2020
30. Joomla: Remove IDs from URLs for out-of-the-box SEF: / Joomla /; Applies to Joomla! CMS v3.5.x What? This is a short article on how to remove the ID numbers from your Joomla website addresses for search engine friendly URLs. // What I have www.joellipman.com/index.php?option=com_content&category_id=4&article_id=123-article-alias // ...; Created on 14 March 2020
31. Zoho Deluge: Associate/Link an Invoice to a Sales Order: / Zoho /; ... I needed a way to programmatically link the sales order to the invoice. Why? The documentation around the API does not detail how to do this. I also couldn't find any search result via Google or ...; Created on 10 March 2020
32. 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
33. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; ... = v_MyString.replaceAll("^.*href\s*=\s*\"([^\"]*)\".*$","$1"); // yields https://www.google.com?searchword=Joe Get first 3 words: v_MyString = "I am Joe the Awesomest"; v_FormattedString = v_MyString.replaceAll("^((?:\S+\s+)\S+).*","$1",false); // ...; Created on 31 May 2019
34. URL Alias uniqueness with PHP & MySQL: / Personal Home Page /; What? So this is an article for me on how to copy Joomla's and Wordpress' feature where a Title/Name value is converted to a search-engine friendly URL alias and is unique in the database. Ok that's a ...; Created on 06 May 2019
35. GDPR Privacy Policy: / Static Items /; ... address which you have provided. From time to time, we may also use your information to contact you for market research purposes. We may contact you by email, phone, fax or mail. We may use the information ...; Created on 14 February 2019
36. Excel - Check a column for values found in another column: / Excel /; What? This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook). How? So for demonstration ...; Created on 14 February 2019
37. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; What? This is an article explaining the code needed to write a PHP script which generates an access token for a service account which in turn is used to list files in a team's Google Drive. This is ...; Created on 02 February 2019
38. 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
39. Zoho Deluge - MD5 function: / Zoho /; What? So this is NOT an article on how to create a MD5 function for an ETag in Zoho Deluge as I expected it would be. At time of print, the Zoho documentation (and Google search results) make no mention ...; Created on 19 November 2018
40. Pure JS - Display Time Elapsed & Remaining: / JavaScript /; ... the same, but this is an example that I was coding and found to be one of the most reduced cut down formats I've made. I thought I'd make a note of it to not have to search elsewhere... This example ...; Created on 30 October 2018