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: 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
11. 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
12. 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
13. Zoho Creator: Find Duplicates by Customer Name for Large Datasets: / Zoho /; ... v_CountDuplicates + " record" + v_Grammar + " are duplicates!"; // // return a distinct list l_Customers2.removeAll(l_Customers1); // // loop through and output to user for each v_DistinctCustomer ...; Created on 12 July 2023
14. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... in the world, the day index for a Sunday is 7 (ie. myDate.toString("u") returns 7) and the week commences on a Sunday (ie. myDate.toStartOfWeek("EEEE") returns Sunday). In other words, the day counting ...; Created on 06 July 2023
15. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; ... clients set their due dates differently. How? The following snippet of code will query the metadata api in Zoho Books and return a JSON of what the payment terms are. void fn_ReturnCurrentPaymentTerms() { v_BooksOrgID ...; Created on 06 July 2023
16. Zoho CRM: Change System Field Length: / Zoho /; ... file to change system field labels The fix put simply is a CSS hack. Specifically by inspecting the element, removing some of the CSS attributes on the field we want to change, saving it, then returning ...; Created on 19 June 2023
17. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkit: / Zoho /; ... cases, a working example can return within the hour as authenticated. Use the following link to continue monitoring for when this has taken effect: https://zohomail.tools/#runChecks Source(s): ZohoCRM: ...; Created on 04 May 2023
18. 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
19. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... 1000 ]) // the actual number may be less than this but this is for pagination estimates v_MaximumOrders = 10000; v_Year = 2022; // // set the filter for orders by status to return: All, Active, Cancelled, ...; Created on 29 March 2023
20. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... The deluge function So this function will return the word "delivered" or whatever other statuses there are for a package: /* Function: String fn_DHL_CheckShipmentStatus(string p_TrackingNumber) ...; Created on 21 March 2023