Search - Joel Lipman .Com

1. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... Step] This is an added note/step if you get the following error when trying to access your app on your localhost: “127.0.0.1 normally uses encryption to protect your information. When Google Chrome ...; Created on 24 October 2020
2. No rows returned in Oracle causes SP to fail: / Oracle PL/SQL /; ... one of my reports uses a row counter to display a "No data found" message when no rows are returned. This does not affect the above problem as the stored procedure simply fails and discontinues processing ...; Created on 24 January 2012
3. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... a client who uses their purchase orders and sales orders as part of a logistics solution where items are purchased from a supplier, sent to another supplier for grading, and then sent on to the end user/customer. ...; Created on 09 July 2024
4. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... without a second parameter is .toString("yyyy-MM-dd'T'HH:mm:ssXXX") which uses the timezone of the system but to override this I need .toString("yyyy-MM-dd'T'HH:mm:ss", v_ThisTimeZone) Incorrect Created By: ...; Created on 14 May 2024
5. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; What? A follow on from my article Zoho Creator: Create a Widget which uses JavaScript back from 2020 with a few adjustments now in 2024. This widget will only work within Zoho Creator. If you want ...; Created on 14 March 2024
6. Zoho CRM: Client Script Confirmation Box and Popup Mailer: / Zoho /; ... with the to email address, bcc, subject and message content already populated. How? The example from the Kaizen series uses a record with canvas mode applied; but I wanted to try it without a ...; Created on 06 February 2024
7. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... Uses row.ID as the identifier to prevent duplicates. c_CheckDoc = Document[Subform_Row_ID == v_ImageRowID]; // // if exists then update if(c_CheckDoc.count() > 0) { c_CheckDoc.Image=c_ImageRow.Image; c_CheckDoc.File_field=f_DownloadFile; v_UploadFileID ...; Created on 26 January 2024
8. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... for the above demo. Invalid OAuth Scope: Might be an invalid scope, or the TLD (datacenter) is incorrect. The above demo uses the EU datacenter (zoho.eu) rather than the US datacenter (zoho.com). ...; Created on 05 December 2023
9. Zoho Inventory: Enable Tracking using the API: / Zoho /; What? One of these articles because I spent so long trying different snippets of code to enable tracking when using Deluge code to create an item in Zoho Inventory: Why? Who uses ZohoInventory ...; Created on 04 May 2023
10. 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
11. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... that were in practice added to the same function and that worked at time of print. Note that this uses the old Trading API as the new API is only available in Sandbox??? I won't go into how to generate ...; Created on 28 February 2023
12. Zoho Deluge: Generate a loop or list of any size: / Zoho /; What? This is an article on a trick I picked up from one of our interviewees as well as apparently in one of the Zoho documentation manuals. It uses leftpad to create a string of a length, converts ...; Created on 21 October 2022
13. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... We want the photo on eBay to be downloaded and uploaded to the Zoho Inventory record for the respective record. As Zoho Books and Zoho Subscriptions uses the same database tables as Zoho Inventory, and ...; Created on 21 June 2022
14. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... Xero webhook. You're going to need to respond to Xero with valid and invalid HTTP statuses as their webhook validation process is a little stricter than Zoho's. Setup a Zoho CRM Function: Login ...; Created on 10 January 2022
15. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; ... uses the US datacenter but has it's server timezone set to "US/Eastern" or "America/New_York" (-05:00). Our sales person is on the west coast in the timezone "America/Los_Angeles" (-08:00). And our customer ...; Created on 07 December 2021
16. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... You will note that I use the access token function (one that regenerates an access token or reuses if not expired). Thereafter, I use the GetMyeBaySelling API Call with specific criteria to only return ...; Created on 13 October 2021
17. Zoho CRM: Upload a Product Photo using Deluge: / Zoho /; What? A quick article to remind me on how to upload a photo using CRM API v2. Yes it's documented and yes it still confuses me now and again. So I'm writing this to remind me and to keep reminding me ...; Created on 27 September 2021
18. Zoho CRM & Zoho Books: Get Books Currency and Tax IDs: / Zoho /; ... CRM and want to map the correct currency and tax by their ID numbers. How? Using the REST API and InvokeURL in Zoho Deluge to look at Zoho Books. This uses up an extra 2 calls so you could run ...; Created on 24 September 2021
19. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; What? This is an article to document how I got a client's eBay to notify the seller every time a buyer bought a fixed price item. This uses the Trading API even though I'm aiming for the Platform Notifications ...; Created on 20 September 2021
20. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... and from a developers understanding: field1 is told to update field2 when field1 is changed. When field2 is changed, it is told to update field1. This causes a recursive or endless loop where each field ...; Created on 19 September 2021