Search - Joel Lipman .Com

1. JavaScript: / Category /; Created on 05 March 2020
2. Zoho CRM: Manage a subform using Client Script: / Zoho /; What? This is an article with a snippet of code demonstrating how to manage a subform using a Zoho CRM Client Script. Why? A client wanted an automation on-the-fly that when selecting a specific ...; Created on 09 December 2022
3. ZohoCRM: ZDK Client Script to retrieve Contact Email: / Zoho /; What? An article on one of my first client scripts for ZohoCRM. This retrieves and populates an email field based on when a contact is selected in a lookup field. Why? I could do a normal automation/workflow ...; Created on 20 July 2022
4. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; What? This is an article documenting how to create a Zoho Creator Widget which includes the Bootstrap and jQuery frameworks as well as other JavaScript functionality. Why? Quite simply that at ...; Created on 24 October 2020
5. Import Excel CSV file as JavaScript array: / Excel /; ... convert to a JavaScript array of objects var my_object_array = [ , , ]; What I want again: Read a CSV file already uploaded with JavaScript Populate a JS array with each ...; Created on 05 October 2015
6. Sort an associative array by values in Javascript: / JavaScript /; What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. ...; Created on 29 September 2015
7. VBScript to retrieve Windows Product Key: / Windows OS /; What? A quick article with the code to retrieve your product key in Windows 7 with a small VB script file. There are other articles on the web about this but the ones I found returned errors such as ...; Created on 23 September 2015
8. SSIS: Add Reference Microsoft.SqlServer.TxScript: / SQL Server Integration Services /; What? This article is so that I don't spend so long in googling what the TxScript referenced assembly is when creating an SSIS custom component. How? This is simply the "Script Component" under ...; Created on 03 June 2014
9. Export Joomla Users script: / Joomla /; ... allows the passwords to be in MD5. All I want is a quick bit of code to get all the users out of a Joomla CMS. How? I could just type a query on the database and get the same result, but this script ...; Created on 28 February 2014
10. SSRS Subscriptions cannot be created: / SQL Server Reporting Services /; Applies to: Microsoft Business Intelligence Development Studio 2008 (BIDS) Microsoft SQL Server 2008 R2 What? This article describes solutions to the error: Subscriptions cannot be created ...; Created on 22 November 2013
11. Problem creating SSRS report subscriptions: / SQL Server Reporting Services /; What? A quick article on if you are trying to create a new subscription to a SQL Server Reporting Server (SSRS) report and you are getting a warning message similar to the following: Message from ...; Created on 11 November 2013
12. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... (do they ever?). The script must be able to be copied into other SSIS packages. Need the option to merely tick input column names rather than hardcode these. "It " should be an acronym for IT, so "I ...; Created on 04 October 2013
13. Inline Labels in Form Fields using Javascript: / JavaScript /; ... still in use. I needed a back-to-basics solution and this is the one I have used since my fad of JavaScript 1.2 in the 90s. For broader compatibility, this is my recommended solution. How? We're ...; Created on 21 August 2012
14. Connect to Joomla database in standalone script: / Joomla /; APPLIES TO Joomla 2.5.x Why? I'm building a Joomla component which is to be compatible with Joomla versions 1.6.x to 2.5.x. Because I use dynamic scripts running in the background (mootools), some ...; Created on 17 August 2012
15. Basic Webpage Controls with JavaScript / COM: / AutoHotkey /; ... with JavaScript / COM This tutorial requires one of the following:AutoHotkey_L - has built-in COM Support (recommended)the COM Standard Library - for use with AHK BasicPurpose The purpose ...; Created on 05 July 2011
16. This file contains HTML or script code that may be erroneously interpreted by a web browser: / Hypertext Markup Language /; The Error: This file contains HTML or script code that may be erroneously interpreted by a web browser This is a common error when uploading files that the MediaWiki system does not allow. By making ...; Created on 08 October 2009
17. ZohoBooks: Code 15 Ensure Billing Address has less than 100 characters: / Zoho /; ... each r_Result2 in r_SearchResults2.get("items") { if(r_Result2.get("item_name") == v_CrmProductName) { m_BooksLineItem.put("item_id",r_Result2.get("item_id").toLong()); m_BooksLineItem.put("name",v_CrmProductName); m_BooksLineItem.put("description",r_CrmLineItem.get("Description")); m_BooksLineItem.put("quantity",r_CrmLineItem.get("Quantity")); m_BooksLineItem.put("rate",r_CrmLineItem.get("List_Price").toDecimal().round(2)); m_BooksLineItem.put("discount",ifnull(r_CrmLineItem.get("Discount_Percent"),0 ...; Created on 18 September 2023
18. Zoho Finance Suite Schedule: PATTERN NOT MATCHED: / Zoho /; What? A super quick article on resolving this issue if it ever appears again. Why? At time of print, this error was happening to schedules in Zoho Books, Zoho Inventory, and Zoho Subscriptions. ...; Created on 12 June 2023
19. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
20. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... output return m_Response; click on "Save Script" Test using the sidebar on the right Click on "Done" when satisfied. Click on the left arrow/caret to return to the ZohoCRM ZIA main page Clic ...; Created on 06 March 2023