Search - Joel Lipman .Com

1. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkit: / Zoho /; ... how to troubleshoot issues with this. One important thing to note is that the setup needs to be done by whoever manages the domain for the client. Who owns the domain (eg. mycompany.com) So this ...; Created on 04 May 2023
2. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; ... Pivot" cp ON cp."Contact Id"=c."Id" Caveat(s) You may have noted a few caveats with this solution: This query needs each campaign name specified to see the results per contact person. You can ...; Created on 20 March 2023
3. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... ChatGPT Plus possibly exposing email addresses that belong to random users] 2023-03-20 Like my previous article, this needs to be fed contextual data to continue a conversation Done 2023-03-11 ...; Created on 06 March 2023
4. ZohoCRM: Import Attachments: / Zoho /; ... of an "Attachments.csv" file that needs the correct values in each column and the "Attachments.zip" containing the files to attach that needs some formatting as well: Note that any IDs used in the snippets ...; Created on 16 January 2023
5. Zoho Deluge: Generate a loop or list of any size: / Zoho /; ... of weeks thereafter). This needs to be dynamic as it is a schedule run daily checking the availability of a staff member for the upcoming week. How? As mentioned, using leftpad takes 2 parameters, ...; Created on 21 October 2022
6. ZohoCRM: ZDK Client Script to retrieve Contact Email: / Zoho /; ... on save of the record, but the client wants the email to be prefilled in the field as soon as a contact is selected. How? This needs to behave like a formula field which changes and displays before ...; Created on 20 July 2022
7. 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
8. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... Mini-DisplayPort, which means that only 1 DisplayPort cable needs to go the PC. They also have 1 HDMI input. The NZXT Z490 Motherboard I have only has 1 HDMI port. Here's a crude diagram of what I had: ...; Created on 12 March 2022
9. 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
10. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... 12 Additional Note(s): You might ask why not use the built-in round() function? Well I admit that round() needs to be used for currencies. The issue is that round() only rounds up decimals to ...; Created on 08 February 2022
11. 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
12. 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
13. 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
14. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... a field called "Audit_Change" and then I add to it our workflow with the main bit of code. For any other field that needs to update this preview, I tell it to update the "Audit_Change" field with something ...; Created on 19 September 2021
15. Zoho CRM: Permission Denied for Quote Conversion Mapping: / Zoho /; ... don't use the invoice module (that's for their finance team using ZohoBooks), we disabled the CRM Invoice module. How? Therein lies the reason. For the quote conversion mapping, it needs the CRM ...; Created on 02 September 2021
16. Xero API: Send Multiple Invoices: / Xero /; ... invoices). Our solution: Send all Zoho invoices in API call to Xero... apparently it can accept up to 60 invoices in one call. How? Crazy simple solution, your JSON needs to have the key "Invoices" ...; Created on 15 August 2021
17. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... need to be adapted for your needs. Note that I have used 2 URL methods of linking to the Creator app and some data formatting that I tend to use regularly for my benefit later on when I simply copy & ...; Created on 30 July 2021
18. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirects: / Zoho /; What? This is an article to document how to have two submit buttons on a non-stateless form which both submit the form but one leaves the current record open while the other redirects to the reports ...; Created on 27 July 2021
19. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... GUI and display what it will name them. The app needs to rename files but append an incremented count if the name of a file already exists. The original file needs to keep its original name. What ...; Created on 08 July 2020
20. Convert Past Date to Time Ago in PHP: / Personal Home Page /; ... but less than 2 weeks ago How? I know there are so many examples out there that do this perhaps better but this one I understand and can customize to fit my needs. This PHP function accepts ...; Created on 16 May 2019