Search - Joel Lipman .Com

1. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... = v_Counter + 1; } info "Statement execution limit is 50000"; Additional Note(s): Observation #1: Method Chaining: Contrary to my previously held belief, method-chaining still counted as separate ...; Created on 31 July 2024
2. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... and vice-versa. And in this use-case, my client has added an incredible number of price books/ price lists and then has in excess of 20k items. Previously, the function that would need to get the ...; Created on 23 May 2024
3. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... (aka the Quote Builder) will need to post a new quote to the system as well as show previous orders. How? We're going to use the Zoho Extension SDK. You should refer to my previous linked article ...; Created on 14 March 2024
4. Zoho Deluge: Proper Case for Names: / Zoho /; ... other entry does not... This article is a start and adaptation of my previous article Convert to Proper Case in T-SQL which I had previously used for the migration of a HR system. This is intended ...; Created on 13 July 2023
5. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... Note how we added the invoice reference and Zoho ID in the description of the payment capture in our previous bit of code: /* ******************************************************************************* Function: ...; Created on 16 March 2023
6. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... upon ZohoZIA and we get a lot of requests around customizing ZohoZIA... How? So taking ideas from my previous article for ZohoCliq; let's use what we know to develop a ZohoZIA for a demo system. ...; Created on 06 March 2023
7. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... for those who want to integrate ChatGPT with ZohoZIA. Why? Previously, I would edit the message handlers of a Cliq Bot I created but it would only understand the questions I have programmed it to ...; Created on 13 February 2023
8. ZohoCRM: Import Attachments: / Zoho /; ... here is called "Attachments_001.csv"... I didn't do that, this process seems to have done that): On the next step, check your Attachments CSV has the mandatory columns and as previously mentioned, Attachment ...; Created on 16 January 2023
9. Zoho Creator: Populate a Multi-Lookup: / Zoho /; ... specified in a previous multi-line text field l_PackageRefs = c_Appt.Associated_Package_Slips1.toList(); // // important to declare this as a list of integers l_PackagesToAdd = List:Int(); for ...; Created on 18 August 2022
10. 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
11. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... OptiPlex 9020 Micro Form Factor CPUi3 4th Gen i7 4th Gen RAM4Gb 8Gb GPUNvidia Geforce GT 610 ??? O/SMS Windows 7 Pro (32-bit) MS Windows 10 Pro (64-bit) Here's a photo of my previous ...; Created on 12 March 2022
12. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; What? Another article on styling a radio group to become a weekly calendar carousel. In that a radio group displays the days of the week with arrows allowing the user to select the next or previous ...; Created on 09 March 2022
13. Zoho CRM: Schedule a Meeting using Deluge: / Zoho /; ... time of print, I couldn't find that much information on how to build up a JSON request to create a meeting (previously known as Event) in Zoho CRM. Here's a quick snippet of code to remind me. How? ...; Created on 02 March 2022
14. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... previous version was limited by our ability to search by product SKU. The new version, taking advantage of GraphQL, will be able to search by SKU and retrieve the correct product ID, variant ID, and inventory ...; Created on 14 February 2022
15. ZohoCRM: Template: not being able to edit a text box: / Zoho /; ... order inventory template. Why? A client raised an issue that they had previously hard-coded the address of their organization into the body of a template (just below the header... they weren't using ...; Created on 25 January 2022
16. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
17. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... field and the Session ID fields that we didn't use in my previous article but are going to use now. You get the Dev ID from your application keys page: For the next steps, it's best if you create ...; Created on 20 September 2021
18. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... like: input.Audit_Change = "Title: " + input.Title; Method #1: (do not use) Previously I have tried adding a field called "DateTime form was loaded" which would have the currenttime when the form ...; Created on 19 September 2021
19. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... d this in the example above. Line Item Tax doesn't display at line item lvel Previously submitting no tax would still put a 0.00 in the tax column of a line item. I have found that you have to inclu ...; Created on 17 May 2021
20. Zoho Deluge: Sort a Map by a specific field: / Zoho /; ... will use to sort in ascending/descending order and a map created to hold all the records. Loop through the sample map to create the new map we can sort as well as to add keys to the list declared previously. ...; Created on 29 January 2021