Search - Joel Lipman .Com

1. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... or your client has, needs to be Zoho One. Because we're going to use Zoho Creator as a middleware. Just to add to the pain, I'm going to make my function in Zoho CRM: Overview Create a REST API CRM ...; Created on 31 March 2022
2. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... £959.84 Total: £2,059.65 Not Used Case Fans 2 fans from the 3rd pack of the CoolMoon 120mm Crystal - - The Result: Monitor cable connections I need to practice what I preach: ...; Created on 12 March 2022
3. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... the parent form to hide the columns I don't need the user to see (I'll populate these by code): hide Attachments.Parent_Record; hide Attachments.Document_Name; hide Attachments.Downloaded; Here ...; Created on 11 March 2022
4. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... = v_PreselectedValue; // // hide (comment this out if you are still debugging) hide Hidden_Fields; Then we need a workflow/trigger that runs whenever a user clicks on one of these date boxes (On ...; Created on 09 March 2022
5. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... store with a pre-built description, tags and inventory details. This means the app needs to be able to sync all of its products, customers, and orders with Shopify as a 2-way integration as the Zoho app ...; Created on 14 February 2022
6. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... extract user ID v_UserID = m_Webhook.get("user_info").get("id").toLong(); } // // if user ID was extracted sucessfully if(v_UserID != 0) { // // get user details (we need the profile) r_UserDetails ...; Created on 11 February 2022
7. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... as 10.00%. And they need the decimal because sometimes they might offer 12.5%. But when it displays in a template, it isn't that pretty to look at: Instead, could they have 10% to display instead of 10.00%, ...; Created on 08 February 2022
8. 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
9. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; ... which 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? ...; Created on 21 January 2022
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. 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
17. 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
18. 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
19. 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
20. 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