Search - Joel Lipman .Com

1. 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
2. Drop If Object Exists: / Transact-SQL /; ... of this page. Go go go Note that in the following examples, I'm checking under the [Common] schema, this might be [dbo] for you or a more specific one. -- drop a stored procedure if it exists IF ...; Created on 03 August 2012
3. Zoho Creator: Input Color Picker: / Zoho /; ... on blank form, if loading an existing record, the value stored will be used. v_DefaultColor = if(isBlank(input.Hexadecimal), "#000000", input.Hexadecimal); // // a color palette l_ColorPalette = List(); l_ColorPalette.add(); l_ColorPalette.add(); l_ColorPalette.add(); l_ColorPalette.add(); l_ColorPalette.add(); l_ColorPalette.add(); l_ColorPalette.add(); l_ColorPalette.add(); // // ...; Created on 14 October 2024
4. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... a timestamped duplicate if exists so need to check if it exists first) // https://workdrive.zoho.com/home//teams//ws//folders/files m_SubfolderNames = Map(); r_Subfolders = invokeurl [ url :"https://www.zohoapis.com/workdrive/api/v1/teamfolders//folders?page%5Blimit%5D=50&page%5Boffset%5D=0" type ...; Created on 11 September 2024
5. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... 1: Credit Application: Template exists in ZohoSign Very quickly, let's go over the implementation plan for this scenario (where you have the template in ZohoSign with fields for the end user to complete): Add ...; Created on 06 August 2024
6. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... from the item record, if a pricebook is specified and the item exists within it, then it takes the rate from the pricelist. Note that when I refer to pricebook, this is also referred to as the pricelist... ...; Created on 23 May 2024
7. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... API to detect what webhooks exist, it can only detect what webhooks it initialized. If you added webhooks via another app or via the Shopify Admin interface, then the following code won't be able to check ...; Created on 22 April 2024
8. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... list to our existing list l_AllProducts.addAll(l_ThisList); // // stop the loop if there weren't any more products if(l_ThisList.size() < 1) { break; } // // increment page v_Page = ...; Created on 15 April 2024
9. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... on filename changes, I run this bit of code to get the internal and current file name: // // get original document file (optional) - you need your own record ID here v_ZC_DocumentRecordID = 1234567890123456789; c_ExistingDocument ...; Created on 25 March 2024
10. Zoho CRM: Client Script Confirmation Box and Popup Mailer: / Zoho /; ... to email from CRM with a rich-text interface. Why? The use-case here is non-existent. It's more of a play around to see what can be achieved and how much this can be customized. The task I've set ...; Created on 06 February 2024
11. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... the fault/description, and a subform to a form called "Documents" linked by a bi-directional ticket lookup. The document form is a subform derived from an existing form (called "Document"). Mainly, because ...; Created on 26 January 2024
12. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... if updates exist then update the users module with these new signatures if(l_UserUpdates.size() > 0) { m_Params = Map(); m_Params.put("users",l_UserUpdates); r_UserUpdates = invokeurl [ ur ...; Created on 05 December 2023
13. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... + p_QuoteID type :GET parameters:m_ApprovedConverted connection:"zcrm" ]; // should be checking here that data contains any rows but I'm going on the basis that this quote exists in CRM an ...; Created on 18 September 2023
14. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkit: / Zoho /; ... are steps as to what to add in the TXT record. How to add the TXT record itself will depend on your mail server or the domain registrar's website to manage your DNS: If no TXT record exists for the SPF, ...; Created on 04 May 2023
15. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... order/package slip/invoice (if not exist) Date Created: 2022-05-05 (Joel Lipman) - Initial release Date Modified: 2023-01-23 (Joel Lipman) - Revamp of code - ...; Created on 27 April 2023
16. Zoho Deluge: Get All Orders from eBay: / Zoho /; What? Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay. Why? Our use-case is a data migration from eBay to a fresh instance ...; Created on 29 March 2023
17. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; What? A super quick article on getting the business hours set in ZohoCRM. Why? When creating a booking system in ZohoCreator, I want to enter the default working shift for an employee either existing ...; Created on 28 March 2023
18. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; What? An article to resolve my frustration in being able to ONLY retrieve the first 100 products using GraphQL, so page 1 of Shopify products. Why? Our use-case is that we retrieve the 100 most ...; Created on 20 February 2023
19. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... bot Login to ZohoCliq Click on your profile picture Select "Bots & Tools" Click on "Create Bot" (or "Edit Handlers" on an existing bot) Fill in the details then edit the Handlers. For demo purposes, ...; Created on 13 February 2023
20. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... + v_CandidateZohoID + r_Data.get("id") + ")"; l_CheckExists = invokeurl [ url :v_SearchEndpoint type :GET connection:"my_connection" ]; v_CountExists = 0; if(!isnull(l_CheckExists.get("data"))) { for ...; Created on 08 February 2023