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 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
11. 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
12. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; ... :v_EmailSubject message :v_EmailMessage Attachments :file:f_FileRequest ]; } else { v_OutputMessage = "No email was specified on this record. Cannot send this quote."; } return ...; Created on 18 August 2022
13. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... = r_SearchResults.get("customerpayments"); for each r_Result in l_SearchResults { if(!isnull(r_Result.get("payment_id"))) { // // invalid searches will return 200 results non-matching, ...; Created on 17 August 2022
14. ZohoCRM: ZDK Client Script to retrieve Contact Email: / Zoho /; ... return error (don't display it, just show it in the logs) log(e); //ZDK.Client.showMessage("Client Script error"); } // unfreeze the GUI ZDK.UI.freeze(false); // return false to prevent ...; Created on 20 July 2022
15. Zoho Desk: Re-enable Desktop Notifications after clicking on "Not Now: / Zoho /; ... only if you enabled notifications previously) > Reset Return to Zoho Desk and you will get the popup to enable Desktop Notification Click on “Enable” Then click on “Allow” (browser popup prompt) ...; Created on 20 July 2022
16. GoDaddy Apache cPanel: Install SSL Certificate: / cPanel /; ... for Select the Server Type and then click on "Download Zip File" button Decompress the ZIP and find the CRT file Return to your GoDaddy page and scroll down to "Web Hosting" then click ...; Created on 07 April 2022
17. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... function that can return the ebay URL of the image. Done High Level Overview Create a REST API CRM function Get Zoho CRM to create a Zoho Creator record by passing it the Inventory ID Get ...; Created on 31 March 2022
18. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... was to recover the relevant product based on any given Product SKU. Making the above into a function as well as returning the inventory item ID and the product ID: map API.fn_SearchShopifyBySKU( string ...; Created on 14 February 2022
19. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... / return response return m_Output; Click "Save" and Done! Yields: Additional Note(s): If the user's profile is blank, the rule will not apply to them. l_Disallowed = List(); l_Disallowed.add("Joel"); if(l_Disallowed.contains("")) { in ...; Created on 11 February 2022
20. 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