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 CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... from within ZohoCRM ZohoCRM webhook updates the tracking record (ZohoSign Document) and attaches the signed document to the contact record Button Code: /* ******************************************************************************* Function: ...; Created on 06 August 2024
11. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... So create a function in the Zoho App you are checking, or somewhere you can write some Zoho Deluge code. Note that requesting an increase of the limit or an upgrade to the subscription will likely ...; Created on 31 July 2024
12. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... purchase order items by the custom lookup field. What follows is the code required to build the custom related list in ZohoBooks: /* ******************************************************************************* Function: ...; Created on 09 July 2024
13. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... you setup a Connection that does NOT use the credentials of the logged-in user and has as scope ZohoAnalytics.metadata.read. The code /* ******************************************************************************* Function: ...; Created on 02 July 2024
14. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... and vice-versa. And in this use-case, my client has added an incredible number of price books/ price lists and then has in excess of 20k items. Previously, the function that would need to get the ...; Created on 23 May 2024
15. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... our friend. How? So we'll run a workflow that triggers on the creation of a lead and runs a function which will simultaneously create a task with a reminder both on popup and email which repeats ...; Created on 14 May 2024
16. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; What? There are already articles out there that document this but I use this more and more and would rather just find it on my site than going through multiple bookmarks. Why? This use-case is ...; Created on 07 May 2024
17. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; What? This is an article to show how to setup a scheduled function that checks and restores a missing webhook as well as the snippets when receiving the webhooks and storing them. Why? We found ...; Created on 22 April 2024
18. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; What? This is a quick article on generating a file with the Zoho Deluge function .toFile() and uploading it to a file upload field within Zoho Creator. Why? The use-case here is that we want a ...; Created on 25 March 2024
19. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... the JavaScript These are the contents of main.js and is working at time of print: // Start with Zoho SDK stuff ZOHO.CREATOR.init() .then(function(data) { // Initialize ...; Created on 14 March 2024
20. Zoho Books: Error 7008: There are no contact persons associated with this Invoice: / Zoho /; ... you can lock it down to just the scopes you need. void ZohoBooks.fn_SendZohoBooksInvoice(int p_OrderID) { v_OrderID = ifnull(input.p_OrderID,0).toLong(); /* ******************************************************************************* Function: ...; Created on 07 March 2024