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 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. 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
17. 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
18. 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
19. Zoho Books: System Values Maps: / Zoho /; ... statements, I can feed these maps a textual value and it returns the ID to use. Some of these can be found elsewhere in my site but I'm putting all of them here just for quick reference. How? Note ...; Created on 07 November 2023
20. 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