Search - Joel Lipman .Com

1. No rows returned in Oracle causes SP to fail: / Oracle PL/SQL /; ... one of my reports uses a row counter to display a "No data found" message when no rows are returned. This does not affect the above problem as the stored procedure simply fails and discontinues processing ...; Created on 24 January 2012
2. Returned a data type that is not valid: / Transact-SQL /; ... local report processing. An error has occurred during report processing. The Group expression used in grouping 'table1_month' returned a data type that is not valid. My DataSet Query was as follows: SELECT CONCAT(MONTHNAME(t1.Date), ...; Created on 06 January 2011
3. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... double-check in case books has returned 1st page rather than filtered rows if(m_DataRow.get("SO ID") == v_SalesOrderID) { m_Details = Map(); m_Details.put("po_date",m_DataRow.get("PO Date").toDate().toString("dd-MMM-yyyy")); m_Details.put("po_ref",); m_Details.put("po_status",m_DataRow.get("P ...; Created on 09 July 2024
4. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... generates all email signatures (no criteria). You will need to change the HTML signature and use the Image Source URLs returned from the above function to generate a HTML signature, then use placeholders ...; Created on 05 December 2023
5. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... is attached to the last record of the source data File identifying number is returned from being attached File is opened in a new tab/window to trigger downloading. File is deleted from attachments ...; Created on 02 October 2023
6. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... you have sent the code to either create or update the estimate in ZohoBooks. You will need the returned estimate ID and I'm not 100% sure the attention/phone number goes along as my client didn't include ...; Created on 18 September 2023
7. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... on receipt of Order - Resolved: SO ID was not being returned when created. - Forced re-upload of photo for item on any modification Date Modified: 2023-03-20 (Joel Lipman) - Check ...; Created on 27 April 2023
8. Zoho Recruit: Rollup Number of Recruit Candidates to CRM Account: / Zoho /; ... = zoho.crm.searchRecords("Accounts","Account_Name:equals:" + v_SchoolName,1,10,m_Blank,"zcrm"); for each r_School in l_SchoolSearch { // check no search error and valid records are returned if(!isnull(r_School.get("id"))) { // ...; Created on 19 October 2022
9. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... on the ZohoSign document and searches for the relevant Deal record in CRM. Why? A client wants that when this field is entered and the document signed and returned, it attached the signed document ...; Created on 17 October 2022
10. Zoho CRM: searchRecords with sorted results: / Zoho /; ... expressions then separate each with parenthesis joined by "and" or "or". Nulls are not returned. Set the "ModuleToSearch" to the API Name of the module you want to search. Method #1: zoho.crm.searchRecords() ...; Created on 10 February 2022
11. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; What? A quick article to demonstrate code that creates a task in CRM based on the time logged against an Event/Meeting. Why? As developers, we're keep account of our time and we are currently ...; Created on 02 December 2021
12. Zoho CRM: Schedule a Call using Deluge: / Zoho /; ... and remind us that we need to phone this Lead. How? It sounds straightforward: schedule a call using the GUI then write a test function to check the JSON that is being returned for API names... ...; Created on 18 November 2021
13. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... + v_ListingPublishKey; v_ImageSrc = v_ImageSrc + "?filepath=/" + v_Filename; l_ShopifyPictures.add(v_ImageSrc); } // after I've pushed the product to Shopify and it returned to me a Product ID: if(v_ShopifyProductID ...; Created on 17 October 2021
14. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... isn't what I want because it has returned the same currency several times and thinks they're unique/distinct because the IDs of each quote record are different. Having spoken to Zoho and raised with ...; Created on 08 October 2021
15. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; What? This is an article to document how I got a client's eBay to notify the seller every time a buyer bought a fixed price item. This uses the Trading API even though I'm aiming for the Platform Notifications ...; Created on 20 September 2021
16. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... m_RelatedList; Error(s) Encountered Sorry, there was a problem processing your request.: Your returned XML is invalid Sorry, there is a tag discrepancy in the function. The related list canno ...; Created on 30 July 2021
17. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirects: / Zoho /; ... ... code to create new record r_NewRecord = insert into [ = = = ]; } Done: Additional Remember that an integration field on the interface is returned as a string ...; Created on 27 July 2021
18. Zoho CRM & Zoho Creator: Query returns some fields missing other data on the record: / Zoho /; ... Why? My use case scenario is that I was trying to build a related list in Zoho CRM with a view on to related records in Zoho Creator. For some reason, only some random fields were being returned, ...; Created on 26 July 2021
19. Zoho Deluge: Generate and Send a CSV via Email: / Zoho /; What? A super quick article to remind me how to generate and send a CSV as an attachment to an email. Why? Because I often get casually asked "oh and can you archive the data and email it to me ...; Created on 16 June 2021
20. Zoho Deluge: Convert Map to URL Parameters: / Zoho /; ... In Reverse To have the reverse effect of converting a URL into a map, I'm using the following: v_ReturnedUrl = "https://api.joellipman.com/myapi?isAuthSuccessful=true&code=my_own_code&expires_in=299"; l_ReturnedUrlParts ...; Created on 09 March 2020