Search - Joel Lipman .Com

1. Trim values along with the tab: / MySQL /; What? A quick article on how to trim in MySQL along with getting rid of any leading or trailing tab characters. Why? I use MS Excel for organizing data and then converting to MySQL commands. ...; Created on 13 June 2016
2. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... Image" > "Image Library" (as mentioned in earlier steps), then right-click on the image and select "Copy Image Address", and paste it into the cell alongside the status key in the data table: Don ...; Created on 25 July 2024
3. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... Functions" Click on the Plus icon alongside this, scroll down to "Custom Functions" and click on "New" I give it the function name fn_Tickets_OnCreateEdit I click on "Edit Arguments" and give it th ...; Created on 05 December 2023
4. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... s rename the file the name of the staff member along with the file type v_FileName = m_User.get("full_name"); v_FileExtension = m_SignatureImage.get("extn"); v_FileNameFull = v_FileName + " ...; Created on 05 December 2023
5. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... you have sent the code to either create or update the estimate in ZohoBooks. You will need the returned estimate ID and I'm not 100% sure the attention/phone number goes along as my client didn't include ...; Created on 18 September 2023
6. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; What? A quick article on getting the payment terms in Zoho Books along with their IDs. Why? I often need to send through an automatic payment term on the creation of an invoice but lots of my ...; Created on 06 July 2023
7. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... enabled. But to flesh that out a little more along with setting the other options under "Advanced Tracking" // // get chart of accounts to use r_ChartOfAccounts = invokeurl [ url :"https://books.zoho.eu/api/v3/chartofaccounts?organization_id=" ...; Created on 04 May 2023
8. Zoho Creator: Disable/Hide the add and delete subform row buttons: / Zoho /; ... a list of services. The client does not want their operations team adding/deleting rows and instead simply specifying quantity (defaulting to zero) alongside each serviceable item. How? So at time ...; Created on 28 February 2023
9. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... } } The one to rule them all So I've been asked here and on the forums as well for the full query that includes making ChatGPT keep the context of the conversation along with new cliqs: / ...; Created on 13 February 2023
10. Zoho Analytics: Set Up a Widget Displaying Sales Person: / Zoho /; ... display above the sales person (eg. "Sales Person") Alongside the Value field, enter $.LABEL Under Label: Display 'Unknown' as, enter a dash/hyphen to indicate not known. Click on the button Apply ...; Created on 24 October 2022
11. 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
12. 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
13. GoDaddy Apache cPanel: Install SSL Certificate: / cPanel /; ... add it to this article. How? I know there are instructions on the GoDaddy website but this is how I do it along with screenshots: Login to your GoDaddy panel and expand the menu by clicking the ...; Created on 07 April 2022
14. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... really a hardware kind of guy. My skillset is really around software (see my other articles) and I've been using Mac alongside my PCs for the past 7 years. My MacBook is from 2015 and still runs everythin ...; Created on 12 March 2022
15. Zoho Deluge: Today, Tomorrow, Day After but Skip Sunday: / Zoho /; ... the .addDay(), check none of these are a Sunday, and move the next few days along: thisDate = '2021-10-30'; v_Today = thisDate; v_Tomorrow = v_Today.addDay(1); v_NextDay = v_Today.addDay(2); if(v_Today.getDayOfWeek()==1) { v_Today ...; Created on 02 November 2021
16. Zoho Creator: Change Radio into Tabs: / Zoho /; ... tabs along the top to display each section. How? The way we do this is by applying our own stylesheet and overriding certain CSS elements that the vanilla or out-of-the-box Zoho Creator ones provide. ...; Created on 22 October 2021
17. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... if statement to all fields? Well no again, just compare on the workflow of the audit change. Something along the lines of: Add an Audit Change field: This will contain the code triggered when one ...; Created on 19 September 2021
18. Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name): / Zoho /; ... pencil icon to edit this Alongside "Field Type", select "First Name, Last Name" Now your booking form will be similar to the following: And if the account is integrated with Zoho CRM, ...; Created on 01 September 2021
19. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... Why? At time of print, Zoho had recently introduced the ability to have custom fields in your line items, alongside the product name, list price, quantity, tax, etc. In the example below, we have ...; Created on 17 May 2021
20. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... zet at https://127.0.0.1:5000 along with the instructions “please enable the host (https://127.0.0.1:5000) in a new tab and authorize the connection by clicking Advanced -> Proceed to 127.0.0.1 (unsafe)”. ...; Created on 24 October 2020