Search - Joel Lipman .Com

1. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... XML of a GetItemTransactions request to eBay. How? You'll need an access token for eBay which I documented on how you can generate one in my article: Zoho Creator: Push to eBay Listings. Then you ...; Created on 22 January 2022
2. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; ... in turn generates an order in Shopify. This article is primarily for myself as I need to do this for some other clients and I just want to continuously refine and improve my code below. How? I' ...; Created on 21 January 2022
3. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; ... you may need on your quest to setup Zoho Analytics FTP Data Sources: Zoho Analytics IP Addresses to whitelist (if necessary): // EU Data Centers 31.186.226.0 - 31.186.226.255 185.20.209.0 - 185.20.209.255 87.252.213.0 ...; Created on 12 January 2022
4. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... you're going to need an external server to host a file that can respond to Xero with 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
5. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense): / Zoho /; ... need to follow these steps to get the credentials: Login to your Twilio console On the dashboard, note the ACCOUNT SID and AUTH TOKEN In the side menu, expand Phone Numbers > Manage > Active numbers ...; Created on 16 December 2021
6. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng): / Zoho /; ... = List(); if(!isnull(r_GeoCode.get("latitude"))) { // add user licence key (you'll need to get your own at https://timezonedb.com/references/get-time-zone) l_Params.add("key=123456789ABCD"); l_Params.add("format=json"); l_Params.add("lat= ...; Created on 15 December 2021
7. Zoho Deluge: Calculate start and end of Daylight Savings Time: / Zoho /; ... of code in case you need them. How? I will use this to amend and refine but here's the snippets for the various DSTs around the world. US (Except Arizona, Hawaii and US Territories?): DST ...; Created on 07 December 2021
8. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; ... (single-line) DST In Effect (boolean) With the addition of 2 lookup fields to our booking form: one called "Customer's TimeZone" and the other called "Agent TimeZone", then our code needs to ...; Created on 07 December 2021
9. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; ... Friday at 08:00 in the morning and will create a task if time logged is too low and will remind via Popup at about 4pm (16:00). You will need a connector (I've called mine joel_timesheet) and I've given ...; Created on 02 December 2021
10. Zoho CRM: Schedule a Call using Deluge: / Zoho /; What? This is an article to document how to schedule a call with a reminder in Zoho CRM using Zoho Deluge. Why? Because I find a need to document anything that takes longer than 30 minutes to ...; Created on 18 November 2021
11. Zoho Creator/Deluge: UnPredictable exception, Invalid statement found: / Zoho /; ... The Solution/Cause So quite simply, I'm using 2 for each loops and this is one of those scenarios where you need to store the loops into different variable names: // select a bunch of creator records ...; Created on 17 November 2021
12. Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time field: / Zoho /; What? I already have an article documenting Pushing a value to a datetime field in CRM but wanted another article here to remind me of the Deluge code I need to add/subtract time. Why? Just want ...; Created on 11 November 2021
13. Zoho Deluge: Today, Tomorrow, Day After but Skip Sunday: / Zoho /; ... few days which needs to dynamically change. I am aware of the function .addBusinessDay() but that excludes Saturdays which my client still works on. How? We're going to get today's date, then use ...; Created on 02 November 2021
14. Zoho Creator: Change Radio into Tabs: / Zoho /; What? This is an article to serve as a guide in terms of styling a radio group into a group of Tabs. This is only a guide or reference which was applied for one client but would need adapting to match ...; Created on 22 October 2021
15. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... ] } */ You need to select the id of the template that you want to use for the next step (will be an alphanumeric long string). The button function Create a button off the contacts record ...; Created on 21 October 2021
16. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... Shopify using a Product SKU. Community forums could only suggest looping through all the products. I then felt that actually I just need the Product IDs. This method could do with some refinement ...; Created on 12 October 2021
17. Zoho Books: Display Sales Order Shipping Address on Package Slip: / Zoho /; ... same as the billing address... Or more specifically, the primary contact, company, address and phone from the customer record and not from the sales order change. How? The key is a setting you need ...; Created on 07 October 2021
18. Zoho CRM & Zoho Books: Get Books Currency and Tax IDs: / Zoho /; ... check the URL for whether it will be https://books.zoho.eu or https://books.zoho.com. You will also need your own CRM to Books connection name (joel_books) with scope to read settings: // our made ...; Created on 24 September 2021
19. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; What? An article to note something I didn't realize I needed: How to address the above error and how to update a Shipping Address for a specific Sales Order in Zoho Books. Why? You might think ...; Created on 22 September 2021
20. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... API... Why? A follow on from my article Zoho Creator: Push to eBay Listings. I have a Creator app that needs to receive the orders from an eBay account as soon as the order or transaction is made ...; Created on 20 September 2021