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 Creator: Input Color Picker: / Zoho /; What? An article on creating a color picker from a specific palette using an input field of a radio type. Why? At the time of print, this feature is not provided out-of-the-box and getting our ...; Created on 14 October 2024
5. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... s:" + v_ZS_RequestID); for each m_ZCRM_Doc in l_SearchResults { // // check we have the right one if(m_ZCRM_Doc.get("Request_ID") == v_ZS_RequestID) { // // retrieve the ...; Created on 06 August 2024
6. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... "Dashboard": Then in the top right of the dashboard, I'm going to click on the "Widget" button: On the data column, I'll select any query and any field. It doesn't matter which one here, as ...; Created on 25 July 2024
7. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... amount/total is a currency column we want aligned on the right l_HeaderColumns.add(); l_HeaderColumns.add(); // // build up related list rows l_RelatedListData = List(); for each m_DataRow in l_DataRows { // ...; Created on 09 July 2024
8. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... to ZohoPeople as a system administrator Click on the cog icon in the top right to go to the setup screen. Under "Automation", click on "Scheduler" Click on the "Add Scheduler" button Complete the ...; Created on 02 July 2024
9. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... is sitting right now. The code snippet to get the item record from the price book Note that I'm using a connection called "zbooks" and it has every permission under the sun (the naughty ZohoBooks.fullaccess.all) ...; Created on 23 May 2024
10. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... first designing the template, there could have been a fair few improvements right out of the gate. Then the client comes back and says things like "can we add this?", "can it say this instead?", "can it ...; Created on 07 May 2024
12. Zoho CRM: Client Script Confirmation Box and Popup Mailer: / Zoho /; ... top right next to the profile image) Under "Developer Hub" go to "Client Script" Click on "New Script" button (the blue one - not the "Add Script" grey one) Give the client script a name, I'm calling ...; Created on 06 February 2024
13. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... number "OrgId" there Note this down for later use Get the ZohoAnalytics Org ID: Login to ZohoAnalytics and ensure you are at the "Home" level Click on the cog icon in the top-right for "Settings" ...; Created on 05 December 2023
14. Zoho CRM: ZDK Client Script: Auto-Select Pipeline based on User Department: / Zoho /; ... icon (top-right most) to edit any profile On the user's dialog/popup in the bottom left, there will be a link saying "Manage Fields" Add a picklist field type called "Department" with the options "Hir ...; Created on 16 October 2023
15. Zoho CRM: Change System Field Length: / Zoho /; ... you are wanting to edit) > and select the layout (eg. "Standard") Click on the ellipsis/3 dots icon of the system field you want to hack and select "Edit Properties" Right-click on the "Number of Characters ...; Created on 19 June 2023
16. 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
17. 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
18. 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
19. 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
20. 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