Search - Joel Lipman .Com

1. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... Additional Note(s): Allowed role IDs for files: 34 - View 5 - Edit 4 - Share 6 - View and comment 33 - View and fill Allowed role IDs for folders: 6 - View 5 - Edit 3 - Organize 7 - ...; Created on 11 September 2024
2. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... Zoho Sign Template with the pre-filled fields to the desired recipient/ recipients r_SignResponse = zoho.sign.createUsingTemplate(v_TemplateID,m_Parameters); // info r_SignResponse; // // get request ...; Created on 06 August 2024
3. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... into an image. Even if this is filled with URLs for images stored on remote websites, it helps to preview the images. Right-click on the header of the 2nd column and select "Format Column": I changed ...; Created on 25 July 2024
4. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... bot Login to ZohoCliq Click on your profile picture Select "Bots & Tools" Click on "Create Bot" (or "Edit Handlers" on an existing bot) Fill in the details then edit the Handlers. For demo purposes, ...; Created on 13 February 2023
5. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... Yellowist Zombie Lighting Ambient Light Artificial Lighting Back Light Blacklight Broad Lighting Cinematic Lighting Contre-Jour Dekatron Electroluminescent Feathering Light Fill Light Fluorescent ...; Created on 11 February 2023
6. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... // other fields to fill in for this subform row v_RateCardDisp = v_RateCard.indexOf(" (")>0 ? v_RateCard.substring(0, v_RateCard.indexOf(" (")) : v_RateCard; json_Arg.Rate_Change_Notes = v_RateCardDisp; ...; Created on 09 December 2022
7. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... > API Tokens > then API token - deployment > Get Started Fill out the client ID and client secret along with the Grant Code Click the button and you will get a refresh token which you can copy for the ...; Created on 17 October 2022
8. Zoho Creator: Populate a Multi-Lookup: / Zoho /; What? This is a very quick article with a code snippet on how I added to a multi-lookup field. Why? Using a multi-line or text is possibly a quicker solution and when using a desktop interface, ...; Created on 18 August 2022
9. ZohoCRM: ZDK Client Script to retrieve Contact Email: / Zoho /; ... on save of the record, but the client wants the email to be prefilled in the field as soon as a contact is selected. How? This needs to behave like a formula field which changes and displays before ...; Created on 20 July 2022
10. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... Admin API scopes": This will be dependent on what your app needs to do. In this example, mine needs to sync orders, products, customers, and some reports; the other things like discounts, fulfillment ...; Created on 14 February 2022
11. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
12. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... We asked Zoho for a solution that might work and were given the following snippet of code (not tested yet!). It looks like we have to fill in the blanks and it's on the same path as we were. The mai ...; Created on 10 December 2020
13. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... Fill in the new form to Create New Client: Client Name: put something descriptive so it is easy to identify if the client has 3rd-parties adding clients. eg. "JoelLipman_BooksConnector". Homepage ...; Created on 12 August 2020
14. CSS Printing - Page Break Inside with Headers and Footers: / Cascading Stylesheets /; ... this is obviously for when it comes to printing. Why? I needed to create a template in HTML where the first page is a cover page (background image filling the page with a logo floating at the centre) ...; Created on 22 February 2019
15. GDPR Privacy Policy: / Static Items /; ... to the website in question. Controlling your personal information You may choose to restrict the collection or use of your personal information in the following ways: whenever you are asked to fill in ...; Created on 14 February 2019
16. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... Sheets.FillAcrossSheets ws.Range("1:1") End Sub ' Now split to files Sub Splitbook() Dim xPath As String xPath = Application.ActiveWorkbook.Path Application.ScreenUpdating = False ...; Created on 11 February 2019
17. Zoho Deluge: Loop through 30 Minute Slots: / Zoho /; What? This code snippet took me a while to do and the documentation is flaky so I thought I'd make a note here just in case I need to refer to it again. Why? I want to modify a picklist and fill ...; Created on 30 November 2018
18. SSRS Change Background Color of Image: / SQL Server Reporting Services /; ... areas but displays the report background color instead: Right-click on the cell you want to put the image in. Insert > Rectangle Set the Rectangle Fill color (I'm using an expression based on the ...; Created on 08 April 2014
19. SQL: Use CASE for Relevance column: / MySQL /; ... a real quick one for a dropdown search field which has to find relevant terms to autofill/autocomplete a search form: -- where @ThisSearch is a posted (and sanitized) variable SET @ThisSearch:="Brains"; SELECT ...; Created on 03 August 2013
20. Search a database for a string (MySQL, T-SQL): / Databases /; ... FROM information_schema.COLUMNS WHERE TABLE_SCHEMA IN ('network_detail'); DECLARE CONTINUE HANDLER FOR NOT FOUND SET done=1; #Truncating table for refill the data for new search. PREPARE trunc_cmd FROM ...; Created on 08 October 2012