Search - Joel Lipman .Com

1. Getting the mysql where in delimited string to work: / MySQL /; What? I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", ...; Created on 02 January 2012
2. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... to run (this would initially attach the file to the CRM record). This wasn't working really as there are issues around tweaking the function and getting it to understand basic mapping and attachments. ...; Created on 21 October 2021
3. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... articles on handling images in Zoho Creator (see "Sources" below), the most relevant one being my article Zoho Deluge: Get Image Uploaded in Creator Form which has one method of getting a public link. ...; Created on 17 October 2021
4. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... = ifnull(r_ShopifyProduct.get("variants").get(0).get("sku"), "UNKNOWN"); m_Sku_IDs.put(v_ProductSKU, r_ShopifyProduct.get("id")); // // getting the last ID from the Shopify sort instead of making ...; Created on 12 October 2021
5. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... stuff here ... eg getting data fields, generating a title and setting the title: input.Title = "Hello World "; // // output input.Note_Preview = input.Title; // // re-enable auto-update preview input.Update_Preview=true; To ...; Created on 19 September 2021
6. Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd): / Zoho /; ... If we are getting a date from a CSV or other external source as "dd/MM/yyyy", how do we guarantee that the system will understand the date correctly? How? It may be that when obtaining a date string ...; Created on 01 September 2021
7. Zoho CRM & Zoho Books: Get SalesPersons: / Zoho /; ... snippet of code, I am getting the Zoho CRM record owner, looping through all salespersons in Zoho Books, and retrieving the salesperson_id. Also I have a connector to ZohoBooks called "joel_books". The ...; Created on 30 August 2021
8. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; What? This is an article to quickly demo a couple of snippets of code to display values in a custom related list as well as to display empty custom related lists. Why? Because I keep forgetting ...; Created on 30 July 2021
9. ZohoCRM: zoho.crm.searchRecords only returns certain records: / Zoho /; ... searchRecords function requiring it's 5th parameter which defaults to "not converted" records: =zoho.crm.searchRecords(,,,,,); The solution: The long answer/investigation is getting a JSON response ...; Created on 29 July 2021
10. Zoho Deluge: Zoho Bookings Get Available Slots: / Zoho /; What? This is an article of code snippets to query a Zoho Bookings instance from within Creator. This one focuses on getting the available slots. Why? This is for a Creator app which had a form ...; Created on 23 June 2021
11. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... to when trying to enter a time against a project Task but this article is focused on getting this working against Project Issues. Also note, we will refer to Project Issues in this article, but in the ...; Created on 30 April 2021
12. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... article because I keep forgetting on how to do this. I have a specific order of steps on how I do this, you may find other ways but this is one that works for me. How? So here's an overview and then ...; Created on 06 December 2020
13. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... the domain joellipman.com. Why? This took me a bit of going backwards and forwards to Zoho rather than getting my client to do this. The aim is to take up as little time as possible of the third-parties ...; Created on 17 November 2020
14. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; What? This is an article documenting how to create a Zoho Creator Widget which includes the Bootstrap and jQuery frameworks as well as other JavaScript functionality. Why? Quite simply that at ...; Created on 24 October 2020
15. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... certain bits out. Just getting the syntax right and using the . setParamName is key. Let's make it even more interesting: I'm going to use a subform with the file upload field type so our record can ...; Created on 15 May 2020
16. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... example by InvokeURL and then getting a JSON response back, the response does not seem to be read as a map: r_Response = invokeurl [ url :v_DataEndpoint type :POST parameters:m_CreateRecord headers:m_Header ]; info ...; Created on 06 February 2020
17. Zoho Deluge - Counting in a Map dataType: / Zoho /; What? A quick article on how to count within a map. I didn't have too much difficulty getting this to work and I'm not sure if there are better ways of counting so I'm documenting it to see if I can refine ...; Created on 02 September 2019
18. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; ... really random, it involves getting the milliseconds from a time object. v_Uid = zoho.currenttime.toLong(); // returns something like 1557400230165 Method #1: 5 Randomly Selected Letters ...; Created on 09 May 2019
19. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; What? This is an article explaining the code needed to write a PHP script which generates an access token for a service account which in turn is used to list files in a team's Google Drive. This is ...; Created on 02 February 2019
20. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019