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. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... out of date at time of print, trial and error will resolve this or use our examples above. // fields required if submitting time log without start time (uses current time and adds hours to it) - date ...; Created on 30 April 2021
17. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... written. One is that there are 2 sets of documentation and the other is that the majority of the documentation doesn't refer to OAuth 2.0/json and instead uses the deprecated authtoken v1 and XML. How? ...; Created on 10 December 2020
18. Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Div: / Zoho /; ... is written at a time when Javascript or interactive pages that change on the fly based on a mouse event in Zoho Creator automatically get removed on Save/Update of the page. The following uses the built-in ...; Created on 22 October 2020
19. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... https://www.zohoapis.com.cn/crm/v2/coql 3. The Deluge Code - Uses the EU datacenter Note that using this method, you don't have to escape parentheses characters (): // initialize v_MatchedCount ...; Created on 28 August 2020
20. CSS Center an iFrame Horizontally and Vertically: / Cascading Stylesheets /; ... than the top/bottom/left/right outline. Why? On a mobile, a client's site uses an external page embedded by iframe. When the app within the iframe has an alert message, it popups a div at the centre ...; Created on 23 September 2019