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: Schedule a Task: Timesheet Reminder: / Zoho /; What? A quick article to demonstrate code that creates a task in CRM based on the time logged against an Event/Meeting. Why? As developers, we're keep account of our time and we are currently ...; Created on 02 December 2021
9. Zoho CRM: Schedule a Call using Deluge: / Zoho /; ... Call with " + v_CustomerName); m_ScheduleCall.put("Call_Start_Time",v_SystemAppointmentDateTimeStart); m_ScheduleCall.put("Call_Status","Scheduled"); m_ScheduleCall.put("Call_Type","Outbound"); // // optiona ...; Created on 18 November 2021
10. Zoho Creator/Deluge: UnPredictable exception, Invalid statement found: / Zoho /; ... select a bunch of creator records (ok all of them) l_AllRecords = myForm[ ID != 0 ]; // // loop through these for each r_Record in l_AllRecords { // set an if condition if(r_Record.Type ...; Created on 17 November 2021
11. Zoho Creator: Copy Subform to other Subforms: / Zoho /; ... // get Monday entries/rows v_EventType = r_Row.Event_Type; v_EventStart = r_Row.Start_Time; v_EventEnd = r_Row.End_Time; // // create Tuesdays ...; Created on 17 November 2021
12. 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
13. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... type: GET connection: "joels_connector" ]; info r_Templates; // // yields something like: /* { "total_count": 5, "templates": [ { "created_time": "2019-08-28T16:30:33Z", ...; Created on 21 October 2021
14. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... p_Position, int p_ProductID) { v_Output = ""; m_Header = Map(); m_Header.put("Content-Type","application/json"); // // your shopify details v_ClientID = ""; v_ClientSecret = ""; v_ShopID ...; Created on 17 October 2021
15. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... Map datatype. How? I'm not going to go into detail on how I create an access token to query the eBay Trading API as you can read this in my article: Joellipman: Zoho Creator: Push to eBay Listings. ...; Created on 13 October 2021
16. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... It then outputs a JSON list as a response and the total record count: void API.fn_ShopifyQuery_GetActiveProducts() { m_Header = Map(); m_Header.put("Content-Type","application/json"); // // ...; Created on 12 October 2021
17. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... = invokeUrl [ url :"https://www.zohoapis.eu/crm/v2/coql" type :POST parameters: m_Params.toString() connection: "joels_coql_connection" ]; // // output info r_Coql; But ...; Created on 08 October 2021
18. Zoho CRM: Upload a Product Photo using Deluge: / Zoho /; ... TLD) v_Endpoint1 = "https://creatorapp.zoho.com" + v_CreatorPhotoUrl; r_CreatorPhoto = invokeUrl [ url: v_Endpoint1 type: GET connection: "joels_creator" ]; info r_CreatorPhoto; // // ...; Created on 27 September 2021
19. Zoho CRM & Zoho Books: Get Books Currency and Tax IDs: / Zoho /; ... + v_BooksOrgID type :GET connection:"joel_books" ]; for each r_Currency in r_Currencies.get("currencies") { m_Currencies.put(r_Currency.get("currency_code"),r_Currency.get("currency_id")); } info ...; Created on 24 September 2021
20. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... url: v_Endpoint type: PUT parameters: m_ShippingAddress.toString() connection: "joels_connector" ]; info r_UpdateSO; } } Source(s): Zoho Community ...; Created on 22 September 2021