Search - Joel Lipman .Com

1. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... of Zoho Inventory. In this task, we are simply getting a CSV with all the order IDs for a particular year output as a spreadsheet. How? Similar to how we retrieved the eBay active listings (see ...; Created on 29 March 2023
2. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... ed to include those credit notes for refunds, etc. This tweak is if we want to calculate credit notes issued in a particular month rather than the one-to-one with an invoice as profits in the past wou ...; Created on 03 November 2022
3. Zoho Recruit: Rollup Number of Recruit Candidates to CRM Account: / Zoho /; What? This is a quick article to note down some code used in Zoho Recruit. This particular bit of code will run on a workflow when a Candidate is modified, and it tallies all the candidates belonging ...; Created on 19 October 2022
4. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... the days of the week which they can then click on to select a particular day. Some navigation is required in the form of a left arrow and right arrow to see previous or next weeks respectively. What ...; Created on 09 March 2022
5. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; What? This article demonstrates how to return a list of unique values in a particular field in a CRM module. Why? My use-case is a data-migration where the records exist in a staging module in ...; Created on 08 October 2021
6. 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
7. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... created for Zoho Creator to work in Zoho CRM is pretty easy to do. The only differences are the step where you select the type of project in the CLI, in particular the widget JS script that is referred ...; Created on 24 October 2020
8. AutoHotkey: Get Media Information and Display: / AutoHotkey /; ... work on MS Windows 7 (32-bit) for this particular app. For this reason, we are going to use a function by Skan called Filexpro() which is copied in the below: Filexpro( sFile := "", Kind := "", P* ...; Created on 07 August 2020
9. Zoho Deluge - Compare time and currenttime with timezone: / Zoho /; ... be run as. The time difference was just one hour but this caused problems if comparing two datetime values. In this particular case, we needed to check on the expiry of an access token used in OAuth2.0 ...; Created on 13 January 2020
10. CSS Add Text to Breadcrumb Link with a Transition: / Cascading Stylesheets /; ... Specify a prefix with a word which is fully opaque */ ul.breadcrumb a:hover span:before { opacity:1; content: 'More '; } /* Same as above but different prefix for this particular link */ ul.breadcrumb ...; Created on 18 May 2019
11. GDPR Privacy Policy: / Static Items /; ... LAW, MYCOMPANY DISCLAIMS ALL WARRANTIES, EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. MYCOMPANY DOES NOT WARRANT THAT THIS ...; Created on 14 February 2019
12. Zoho Inventory Template Issue: First Page is Blank: / Zoho /; What? So I thought I'd write an article to help me resolve the particular issue where the organization details and the header of the product line items table would display on the first page, the product ...; Created on 15 November 2018
13. Creating a custom form field type for Joomla XML fieldset: / Joomla /; ... for Joomla article selection. How? We have to create a custom form field type. In the following example, I'm going to create a dropdown which selects all projects associated with a particular user. ...; Created on 25 October 2013
14. JDatabase: using the Joomla database with examples: / Joomla /; ... ->where($db->quoteName('user_id') . '=42') ->order('date_modified ASC'); Single Value Result This type of query is for when you want just one value from one column and one particular ...; Created on 27 January 2013
15. Search a database for a value and count matching rows: / Databases /; What? We have a datawarehouse and we want to be able to count all the records in any table of the database that match on a particular warehouse load. This is a column value where the column is called ...; Created on 05 November 2012
16. T-SQL example of Case-Sensitive Soundex: / Transact-SQL /; What? This article is for demonstrating how to use a SOUNDEX in a select and then listing all the variations based on case-sensitivity. Why? We have a database with data in it. For a particular ...; Created on 10 October 2012
17. Search a database for a string (MySQL, T-SQL): / Databases /; ... SQL scripts that can simply be used to search an entire database for a particular string of word(s). I've posted my own as well as some others I've lifted from elsewhere, as they worked with my environment, ...; Created on 08 October 2012
18. Joes DNS Correction (JDC): / Product Documentation /; ... implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along ...; Created on 25 November 2011
19. How to Display Report Execution Time in SSRS (milliseconds): / SQL Server Reporting Services /; How to Display Report Execution Time in SQL Server Reporting Services 2008 R2 So there are other articles out there but I was looking to display in milliseconds the execution time it took for a particular ...; Created on 17 November 2011
20. SSRS Querying on either of 2 Parameters: / SQL Server Reporting Services /; ... is blank (this field can be null in the database); so that's a lot of rows, possibly all unrelated and won't work in my particular case. The solution to this issue of these solutions would be to add another ...; Created on 19 July 2011