Search - Joel Lipman .Com

1. ZohoCRM: zoho.crm.searchRecords only returns certain records: / Zoho /; What? This is an article to hopefully resolve for you quicker than it took me, why a zoho.crm.searchRecords() returns some of the records but omits others. Why? The use-case was that we were creating ...; Created on 29 July 2021
2. 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
3. Android: Replace return key with done, go, send...: / AndroidOS /; What? A quick article on how to replace the return key on a soft keyboard (software based) on a touch-device. Why? I have an editText where a user can enter any text value but if they typed a ...; Created on 03 November 2014
4. Include a carriage return in a column heading: / SQL Server /; Applies To: MS SQL Server 2008 R2 MS Windows 7 Enterprise (Client) MS Excel 2010 What? A really quick note on how to insert a carriage return or new line into the column name/alias (the header). ...; Created on 07 July 2014
5. No rows returned in Oracle causes SP to fail: / Oracle PL/SQL /; Why? We have a stored procedure which contains two select queries. The first query will retrieve a student ID number where the input parameter is the student's username. The second query will return ...; Created on 24 January 2012
6. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... OR REPLACE PROCEDURE sp_get_studentdetails_from_ad ( p_STUDENT_ADNAME IN varchar2, l_CURSOR OUT sys_refcursor ) IS BEGIN -- going to declare variables that are to be returned in SSRS ...; Created on 19 January 2012
7. 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
8. Clicking on a weblink returns a 404 error: / Joomla /; If you are in the administration panel and you are editing your weblinks and you come across this error: "404 - An error has occurred. Joomla! was unable to locate the stated resource." ...; Created on 06 November 2009
9. $_SERVER['http_referer'] returns blank in Internet Explore: / Microsoft /; Thought I'd put a note about this as I spent ages rewriting an entire system. The HTTP_REFERER environment variable can be changed by the user anyway but I was using it as an additional validation check. ...; Created on 19 October 2009
10. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; ... // // could put a 403 but it's if there was an invalid request. Here we're not really responding with anything m_Response = Map(); m_Response.put("status_code",200); } // // return webhoo ...; Created on 04 November 2024
11. Zoho Deluge: Convert Hex to RGB: / Zoho /; ... point as an input but at the time of print, this hasn't happened yet. Here's a function in deluge that takes a 3 or 6 character hexadecimal color and returns the RGB values for you. How? Very quickly, ...; Created on 11 October 2024
12. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... and send it off for signing, then return the Signed document attached to the initial record (where the button was). Why? If anyone has the envious task of sending a document out for signing by a ...; Created on 06 August 2024
13. Zoho Projects: Get All Events: / Zoho /; ... are events in the past; status is a mandatory field // NB: range is an integer and the number of records to return (default=100; max=200) // NB: index is an integer and is the offset or starting index ...; Created on 22 July 2024
14. 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
15. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... tests show this only returns the 1 relevant item from a pricebook of many more items l_PriceBookItems = ifnull(r_ThisPriceBook.get("items"),{}); for each m_PriceBookItem in l_PriceBookItems ...; Created on 23 May 2024
16. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... compare our hash vs the received hash if(v_VerifyHash == v_ShopifyHash) { m_ResponseHeader.put("status_code",200); } // // respond return ; The Code Snippets: The Shopify Inventory Level Updat ...; Created on 22 April 2024
17. 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
18. Zoho CRM: Client Script Confirmation Box and Popup Mailer: / Zoho /; ... returns both first and last) var v_ContactName = ZDK.Page.getField('Last_Name').getValue(); // get the email of this contact var v_ContactEmail = ZDK.Page.getField('Email').getValue(); ...; Created on 06 February 2024
19. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... module that are calculated and will sometimes return numbers with more than 6 decimal places. As this is more than specified on the ZohoCRM field properties, as soon as the staff user tries to save the ...; Created on 13 December 2023
20. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... an image to workdrive and returns a publicly-accessible link/URL for use in your email signatures. Inputs: Loginuser Outputs: Email Scope(s): WorkDrive.team.ALL, WorkDrive.workspace.ALL, ...; Created on 05 December 2023