Search - Joel Lipman .Com

1. Zoho Inventory: Enable Tracking using the API: / Zoho /; What? One of these articles because I spent so long trying different snippets of code to enable tracking when using Deluge code to create an item in Zoho Inventory: Why? Who uses ZohoInventory ...; Created on 04 May 2023
2. Zoho Creator: Disable/Hide the add and delete subform row buttons: / Zoho /; ... a list of services. The client does not want their operations team adding/deleting rows and instead simply specifying quantity (defaulting to zero) alongside each serviceable item. How? So at time ...; Created on 28 February 2023
3. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... where our client wants to query Zoho Recruit via the API but couldn't find a database table to determine who has been associated to what job. In Zoho Recruit reports (Analytics), you can include the "Associate" ...; Created on 08 February 2023
4. Zoho Desk: Re-enable Desktop Notifications after clicking on "Not Now: / Zoho /; What? This is a quick article to re-enable desktop notifications after having been prompted initially and having clicked on "Not Now". Why? I'm not sure when this prompt is supposed to prompt you ...; Created on 20 July 2022
5. ZohoCRM: Template: not being able to edit a text box: / Zoho /; What? This is a bit of an odd article with not 100% certainty on what the cause/outcome would be for your case but worked for us. This documents the steps taken to edit/modify the header on a sales ...; Created on 25 January 2022
6. Zoho Creator/Deluge: UnPredictable exception, Invalid statement found: / Zoho /; ... fix for the error: Execution Failed UnPredictable exception, Invalid statement found Line:(20) I cannot guarantee that this error doesn't appear for other reasons but I will add to this article ...; Created on 17 November 2021
7. Zoho Deluge: Zoho Bookings Get Available Slots: / Zoho /; What? This is an article of code snippets to query a Zoho Bookings instance from within Creator. This one focuses on getting the available slots. Why? This is for a Creator app which had a form ...; Created on 23 June 2021
8. Zoho Deluge: Convert Map to HTML Table without a FOR loop: / Zoho /; What? A very quick article on converting a Map string into a HTML table without using a for each loop. Why? I have quite a big response from our CRM that hits a statement execution limit if I ...; Created on 11 January 2021
9. SELECT COUNT(DISTINCT name) FROM table: / Joomla /; ... statement. Why? The MySQL statement SELECT COUNT(DISTINCT name) FROM table is valid but I get what you mean and it's sometimes difficult to explain why you want to use it. How? Method #1: Add ...; Created on 24 September 2015
10. MySQL Updating a database table from another table: / MySQL /; What? A quick article on how to populate a database column from another table using a string comparison. Why? I have several database tables which replicate country names and I would rather they ...; Created on 22 October 2014
11. T-SQL functions to convert Strings to Tables: / Transact-SQL /; ... start with a function that just converts a string of words delimited by spaces to a table: CREATE FUNCTION dbo.[ufn_StringToTable] ( @StringInput VARCHAR(MAX) ) RETURNS @OutputTable TABL ...; Created on 20 August 2014
12. SITS: XET format for Export not available: / Extensible Markup Language /; What? Trying to export a STU record but I want to use the XET template I created rather than the pre-installed XML export formats. When I try to export using data format XET, the system has never heard ...; Created on 08 August 2014
13. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connec: / MySQL /; ... "Data Export" using MySQL Workbench. This is not regarding the connection issue as I can connect to my database using MySQL Workbench (I have enabled the old authentication protocol). The error ONLY appears ...; Created on 28 July 2014
14. Disable User Registration in Joomla 1.5 - Configuration File: / Joomla /; What? A quick reminder on how to disable user registration in Joomla! CMS version 1.5.x without using the Joomla! CMS back-end panel. Why? Because we're having some corruption issues and simply ...; Created on 08 October 2013
15. Modifying columns in a table: / Databases /; What? This is an article to remind me how to modify a column in a database table the old fashioned way (as in stop making me use GUI interfaces so poorly programmed when even I've made better DBMS tools). ...; Created on 24 July 2013
16. Reorder Columns in a Table: / Databases /; ... Method: phpMyAdmin So in the phpMyAdmin interface, apparently, you can drag the columns by clicking and holding on the headers when viewing a table structure... Though maybe this is derived from ...; Created on 22 July 2013
17. MS Excel - Sort pivottable column headings by date: / Excel /; What? This is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first ...; Created on 12 April 2013
18. Parse a HTML Table into a ListView: / Hypertext Markup Language /; What? A quick article on if you were given a webpage coded in HTML, what methods in AutoHotkey could you use to separate out the HTML Tables into a ListView. Why? I want a snippet of code that ...; Created on 30 March 2013
19. Delete related records from multiple tables: / MySQL /; What? So this is a quick article on how to delete from multiple tables in a mySQL database where we use some JOIN statements. Why? It is never recommended to delete from multiple tables and instead ...; Created on 11 January 2013
20. Adding a selectable background to a Yootheme template: / Joomla /; Applies to: Joomla 2.5.8 Yootheme Template 2012 What? For any web-developer who can program in PHP/HTML, this would be easy to hard-code and override. However, the article below demonstrates ...; Created on 19 November 2012