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 Creator: Two submit buttons on a non-stateless form with 2 different redirects: / Zoho /; What? This is an article to document how to have two submit buttons on a non-stateless form which both submit the form but one leaves the current record open while the other redirects to the reports ...; Created on 27 July 2021
9. Zoho Projects: Deluge to Submit Custom Fields: / Zoho /; ... "duration_type": "hrs", "start_date": "11-12-2021", "end_date": "12-12-2021", "percent_complete": "0", "order_sequence": "4", "priority": "None", "custom_fields": m_Custom.toString() }; r_CreateResponse ...; Created on 17 June 2021
10. Zoho CRM REST API: Stop Workflow from Triggering: / Zoho /; ... = invokeurl [ url :v_Url type :PUT parameters:m_Data.toString() connection:"ascentbusiness" ]; or l_Quotes = List(); l_Quotes.add(m_CreateCrmQuote); m_Data = Map(); m_Data.put("data",l_Quotes); m_Data.put("trigger",[]); v_Url ...; Created on 16 June 2021
11. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... This is a simple article to demonstrate how to type special characters not found on your keyboard or on a Qwerty UK/US keyboard layout. Why? Being able to type international characters from other ...; Created on 03 June 2021
12. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... list to stop or prevent these from triggering. m_Data.put("triggers",[]); // // send via REST API v2.1 on EU datacenter r_CreateCrmQuote = invokeurl [ url :"https://www.zohoapis.eu/crm/v2.1/Quotes" type ...; Created on 17 May 2021
13. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... Billable"); v_WorkNotes = ifnull(input.Work_Notes,""); v_TaskOrIssue = if(input.Type == "Task", "tasks", "bugs"); // // eval v_HoursDecimal = (v_EndTime.toLong() - v_StartTime.toLong()) / 1000 / 60 ...; Created on 30 April 2021
14. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Deluge: / Zoho /; ... a standalone function called "Test". Type in line 1: r_Record = zoho.crm.getRecords then press Enter (DO NOT START TYPING FOR A MODULE NAME - LET THE SYSTEM POPUP YOUR OPTIONS AS PER THE FOLLOWING SCREENSHOT ...; Created on 28 April 2021
15. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API: / Zoho /; ... 's Awesome Life"); m_NestedRequest.put("data[item_price]","priceless"); r_PostResponse = invokeurl [ url :"https://api.joellipman.com/my_test_api.php" type :POST parameters:m_NestedRequest ]; ...; Created on 03 February 2021
16. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... = Map(); m_SearchCriteria.put("searchField","Leavetype"); m_SearchCriteria.put("searchOperator","Contains"); m_SearchCriteria.put("searchText","Leave"); l_SearchCriterias.add(m_SearchCriteria); l_AllTimeOffs ...; Created on 10 December 2020
17. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... when I create a workflow, it will ask me to run a function, the Creator workflow process will then read what datatype of a parameter I'm sending to the function. So in "Edit this application" > go to ...; Created on 06 December 2020
18. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... Type = CNAME CNAME = creator.cs.zohohost.com or creator.cs.zohohost.eu depending on the value obtained step 1c above. Add another CNAME record with the following: name as .myparentdomain.com ...; Created on 17 November 2020
19. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... to trash/bin. Open the terminal app on your Mac and type the following to test the install: node –v npm –v You should get a version number for each of these as a response. Failing this you should ...; Created on 24 October 2020
20. Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Div: / Zoho /; What? So this is an article documenting how to create an on/off toggle switch that hides and displays between 2 div layers in a Zoho Creator Page (so not a form or report but a page). Why? This ...; Created on 22 October 2020