Search - Joel Lipman .Com

1. Zoho CRM: Permission Denied for Quote Conversion Mapping: / Zoho /; What? A really quick article for anyone experiencing the same issue: As a super admin in CRM, I am denied permission to access the Quote Conversion Mapping page... Why? I wanted to map a billing ...; Created on 02 September 2021
2. T-SQL Conversion failed when converting the varchar to data type int: / Transact-SQL /; What? A very quick note in case I forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read ...; Created on 14 May 2013
3. Transact-SQL Date Format Conversions: / Transact-SQL /; Source: http://www.kodyaz.com/articles/sql-format-date-format-datetime-t-sql-convert-function.aspx; Created on 19 November 2010
4. Can't play music after Firmware Update Version 3.: / IT Support /; Well we're all happy that the iPlayer from the BBC has come to PS3 in Europe but I'm less impressed about the multi-audio output. My setup is that the sound goes from the Playstation to the Sound System ...; Created on 21 September 2009
5. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... the example of a credit application you want to send to your customer, and when they complete it, the PDF version gets attached to their contact record... all from one click of a button: Scenario ...; Created on 06 August 2024
6. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... create task: Create a workflow that runs on lead create (record action) and the criteria can be where "Lead Conversion Time" is less than 4 (4 days not 4 business days?). Though I've removed this condition ...; Created on 14 May 2024
7. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... - Not the used final version): 0) { if(c_Quote.Name != null) { v_Firstname = c_Quote.Name.first_name; v_Lastname = c_Quote.Name.last_name; } if(c_Quote.Email != null) { v_Email ...; Created on 07 May 2024
8. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... // resolve connection details if(!isNull(r_ShopifyConnection.get("data"))) { m_Data = r_ShopifyConnection.get("data"); v_ShopifyID = ifnull(m_Data.get("Shop_ID"),""); v_APIVersion = ifnull(m_Data.get("API_Version"),""); v_AccessTo ...; Created on 22 April 2024
9. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... Creator. Having this example for future use might save me some time. The following is the early version of a JS widget used for a customer and before I added all the layers of complexity, I want to have ...; Created on 14 March 2024
10. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... would suffice but here is my first version of the script: /* ******************************************************************************* Function: - Label: Products - Correct Decimals ...; Created on 13 December 2023
11. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... based on its identifying number (allows other attachments to remain intact) Generate the file The code here is a cut down version just to demonstrate generating a text file and storing this into ...; Created on 02 October 2023
12. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; What? A quick article on determining the week number of the year if your week starts on a Monday and not a Sunday. Why? I think it's the US system which generally says that a week starts on a ...; Created on 06 July 2023
13. Zoho CRM: Change System Field Length: / Zoho /; ... out-of-the-box differ in length so they do not list the postal code on the deal record to be listed in the "Lead Conversion Mapping" page. In the Leads module, the Zip field is 30 characters; in the ...; Created on 19 June 2023
14. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... " + v_AccessToken); // v_TradingAPIVersion = 967; v_Endpoint = "https://api.ebay.com/ws/api.dll"; // // build header m_Headers = Map(); m_Headers.put("X-EBAY-API-SITEID",3); m_Headers.put("X-EBAY-API-COMPATIBILITY-LEVEL",v_TradingAPIVersion); v_ApiCal ...; Created on 27 April 2023
15. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... get access token v_AccessToken = standalone.fn_eBay_GetAccessToken(); // v_TradingAPIVersion = 967; v_Endpoint = "https://api.ebay.com/ws/api.dll"; // // build header m_Headers = Map(); m_Headers.put("X-EBAY-API-SITEID",3); m_Headers.put("X-EBAY-API-COMPATIBILITY-LEVEL",v_TradingAPIVersion); v_ApiCall ...; Created on 29 March 2023
16. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... ent") + "\n\n- ChatGPT"; } } } // if(!b_ContactedChatGPT) { my_Text = "Oops! I didn't understand that last question. Calm down, I've been upgraded to version 2.0 so as to give you a ...; Created on 06 March 2023
17. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... = List(); l_CsvFileRows.add(v_ReportCSV); // // get access token v_AccessToken = standalone.fn_eBay_GetAccessToken(); // v_TradingAPIVersion = 967; v_Endpoint = "https://api.ebay.com/ws/api.dll"; // // ...; Created on 01 March 2023
18. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... get access token (you will need your own function here as documented in my article v_AccessToken = standalone.fn_eBay_GetAccessToken(); // v_TradingAPIVersion = 967; v_Endpoint = "https://api.ebay.com/ws/api.dll"; // // ...; Created on 28 February 2023
19. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... on Shopify,Modified on Shopify,Published on Shopify"; l_CsvFileRows = List(); l_CsvFileRows.add(v_ReportCSV); // // app specific v_ShopID ="joels-awesome-shop"; v_ShopifyApiVersion = "2022-01"; v_AccessToken ...; Created on 20 February 2023
20. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... browsing to https://platform.openai.com/account/billing/overview. At time of print, the paid plan is a pay as you go or pay as you use. Previous Models/Versions Based on the documentation: In ...; Created on 13 February 2023