Search - Joel Lipman .Com

1. Zoho CRM: searchRecords with sorted results: / Zoho /; What? This is an article to document how to use the searchRecords function in CRM and to sort the results response. Why? This is unclear and not always working as coded below since each system ...; Created on 10 February 2022
2. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; What? So I've spent a fun time googling and binging but still haven't found a simple and complete example of getting a resultset from an Oracle stored procedure and displaying this in SQL Server Reporting ...; Created on 19 January 2012
3. SSRS Hide results table if empty: / SQL Server Reporting Services /; ... boy what a mouthful, and it's not really iterating anymore. So it's "SSRS Hide results table if empty" though I will add that if you wanted to put a message instead of hiding the table then following the ...; Created on 29 March 2011
4. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; ... may sound trivial, was the response when an end customer clicks on either the accept or decline button. Using ZohoFlow or other Zoho app for a webhook response, would result in the end customer suddenly ...; Created on 04 November 2024
5. Zoho Deluge: Convert Hex to RGB: / Zoho /; What? A quick article to document a Zoho Deluge function converting a hexadecimal color reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some ...; Created on 11 October 2024
6. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... CRM, then skip this if statement if(v_ZohoSign_DocumentType == "CreditApplication") { v_RequestID = ifnull(m_Body.get("requests").get("request_id"),"0").toLong(); l_SearchResults = zoho.crm.searchRecords("zohosign__ZohoSign_Documents","Request_ID:equals:" ...; Created on 06 August 2024
7. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... to have to be asked directly to Zoho rather than using the online subscription plan management section. Statement Execution Limit is 5000 The following will run resulting in the error "Number of ...; Created on 31 July 2024
8. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... by creating a table in ZohoAnalytics rather than simply writing a query and using the 'asynchronous' method to extract the query result. To create an analytics table from a query, we do the following: Login ...; Created on 09 July 2024
9. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... than 1 second m_Payload = crmAPIRequest.toMap(); m_Blank = Map(); // // you created an app that generated a client ID and a client secret and resulted in an access token // the client secret used ...; Created on 22 April 2024
10. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... here an example that demonstrates a basic search on a table of data and returns one record as a result. The use-case here is that we are enhancing a quote builder form in Zoho Creator. The JS widget ...; Created on 14 March 2024
11. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... Trigger: On Products Edit Page (Standard) > Page Event OnLoad Purpose: ZohoCRM only allows up to 6 decimals but some calculations are resulting in more than this which blocks ...; Created on 13 December 2023
12. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... = r_QuoteDetails.get("Account_Name").get("id"); r_SearchResults = zoho.books.getRecords("Contacts",v_BooksOrgID,"zcrm_account_id=" + v_AccountID,"zbooks"); if(!isnull(r_SearchResults.get("contacts"))) { // ...; Created on 18 September 2023
13. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; What? A quick article on getting the payment terms in Zoho Books along with their IDs. Why? I often need to send through an automatic payment term on the creation of an invoice but lots of my ...; Created on 06 July 2023
14. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... from eBay:"; //info x_ResponseBody; // // get pagination results from the first iteration/page if(v_Page == 1) { // // get page results x_PaginationResult = x_ResponseBody.subStrin ...; Created on 29 March 2023
15. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; What? A very quick article of a quick solution but at least a working example of an ANSI-SQL (ZohoSQL) query pivoting campaign results vs contacts. Why? Simply the client wanted a report on customers ...; Created on 20 March 2023
16. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... if you train OpenAI on a dataset, that dataset and the resulting model will not be accessible by external sources unless you choose to make it publicly available. OpenAI takes data privacy and security ...; Created on 06 March 2023
17. ZohoCRM: Get All eBay Active Listings: / Zoho /; What? Another one of these articles talking about getting all the active product listings from eBay for a specific client. Why? Our use-case scenario here is that we want to get an inventory ...; Created on 01 March 2023
18. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... to be by order of cursor alphabetically; but we were happy with the results the above code did anyway so I haven't tried this. Source(s): Shopify Dev - Paginating results with GraphQL ...; Created on 20 February 2023
19. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; What? So this is an article for me to store prompts for the MidJourney AI text-2-image discord tool. Why? The results from the MidJourney bot are beyond unpredictable however with the correct ...; Created on 11 February 2023
20. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... == "Deal_Ref") { v_DealRef = r_Field.get("field_value"); } } } } } } // // Search ZohoCRM for the Deal with that Deal Ref v_DealID = 0; if(v_DealRef != "") { l_SearchResult ...; Created on 17 October 2022