Search - Joel Lipman .Com

1. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; What? This is an article to demo some Deluge code on how to download a file that was uploaded in CRM in a custom module in field that was of type "File Upload". Why? Just to remind me where I went ...; Created on 02 February 2021
2. Zoho Deluge - Counting in a Map dataType: / Zoho /; What? A quick article on how to count within a map. I didn't have too much difficulty getting this to work and I'm not sure if there are better ways of counting so I'm documenting it to see if I can ...; Created on 02 September 2019
3. Creating a custom form field type for Joomla XML fieldset: / Joomla /; ... Joomla component and needs some SQL dependent on some dynamic variables. Why? In Joomla, the XML type of "sql" is extremely limited. The component I'm making has to ensure user's can only see their ...; Created on 25 October 2013
4. 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
5. Joomla field types clear my html: / Joomla /; What? Trying to make a component and can't remember how to store HTML code when the save command is clicked (ie. submitted from a PHP form). This is for the Opensource Content Management System (CMS ...; Created on 09 August 2012
6. Returned a data type that is not valid: / Transact-SQL /; Thought I'd put a note on this error. Bearing in mind that this is a general data type error and not just because I tried to convert a date in SQL format to a Month name. An error occurred during ...; Created on 06 January 2011
7. MySQL Data Type Reference Table: / MySQL /; A data type reference table. If you're designing a database then you don't need me to tell you what this is. My personal opinion is to always try to use the minimal type and length of the value required. ...; Created on 15 February 2010
8. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; ... = "https://zohoapis.com/crm/v2/settings/inventory_templates/" + v_TemplateID + "/actions/print_preview?record_id=" + p_QuoteID + "&print_type=pdf"; f_FileRequest = invokeurl [ url :v_Url ...; Created on 18 August 2022
9. Zoho Inventory: Mark a package slip as delivered and shipped: / Zoho /; ... + v_BooksOrgID); v_Url = "https://inventory.zoho.com/api/v1/shipmentorders?" + l_UrlParams.toString("&"); r_CreateShipment = invokeurl [ url :v_Url type :POST parameters:m_Params.toString() connection:"jl_inventory" ]; inf ...; Created on 14 July 2022
10. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... = 123456789012345678; // // your organization ID (optional) v_BooksOrgId = 20220621; // // download photo from eBay r_DownloadedPhoto = invokeurl [ url :v_EbayPictureUrl type :GET ]; // // ...; Created on 21 June 2022
11. GoDaddy Apache cPanel: Install SSL Certificate: / cPanel /; ... for Select the Server Type and then click on "Download Zip File" button Decompress the ZIP and find the CRT file Return to your GoDaddy page and scroll down to "Web Hosting" then click ...; Created on 07 April 2022
12. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... + "/image?organization_id=" + v_BooksOrgID + ""; r_File = invokeurl [ url :v_Url type :GET connection:"joel_zoho" ]; r_File.setParamName("file"); // // store this file in the field "Creator ...; Created on 31 March 2022
13. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... all monitors are now connected to my home PC. The way to do this might be different for you depending on the components of your PC. So here's a list of what I used: TypeComponentQuantityPrice (GBP) Reused ...; Created on 12 March 2022
14. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... + v_CrmContactID + "/Attachments/" + r_Attachment.get("id"); r_Download = invokeurl [ url :v_AttachmentEndpoint type :GET connection:"ab_crm" ]; r_Download.setParamName("file"); r_CheckIfDocumentAlreadyExists ...; Created on 11 March 2022
15. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... for this, I created the following Creator form: The fields: Calendar Day Select (link name: Calendar_Day_Select || type Radio) Form CSS (link name: Form_Css || type Add Notes) Selected Value for ...; Created on 09 March 2022
16. Zoho CRM: Schedule a Meeting using Deluge: / Zoho /; ... with TEST LEAD"); // // the description m_ScheduleMeeting.put("Description","More info / agenda"); // // the type m_ScheduleMeeting.put("Type","Prospective Meeting"); // // the meeting location m_ScheduleMeeting.put("Venue","Onlin ...; Created on 02 March 2022
17. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... = r_ShopifyAPI.API_Version; v_AccessToken = r_ShopifyAPI.Access_Token; // // set header parameters m_Header = Map(); m_Header.put("Content-Type","application/json"); m_Header.put("X-Shopify-Access-Token", ...; Created on 14 February 2022
18. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... layout didn't work Choose field to validate > Select "Lead Status" Choose validation type as "Validate using function" and click on "Next" For functions, select "Write your own" Give it a function name, ...; Created on 11 February 2022
19. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... integers when the datatype is an integer and not a decimal: // syntax: // v_Test9.round(2); // round(v_Test9, 2); v_Test9 = 10.0; info v_Test9.round(2); // yields 10.00 v_Test10 = 10; info ...; Created on 08 February 2022
20. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... request XML as a string r_ResponseXML = invokeurl [ url :v_Endpoint type :POST parameters:x_Params headers:m_Headers ]; // // output response info r_ResponseXML; /* // // ...; Created on 22 January 2022