Search - Joel Lipman .Com

1. 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
2. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library): / Google /; What? So this is supposed to be a quick article detailing how I used a PHP function to upload a video file to Google Drive. Note that this example does not involve installing the Google Client Library ...; Created on 29 October 2018
3. MS-DOS: Copy folders without overwriting files: / MS-DOS /; What? A quick note on how to copy files and folders over without overwriting existing files. It's easy to say "Yes" and replace all files. What I need is something that synchronizes files on an internal ...; Created on 23 February 2014
4. Fix Oracle Tnsping 3511 without Windows Registry: / Oracle PL/SQL /; ... on "Environment Variables" Under "System Variables" modify the variable "ORACLE_HOME" (without the quotes). Or create NEW if it doesn't exist. Give it the value C:\ORACLE\product\11.2.0\client_1 OK ...; Created on 04 March 2013
5. Administrator Program Shortcut without Prompt: / Windows OS /; ... double-click and it will run the above programs in administrator mode without confirmation by the Windows operating system. At home this may not be a problem but this is intended for those in an office ...; Created on 25 February 2013
6. Sort order a dropdown list in MS InfoPath without programming: / Infopath /; So this is for Microsoft Office Infopath 2007 (SharePoint 2007). The situation is that I started creating a SharePoint List (datasheet) and when I made my form dropdown read from the list, it just ...; Created on 21 July 2011
7. CSS Background Without Causing Scrollbars: / Cascading Stylesheets /; Quick note in case I spend as long as I did again. A Client had some clouds on the background of his photoshop file for his website. They were to be positioned in the top right corner with the leftmost ...; Created on 23 April 2011
8. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... that file sat on someone's mailbox. It must be downloaded (as in browser downloads it to the computer immediately) and then removed from wherever it was downloaded from... All within ZohoBooks without ...; Created on 02 October 2023
9. Zoho Deluge: Proper Case for Names: / Zoho /; What? This is an open article without any completion in mind; to set the proper case of a name, as in capitalize the first letter, lower case the rest but then with exceptions. Why? Some of the ...; Created on 13 July 2023
10. Zoho Deluge: Determine if Daylight Savings are in effect: / Zoho /; What? If you're lucky enough to build an application for a client based in a country that changes its clocks twice a year, then I'm opening this article without a 100% certain solution as I need to wait ...; Created on 03 July 2023
11. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... "Fn - eBay - Get Active Products" and give it the internal name as "fn_GetEbayActiveProducts" without any arguments. Something to note in the below is that it asks you to set an estimated number of products ...; Created on 01 March 2023
12. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; What? An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this ...; Created on 28 February 2023
13. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... /imagine and then a space and then type your idea (eg. "fire mage, steampunk victorian, detailed, full body hyperrealistic female" without the quotes to get the left image here). Type /help for other ...; Created on 11 February 2023
14. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... a rate without any preset values. Rates will be taken from the Opportunity record. If these are blank then enter the rates manually below: Rate Year 1.0, Rate Year 1.5, ..."); } // updat ...; Created on 09 December 2022
15. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... writing this article as it had gone through several partners before us and even Zoho themselves without a solution. This took my team the best part of two months to find a solution. How? Disclaimer ...; Created on 03 November 2022
16. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... you or may be already working for you without this issue. By changing the workflow to execute not "When any field is upddated" but "When any selected field is updated" and then selecting the fields "Status", ...; Created on 17 August 2022
17. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... app without building a JS Widget or using Nodejs... Or we can make do with the tools provided. The brief was similar to the Zoho Bookings interface where their Creator app is to present the user with ...; Created on 09 March 2022
18. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... if your search query string has spaces in it, the above without the small apostrophes (single-quotes) will return either a parsing error or just no data. In the line: v_GraphQl = " product } } } }" Change ...; Created on 14 February 2022
19. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... and display 12.5% instead of 12.50%. Well there might be a longer solution without using a regular expression (regex), as in check for the decimal point, check each digit thereafter to see if there ...; Created on 08 February 2022
20. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... the last element. At time of print, I ran this to retrieve 1970 active product IDs and their SKUs without erroring by going over the Zoho Deluge statement execution limit. Additional: See my ...; Created on 12 October 2021