Search - Joel Lipman .Com

1. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... layout didn't work Choose field to validate > Select "Lead Status" Choose validation type as "Validate using function" and click on "Next" For functions, select "Write your own" Give it a function name, ...; Created on 11 February 2022
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. ZohoBooks: Code 15 Ensure Billing Address has less than 100 characters: / Zoho /; ... will fail... Why? I have a function to push a ZohoCRM quote to a ZohoBooks estimate and a client asked that the address on the CRM record 'pulls through'. Sending the address in the same request ...; Created on 18 September 2023
11. Zoho Creator: Sendmail a list of attachments: / Zoho /; ... to me that perhaps this isn't clearly documented. But there are tips found across the web just not specifically addressing this. How? Here is the code for a test function which downloads 2 files ...; Created on 20 July 2023
12. Zoho Creator: Find Duplicates by Customer Name for Large Datasets: / Zoho /; ... and if the function is changed to remove every instance of the "distinct" list, then I'll have to come up with a different solution. Maybe Zoho could introduce a removeFirst() if they change removeAll().. ...; Created on 12 July 2023
13. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... (this is in ZohoCreator; I'm aware that some of Zoho Apps do allow this) in the app which would possibly affect the functionality of .toStartOfWeek(). v_ThisWeek = if(c_Order.Order_Date.toStartOfWeek() ...; Created on 06 July 2023
14. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; ... "payment_terms": -3, "payment_terms_label": "Due end of next month" } ] } } Usage: This is just a snippet of usage and obviously not the whole function to generat ...; Created on 06 July 2023
15. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... the method of "mega-functions", here is the code snippet for one function which will accept as parameter the eBay order reference and generate all the respective records in Zoho Inventory. We're using a ...; Created on 27 April 2023
16. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... article link above), we're going to use the GetOrders call for order (sales) management. /* Function: fn_GetEbayOrders() Purpose: Queries eBay for all orders for a specified year ...; Created on 29 March 2023
17. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... c_Employee.Usual_Shift.insert(c_UsualShift); info "-------------"; } Yields something like: Error(s) Encountered Value is empty and '1234567000001234567' function cannot be applied: ...; Created on 28 March 2023
18. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; What? A quick note here on how to connect to the DHL API and check on a package given a tracking number. Why? In our megafunction to generate a customer, a product/item, a sales order, an invoice, ...; Created on 21 March 2023
19. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... click on "Done" Now click on "Edit Function" under "Context Handler Function" We're going to use the following deluge code for our first pass at this awesome functionality: // / ...; Created on 06 March 2023
20. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... So we're going to use a ZohoCRM function to get this file which we can run on demand. Why not in Zoho Inventory or any other Zoho app? Because we like to challenge ourselves... Once again, I'm not ...; Created on 01 March 2023