Search - Joel Lipman .Com

1. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... */ // freezes the GUI? ZDK.UI.freeze(true); // attempt try { // taken from stackoverflow: https://stackoverflow.com/questions/17369098/simplest-way-of-getting-the-number-of-decimals-in-a-number-in-javascript ...; Created on 13 December 2023
2. 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
3. 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
4. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... yields 12.35 v_Test6 = 120.000; info v_Test6.toDecimal().round(2); // yields 120.00 v_Test7 = -123.4567; info v_Test7.toDecimal().round(2); // yields -123.46 Source(s): StackOverflow: ...; Created on 08 February 2022
5. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; What? So this is an article expanding on my article Zoho Deluge - Connect to Xero API and explores how instead of a schedule, we can get Xero to tell ZohoCRM whenever an invoice or contact gets updated ...; Created on 10 January 2022
6. Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Div: / Zoho /; ... -ms-user-select: none; } .onoffswitch-checkbox { display: none; } .onoffswitch-label { display: block; overflow: hidden; cursor: pointer; ...; Created on 22 October 2020
7. MySQL: Count occurrences of words in a column: / MySQL /; What? This is an article to document how to output the most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count ...; Created on 12 March 2020
8. 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 ...; Created on 06 May 2019
9. Change div height to fit content: / Cascading Stylesheets /; ... is: A long heading that wraps over several lines When I shrink the browser, I get a heading like this: I want this to happen: The code of this is the addedn overflow:hidden;height:1%;: A ...; Created on 19 December 2016
10. Make bootstrap carousel responsive to swipe: / Bootstrap /; What? A quick reminder on how to make the carousel in bootstrap compatible with touch devices like smartphones and tablets. Why? Feed back was that the user was unimpressed with the image slideshow. ...; Created on 14 December 2016
11. Trim values along with the tab: / MySQL /; ... Unfortunately, the MS Excel software adds tab characters to delimit the columns... How? UPDATE `mytable` SET `myColumn` = TRIM(CHAR(9) FROM TRIM(`myColumn`)); Source: Stack Overflow - How to ...; Created on 13 June 2016
12. Import Excel CSV file as JavaScript array: / Excel /; ... on a criteria var my_array = populate_array_from_csv(this_file_url); // eg. var my_array = populate_array_from_csv('./mydata/data.csv'); // ---- End-ofFile Additional Information(s): StackOverflow: ...; Created on 05 October 2015
13. 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
14. List of Font Awesome: / Web-Development /; ...  fa-square-o [] 4.0  fa-stack-exchange []  fa-stack-overflow ...; Created on 04 September 2015
15. Android Background Image Resolutions: / AndroidOS /; ... 960dp x 720dp large screens are at least 640dp x 480dp normal screens are at least 470dp x 320dp small screens are at least 426dp x 320dp Source: Stack Overflow: Android activity image background ...; Created on 01 December 2014
16. Two icons created on Android: / AndroidOS /; What? If you're installing an app and it creates two icons: Why? I don't think I'll forget this one but I was stumped for a bit until I found it on the a forum: Stack Overflow: Android App Development. ...; Created on 20 October 2014
17. JComments 2.3.0 with ReCaptcha in Joomla 2.5.x: / Joomla /; Applies to: Joomla CMS v2.5.11 (Joomla.org) jComments v2.3.0 (JoomlaTune.com) What? Posting this as it was rather rewarding to achieve and I hope will be of some use to others in the same boat. ...; Created on 20 March 2014
18. Compare two databases using T-SQL: / Transact-SQL /; ... here and then just built on this. Method #1 I got this first query from the awesome site that is StackOverflow: SELECT * FROM INFORMATION_SCHEMA.COLUMNS Run this command against both databases ...; Created on 24 September 2013
19. Reorder Columns in a Table: / Databases /; What? Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns ...; Created on 22 July 2013
20. Administrator Program Shortcut without Prompt: / Windows OS /; ... was created to run. Related Link(s): Elevated Program Shortcut without UAC Prompt Avoid UAC prompts by using an elevated program launcher StackOverflow: Need to elevate permissions ...; Created on 25 February 2013