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. 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
11. 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
12. 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
13. 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
14. 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
15. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... function too often either for debugging/monitoring purposes but it's easier to use an access token then getting the OAuth access codes from the client. How? I'm going to split this into 2 code snippets ...; Created on 28 February 2023
16. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... } } } The Deluge Code So this is a Zoho Creator function that I'm going to call API.fn_ShopifyQuery_UpdateAllProducts() and it will be added to a nightly schedule. It's aim is to recover all ...; Created on 20 February 2023
17. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... this one "jl_recruit". The Deluge code for workflow /* ******************************************************************************* Function: void fn_AB_AssociateVacancy2Candidate(int ...; Created on 08 February 2023
18. ZohoCRM: Import Attachments: / Zoho /; ... FUNCTIONS fn_Slugify(v_Ugly) { StringLower, v_Ugly, v_Ugly v_Ugly := RegExReplace(v_Ugly, "/\s+/g", "_") v_Ugly := RegExReplace(v_Ugly, "/[^\w\_]+/g", "") v_Ugly := RegExReplace(v_Ugly, "/\_\_+/g", ...; Created on 16 January 2023
19. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; What? This is an article describing a custom function built into Zoho Flow that will accept as parameter the document_id and request_id. It then retrieves the Deal Reference (entered by an office signee) ...; Created on 17 October 2022
20. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... and payment date to appear on the invoice. How? This sounds rather straightforward, write a function that given an invoice, checks the customer payments and updates the custom fields. Executing ...; Created on 17 August 2022