Search - Joel Lipman .Com

21. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... of the conversation was about: Well we can populate the list of messages so that there is a conversation trail for the OpenAI ChatGPT to build on: // // initialize m_Response = Map(); v_Message ...; Created on 13 February 2023
22. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... aspect ratio Glibatree: The following are prompts shared on Glibatree's YouTube channel (see "Sources" below): portrait: ::5 Premium Portrait Photography::4 well-lit, sharp-focus, high-quality, ...; Created on 11 February 2023
23. ZohoCRM: Import Attachments: / Zoho /; ... of an "Attachments.csv" file that needs the correct values in each column and the "Attachments.zip" containing the files to attach that needs some formatting as well: Note that any IDs used in the snippets ...; Created on 16 January 2023
24. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... value in a field, a row would be added to a subform contained herein. How? Well I won't go in to detail on how to add a client script, this article is just to show the snippet of code used in the ...; Created on 09 December 2022
25. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... nvitm."Item ID", invitm."Quantity" And lastly we can group by invoices in the month and sum up the profits as well as include the customer name and other invoice references for the client's report: ...; Created on 03 November 2022
26. Zoho Deluge: Generate a loop or list of any size: / Zoho /; What? This is an article on a trick I picked up from one of our interviewees as well as apparently in one of the Zoho documentation manuals. It uses leftpad to create a string of a length, converts ...; Created on 21 October 2022
27. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... r_Attach; // // to send this as an email as well sendmail [ from :zoho.adminuserid to :"This email address is being protected from spambots. You need JavaScript enabled to view it." subject :"ZohoSign Test - Request: " + v_RequestI ...; Created on 17 October 2022
28. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... as you would any other reading stuff. It’s true you need to go through an initial set-up process which essentially boils down to getting your email ID added to the approved list as well as finding out ...; Created on 29 June 2022
29. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... on eBay webhooks). Instead, all we want is the URL of an image to be downloaded, then uploaded to the Zoho Inventory or Zoho Books item record. Well I don't want to research this often so here's the ...; Created on 21 June 2022
30. Zoho Creator: Embed Forms/Reports on a Page: / Zoho /; What? Well known by most but this serves as a quick reminder to myself and anyone else on how to embed a form or a report into a Zoho Creator page. Why? Cos How? The below is a template ...; Created on 05 May 2022
31. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... > Go to Search > Device Manager > Expand "Display Adapters" You should see your Graphics Card listed but as well as a Windows Integrated Graphics or Intel Integrated Graphics option which is disabled ...; Created on 12 March 2022
32. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... the attachments on the CRM record from within the Creator app. As for the add a new attachment, well that's just functionality. Here's my Creator form (well the part for the attachments): An attachments ...; Created on 11 March 2022
33. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... was to recover the relevant product based on any given Product SKU. Making the above into a function as well as returning the inventory item ID and the product ID: map API.fn_SearchShopifyBySKU( string ...; Created on 14 February 2022
34. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... fields and not really knowing which one defines the stage the lead is at. How? Well this can be done through a validation rule. After working in Zoho CRM for over 3 years, this is the first time ...; Created on 11 February 2022
35. 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
36. ZohoCRM: Template: not being able to edit a text box: / Zoho /; ... to say this is a strange issue and an even stranger fix, but I've tested this solution by getting a colleague to refresh the page and check it out as well as the client to go in and confirm the change was ...; Created on 25 January 2022
37. 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
38. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; ... Additional: Daylight Savings Time Just to cover all aspects of this, I create a Zoho Creator form with the timezone names, their offset and their DST offset as well as a boolean to say whether ...; Created on 07 December 2021
39. Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time field: / Zoho /; ... "expected_data_type": "datetime", "api_name": "Check_Date_Time" }, "message": "invalid data", "status": "error" } How? We're going to parse the created date and time parts as well as the ...; Created on 11 November 2021
40. Zoho Creator: Change Radio into Tabs: / Zoho /; ... to be changed as well to the new name and follow the syntax .zc-NewName-group{}]. What I have (Original) I want to run some deluge (snippets below) every time the form loads, so I Go to Workflows ...; Created on 22 October 2021