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 /; What? A super quick article to demonstrate how an idiot like myself can misread the documentation. This particular article shows you how to customize the search results or response from using zoho.creator.getRecordById(). ...; Created on 26 July 2021
3. 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
4. $_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
5. Zoho CRM: searchRecords with sorted results: / Zoho /; ... r_SearchResults { // check there is a record id (as error also returns result) if(!isnull(r_Result.get("id"))) { v_AccountID = r_Result.get("id"); m_UpdateAccount = Map(); m_UpdateAccount.put("Processed_by_Function", ...; Created on 10 February 2022
6. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng): / Zoho /; What? An article with a quick snippet of code which builds up the address from a Lead record to geocode into latitude and longitude coordinates to feed a third-party API which returns a timezone. ...; Created on 15 December 2021
7. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... My use-case scenario here is that while I could upload the link from Creator to eBay's Picture Services successfully, Shopify would not accept any links I gave it. Why not use the links that eBay returns? ...; Created on 17 October 2021
8. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... a list of all the listed active products in a fixed price item listing. The example below is a function which, if given the page number and the number of entries per page, returns these in JSON as a Zoho ...; Created on 13 October 2021
9. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... delimited by a comma. However, to match my use-case, I want a list to which I can give it an SKU, and it returns the Shopify Product ID (not of the variant but of the product). In which case, I need ...; Created on 12 October 2021
10. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... this returns something like the following (I've reduced the 200 records to about 6 of them): { "data": [ { "Currency": "EUR", "id": "123456789000000001" }, { "Currency": ...; Created on 08 October 2021
11. ZohoCRM: Deluge: Map a custom field from user profile: / Zoho /; ... Opportunity/Deal/Potential record details, then get the Owner frrom the CRM users table, find the value of the custom field and search for this (if it is a lookup to a module - only returns as string), ...; Created on 01 September 2021
12. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; What? This is an article to demonstrate how to handle commas in a CSV file that were enclosed between two double-quotes. I've added to this the handling of new lines or carriage returns in between a ...; Created on 26 August 2021
13. Zoho Creator: Assign an integration field value with an integration value: / Zoho /; ... How? It is written in the documentation albeit difficult to find: an integration field returns an ID as a string. If you want to assign it to an integration field, you have to convert it to a number ...; Created on 27 July 2021
14. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... key it returns you. eg. https://creatorapp.zohopublic.eu + zoho.appuri + report-perma/Download_File_Report/abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKL ...; Created on 02 February 2021
15. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... Created: 2020-10-27 (Joel Lipman) - Initial release - Workflow to calculate 80% dept workforce - Returns response as popup - Cancels submit with ...; Created on 10 December 2020
16. AutoHotkey: Get Media Information and Display: / AutoHotkey /; ... ) MsgBox % a_MediaObject["System.Media.Duration"] // note this returns in 100ns units (= 100 nanoseconds) as per Microsoft Docs. 100ns Units So the following snippet of code will convert your ...; Created on 07 August 2020
17. Zoho Deluge: Duplicate/Clone a Record: / Zoho /; ... for "Invoices": /* Function: fn_Button_CloneInvoice Purpose: This function duplicates a CRM invoice Parameters: p_InvoiceID (CRM ID of the invoice) Returns: Nothing Author: Joel Lipman Date Created: ...; Created on 17 March 2020
18. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; ... exists because it is searching with case-sensitivity enabled. It tries to insert into the product table, but returns the error "Result: Error on Execution" > "Error details: Execution Failed Due to invalid ...; Created on 21 November 2019
19. Zoho Deluge - Get distance between two coordinates: / Zoho /; ... from the JavaScript library figuring if it supports cos() then try this standard function. Note this has only been tested in Zoho Creator rather than Zoho CRM. How? This function returns the distance ...; Created on 11 June 2019
20. Zoho Deluge - Get User Timezone, Country and Location: / Zoho /; ... v_Url ); Returns something like: { "ipAddress": "147.188.254.175", "continentCode": "EU", "continentName": "Europe", "countryCode": "GB", "countryName": "United Kingdom", ...; Created on 03 June 2019