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: Make Upload File Field Mandatory: / Zoho /; ... and Details Page (Standard). My use-case has a requirement that another dropdown called "Order Type" has to be set to "Supplier". My file upload field is called "Order Confirmation". v_OrderType = ZDK.Page.getField('Order_Type').getValue(); if ...; Created on 18 December 2024
9. Zoho CRM: Updating a CRM record Custom Line Items using API v7: / Zoho /; ... + p_QuoteID; r_QuoteDetails = invokeurl [ url :v_Endpoint type :GET connection:"zcrm" ]; l_RecordData = ifnull(r_QuoteDetails.get("data"),List()); for each m_RecordData in l_RecordData { // // ...; Created on 18 December 2024
10. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; ... = true; // // Mark the estimate as accepted r_Accept = invokeurl [ url :"https://www.zohoapis.com/books/v3/estimates/" + v_EstimateID + "/status/accepted?organization_id=" + v_OrgId type ...; Created on 04 November 2024
11. Zoho Creator: Input Color Picker: / Zoho /; What? An article on creating a color picker from a specific palette using an input field of a radio type. Why? At the time of print, this feature is not provided out-of-the-box and getting our ...; Created on 14 October 2024
12. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... = invokeurl [ url :v_Endpoint type :GET headers:m_Header connection:"my_workdrive_connection" ]; info r_TeamFolderInfo; The one to rule them all // ====================== // get folder ...; Created on 11 September 2024
13. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... _ if(!isNull(v_Template.get("templates").get("actions"))) { // get the actions l_Actions = v_Template.get("templates").get("actions").toList(); for each m_Action in l_Actions { if(m_Action.get("action_type") ...; Created on 06 August 2024
14. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... gave it the data type of "URL": Now to copy over the image URLs, I duplicated my web-browser tab (right-click on the browser tab if using Google Chrome and select "Duplicate"). I then arranged the ...; Created on 25 July 2024
15. Zoho Projects: Get All Events: / Zoho /; ... get all portals v_EndpointPortals = v_BaseURL + "/restapi/portals/"; r_Portals = invokeUrl [ url: v_EndpointPortals type: GET connection: "my_projects_connection" ]; info r_Portals; // // once ...; Created on 22 July 2024
16. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... + v_ZA_ViewID + "/data"; // // send request r_PurchaseOrders = invokeurl [ url :v_Endpoint type :GET parameters:m_Config headers:m_Header connection:"my_analytics_connection" ]; // // parse ...; Created on 09 July 2024
17. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... :v_Endpoint type :GET headers:m_Header connection:"my_connection" ]; //info r_Analytics; // // parse response if(r_Analytics.get("status") == "success") { m_ResponseData = ifnull(r_Analytics.get("data"),Map()); l_DataSources ...; Created on 02 July 2024
18. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... != "") { m_Params = Map(); m_Params.put("organization_id", v_BooksOrgID); m_Params.put("pricebook_id", m_LineItem.get("pricebook_id")); m_Params.put("item_ids", m_LineItem.get("item_id")); m_Params.put("sales_or_purchase_type" ...; Created on 23 May 2024
19. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... datatype v_TimeOffset = (v_LeadCreatedTime.subString(0,10) + " " + v_LeadCreatedTime.subString(11,25)).toString("yyyy-MM-dd HH:mm:ss", v_ThisTimeZone); // // set reminder time (exactly 1 working day ...; Created on 14 May 2024
20. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... "Event_Type" (single-line) and "JSON_Payload" (multi-line) m_CreateRecord = Map(); m_CreateRecord.put("Event_Type","Order Update"); m_CreateRecord.put("JSON_Payload",m_Payload.toString()); r_CreateRecord ...; Created on 22 April 2024