Search - Joel Lipman .Com

1. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... added row in that subform (on user input). This sets the document name for display later: if(!isnull(row.Document_File)) { v_FileDetected = row.Document_File; if(v_FileDetected.contains("_")) { v_SubstringStart ...; Created on 11 March 2022
2. Zoho Creator: eBay: Get Item Transaction: / Zoho /; What? This is the function to get the line item order/transaction from eBay if you give it the eBay Item ID as a parameter. Why? Mostly for debugging but here's the code that will quickly get ...; Created on 22 January 2022
3. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
4. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; ... = "(+01:00) Europe/Luxembourg"; v_CustomerOffset = "+01:00"; // // calculate GMT v_CustomerPlusMinus = v_CustomerOffset.subString(0,1); v_CustomerHours = v_CustomerOffset.subString(1,3).toLong(); v_CustomerMinutes ...; Created on 07 December 2021
5. 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
6. Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time field: / Zoho /; ... timezone, add 10 minutes, re-assemble it in a format that CRM likes, and update the field: // // parse date into yyyy-MM-dd (using subString - reliable) v_LeadCreatedDate = r_LeadDetails.get("Created_Time").subString(0,4) ...; Created on 11 November 2021
7. Zoho Creator / eBay: Get all Active Products: / Zoho /; What? This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's eBay store. Why? The use-case was that I wanted to retrieve ...; Created on 13 October 2021
8. Zoho Deluge: Push a value to a datetime field in CRM: / Zoho /; ... some formatting examples: Creator to CRM: v_CreatorTime = zoho.currenttime.toTime(); v_CrmTime = v_CreatorTime.toString("yyyy-MM-dd'T'HH:mm:ss") + v_CreatorTime.toString("Z").subString(0,3) + ":" ...; Created on 10 September 2021
9. Zoho Deluge: Sort a Map by a specific field: / Zoho /; ... date format), arrange so it can be sorted alphabetically in reverse order v_DatePart = v_SortingKey.getPrefix("T").toDate().toString("yyyy-MM-dd"); v_TimePart = v_SortingKey.getSuffix("T").getPrefix("+").subString(0,5); v_SqlDateTime ...; Created on 29 January 2021
10. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date String: / Zoho /; ... = v_XeroTime.indexOf("(")+1; v_EndIndex = v_XeroTime.indexOf("+", v_StartIndex); v_UnixSeconds = v_XeroTime.subString(v_StartIndex, v_EndIndex); info v_UnixSeconds.toLong().toTime(); // yields 15-Apr-2020 ...; Created on 04 May 2020
11. MySQL: Count occurrences of words in a column: / MySQL /; ... as `total`, `value` FROM ( SELECT count(*) AS `total_count`, REPLACE(REPLACE(REPLACE(x.`value`,'?',''),'.',''),'!','') as `value` FROM ( SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(ExtractValue(t.`introtext`, ...; Created on 12 March 2020
12. Zoho Deluge: Convert Map to URL Parameters: / Zoho /; ... = v_ReturnedUrl.subString(v_ReturnedUrl.indexOf("?")+1).toList("&"); m_UrlParams = Map(); for each r_Part in l_ReturnedUrlParts { if(r_Part.contains("=")) { l_ParamParts = r_Part.toList("="); m_UrlParams.put(l_ParamParts.get(0), ...; Created on 09 March 2020
13. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... v_TimeZone = zoho.currentdate.toString("Z"); v_TimeZoneStr = v_TimeZone.substring(0,3) + ":" + v_TimeZone.substring(3); v_InsertDateTime = zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ss") + v_TimeZoneStr; // ...; Created on 06 February 2020
14. Zoho Deluge - Compare time and currenttime with timezone: / Zoho /; ... HH:mm:ss"); v_ExpiryTime = "2020-03-25T21:41:07+00:00"; v_ExpiryDatePart = v_ExpiryTime.subString(0,10); v_ExpiryTimePart = v_ExpiryTime.subString(11,19); v_ExpiryTimeCheck = v_ExpiryDatePart + " " ...; Created on 13 January 2020
15. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; ... return v_Output; } This is my preferred method and it will return a string of 5 random uppercase letters. Method #2: Convert time to letters I've previously used substring to extract the ...; Created on 09 May 2019
16. Zoho Deluge: Loop through 30 Minute Slots: / Zoho /; What? This code snippet took me a while to do and the documentation is flaky so I thought I'd make a note here just in case I need to refer to it again. Why? I want to modify a picklist and fill ...; Created on 30 November 2018
17. Zoho Deluge - Get English Ordinal: / Zoho /; ... 2, 3, ... 29, 30, 31) This_Day_Date = My_Date_Field.toString("d"); // determine English Ordinal Ordinals = "th,st,nd,rd".toList(); English_Ordinal = Ordinals.get(0); EO_Index = This_Day_Date.substring(This_Day_Date.length() ...; Created on 08 November 2018
18. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... AND t1.`extension`='com_content' AND t2.`extension`='com_content' SET c1.`catid`=t1.`id`; -- Joe-Code: LIST Rows to be affected (for test purposes) -- SELECT SUBSTRING(a.`name`, 1, INSTR(a.`name`, ...; Created on 12 September 2015
19. Android Java: Remove first two entries from Google News feed in SimpleRssReader: / AndroidOS /; ... } holder.newsItemTitle.setText(items.get(position).getTitle()); holder.newsItemDateD.setText(items.get(position).getDate().substring(5, 7)); holder.newsItemDateM.setText(items.get(position).getDate().substring(8, ...; Created on 24 October 2014
20. T-SQL functions to convert Strings to Tables: / Transact-SQL /; ... ', @StringInput) - 1, -1), LEN(@StringInput))) SET @StringInput = SUBSTRING(@StringInput, ISNULL(NULLIF(CHARINDEX(' ', @StringInput), ...; Created on 20 August 2014