Search - Joel Lipman .Com

1. Zoho Deluge - MD5 function: / Zoho /; What? So this is NOT an article on how to create a MD5 function for an ETag in Zoho Deluge as I expected it would be. At time of print, the Zoho documentation (and Google search results) make no mention ...; Created on 19 November 2018
2. Android: Function to let user take photo or choose existing: / AndroidOS /; What? A quick article on a function to allow the user to take a photo using their built-in camera or to choose an existing photo from their gallery. Why? I wanted both options to be available ...; Created on 04 November 2014
3. T-SQL functions to convert Strings to Tables: / Transact-SQL /; ... start with a function that just converts a string of words delimited by spaces to a table: CREATE FUNCTION dbo.[ufn_StringToTable] ( @StringInput VARCHAR(MAX) ) RETURNS @OutputTable TABL ...; Created on 20 August 2014
4. Call to a member function mark() on a non-object in Joomla CMS: / Joomla /; What? This is a quick note on one reason you may get the above error in a Joomla CMS environment. Call to a member function mark() on a non-object in /public_html/index.php How? Not really ...; Created on 17 November 2013
5. Data Randomization Function in Oracle PL/SQL: / Oracle PL/SQL /; What? This article describes a function that will return random data based on a given value. The function intends to determine the data type and return data that is absolutely irrelevant to the original ...; Created on 22 August 2012
6. Basic Oracle Function Structure: / Oracle PL/SQL /; What? I need to refer to how to create a function in Oracle PL/SQL and sites on the net just attempt to overcomplicate everything and have forgotten how it is to be new to Oracle. I need a function ...; Created on 15 January 2012
7. Functions to convert Hex 2 RGB and vice-versa: / AutoHotkey /; These are for autohotkey and in AHK code. Taken from Autohotkey forums topic 1878: From Hexadecimal to RGB From RGB to Hexadecimal Check for a valid hexadecimal value From Hexadecimal ...; Created on 27 September 2011
8. Could not instantiate mail function: / Joomla /; Quick Fix Check that this error isn't resolved by just changing the Mailer (Joomla > Global Configuration > Mailer settings). Alternate between PHPmail and sendmail just to check this isn't the problem. ...; Created on 09 May 2011
9. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... "variant_ids": [], "admin_graphql_api_id": "gid://shopify/ProductImage/23456789012345" } } This next version is a more generic form of the above function uploading the photo to Shopify: void ...; Created on 17 October 2021
10. 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
11. Zoho Creator / Shopify: 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 Shopify. Why? The use-case was that I wanted to search ...; Created on 12 October 2021
12. Zoho CRM & Zoho Books: Get Books Currency and Tax IDs: / Zoho /; ... them once, store them as a map on your function if you don't want to use up these 2 every time your sales team push a CRM Sales Order to Zoho Books. Or leave as 2 calls at the beginning of your function ...; Created on 24 September 2021
13. Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestamps: / Zoho /; ... Deluge. How? We're going to make use of the .toLong() function applied to a datetime datatype variable which will return the Unix seconds. // the now time v_NowTime = zoho.currenttime; // // ...; Created on 21 September 2021
14. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... every time we want to tweak the code. There are also cases we don't want to use a standalone function as we want the code to read from the input fields dynamically and in real-time. To this end, I create ...; Created on 19 September 2021
15. Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd): / Zoho /; ... Additional You would of course need to check that there is nothing wrong with the date that was submitted. Especially if it is coming from a data source, the Zoho deluge .toList() fails the function ...; Created on 01 September 2021
16. Zoho CRM & Zoho Books: Get SalesPersons: / Zoho /; ... to assign the sales person. How? So after an hour or so trying to get the Zoho.books.getRecords() function to filter the sales persons, I gave up and used a for each loop instead. In the next ...; Created on 30 August 2021
17. ZohoCRM: Process all records of a module: / Zoho /; ... you have a few hundred records, or a few hundred thousand records, we sometimes want to write a function that will check each record and mark it so that the process doesn't repeat on records that have already ...; Created on 24 August 2021
18. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... m_RelatedList; Error(s) Encountered Sorry, there was a problem processing your request.: Your returned XML is invalid Sorry, there is a tag discrepancy in the function. The related list canno ...; Created on 30 July 2021
19. ZohoCRM: zoho.crm.searchRecords only returns certain records: / Zoho /; ... searchRecords function requiring it's 5th parameter which defaults to "not converted" records: =zoho.crm.searchRecords(,,,,,); The solution: The long answer/investigation is getting a JSON response ...; Created on 29 July 2021
20. Zoho Deluge: Zoho Bookings Get Available Slots: / Zoho /; ... to allow customers to make a booking based on the configuration and appointments in a ZohoBookings instance. How? The getAvailableSlots function requires as parameters according to documentation ...; Created on 23 June 2021