Search - Joel Lipman .Com

1. Oracle: order by subquery missing right parenthesis: / Oracle PL/SQL /; What? A quick note on how I got round one this one. Why? Often enough, our requirement is that the latest record from another table is associated with the current row, and often enough we get ...; Created on 05 December 2013
2. Add "Command prompt from here" to right-click context men: / Windows OS /; Applies to: Microsoft Windows XP How? I keep having to do this every year as I reghost all my machines (=restore to sorta factory settings), so instead of googling it and going through other ...; Created on 27 January 2010
3. Copyright: / Static Items /; This website and its content is copyright of Joel Lipman .Com © 1999 - 2009. All rights reserved. Any redistribution or reproduction of part or all of the contents in any form is prohibited other than ...; Created on 30 May 2009
4. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkit: / Zoho /; ... article, this is how to get to them Login to ZohoCRM Go to Setup (cog icon in the top right next to your profile picture) Under Channels, go to Email Click on the "Email Deliverability" tab Under ...; Created on 04 May 2023
5. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... Getting to the development-side Login to ZohoCRM as a super-admin Go to Setup (cog icon in the top right) Under Zia, select "Conversational AI" Click on the link "Zia Developer Console" (yours ...; Created on 06 March 2023
6. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... generate using the above keywords/tokens. Usage: ...in the style of... Note that some of these may verge on Copyright Infringement so be careful if posting commercially (ie. appropriation). Please ...; Created on 11 February 2023
7. Zoho Analytics: Set Up a Widget Displaying Sales Person: / Zoho /; ... these kind of columns available to you: Click on Widget in the top right Under "Data Column", select any field in your table/query which is not the one to display Under "Group By", select the field ...; Created on 24 October 2022
8. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; ... on the ellipsis or three horizontal dots button in the top right and selecting "Send Mail" then selecting which inventory template to use... This is too many steps for some. Instead, we've been asked to ...; Created on 18 August 2022
9. Zoho Desk: Re-enable Desktop Notifications after clicking on "Not Now: / Zoho /; ... you are using the Google Chrome web browser. In this case version 100 and is correct at time of print. Open Chrome Web Browser Click on the vertical ellipsis/3 dots icon int the top right Click ...; Created on 20 July 2022
10. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... option Account and Lists which should show somewhere along the top right of the home screen. Under Account and Lists, look for Your devices and content > Manage Devices. You will get to see the list ...; Created on 29 June 2022
11. GoDaddy Apache cPanel: Install SSL Certificate: / cPanel /; ... caret by your name in the top right corner, then click on "My Products": Scroll down to SSL Certificates and click on the "Manage" button alongside the domain you want to install the SSL certificate ...; Created on 07 April 2022
12. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... Step-by-step Add Zoho Creator to your Zoho One Login to Zoho One Go to Settings (cog in top right) Click on Applications i the sidebar Click on the Add Application button Select Creator by clicking ...; Created on 31 March 2022
13. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... > Right-click on it, enable it and select "Update Driver" Either via the device manager or just from pure frustration, you should get a prompt to download the Intel Graphics Command Center app from the ...; Created on 12 March 2022
14. 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
15. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... Click on "Save" Click on "Install App" button in the top right Confirm by clicking on "Install" button in the popup You will be shown your Admin API access token > Store this in the Access Token ...; Created on 14 February 2022
16. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... be selectable. Two separate fields weren't quite right either: 1 as read-only (permission only to higher level) and 1 picklist as selectable means that the first-line agent would be referring to 2 status ...; Created on 11 February 2022
17. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... this isn't quite right, so let's get a regex that rounds numbers up but pays attention to where the decimal point is: v_Test3 = 12.000; info v_Test3.toString().replaceAll("^(^-?\\d+\\.\\d*[1-9])(0+$)|(\\.0+$)", ...; Created on 08 February 2022
18. Zoho CRM: Template: Empty Space between Header and Line Items: / Zoho /; ... > Select the template with this issue Click on the "Edit HTML" icon in the top right of the editor: Find the code "page-break-inside" Change this from "avoid" to "auto": And optionally, ...; Created on 03 February 2022
19. ZohoCRM: Template: not being able to edit a text box: / Zoho /; ... "2" (or your own company initials just to show the customer who's boss). Now click on the pencil icon of the cloned template Right-click on the text box causing the issue and select "Inspect" (if you ...; Created on 25 January 2022
20. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; ... How? Well, let's setup the FTP connection first in Zoho Analytics: Login to Zoho Analytics Click on "Data Sources" in the left sidebar then click on "Add Data Sources" in the top right: ...; Created on 12 January 2022