Search - Joel Lipman .Com

21. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... yields 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 ...; Created on 08 February 2022
22. Zoho CRM: Template: Empty Space between Header and Line Items: / Zoho /; What? A very quick article on how to deal with an issue where a CRM template has been used and where the table of line items appears on a separate page (and to remind me of the CSS to fix this). Why? ...; Created on 03 February 2022
23. ZohoCRM: Template: not being able to edit a text box: / Zoho /; ... order inventory template. Why? A client raised an issue that they had previously hard-coded the address of their organization into the body of a template (just below the header... they weren't using ...; Created on 25 January 2022
24. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
25. Zoho Creator: Change Radio into Tabs: / Zoho /; ... Set Clicked Tab to Selected One niggling issue I had was that when selecting a tab, the selected tab didn't stay a different color or style. One theoretical way around this could be that I restyle ...; Created on 22 October 2021
26. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... to run (this would initially attach the file to the CRM record). This wasn't working really as there are issues around tweaking the function and getting it to understand basic mapping and attachments. ...; Created on 21 October 2021
27. Zoho CRM: Permission Denied for Quote Conversion Mapping: / Zoho /; What? A really quick article for anyone experiencing the same issue: As a super admin in CRM, I am denied permission to access the Quote Conversion Mapping page... Why? I wanted to map a billing ...; Created on 02 September 2021
28. Xero API: Send Multiple Invoices: / Xero /; What? A really quick article for anyone who got stumped by the same issue: How to send multiple invoices to Xero in one API call? Why? Our use-case is in Zoho Deluge which couldn't generate more ...; Created on 15 August 2021
29. Zoho Deluge: Generate and Send a CSV via Email: / Zoho /; What? A super quick article to remind me how to generate and send a CSV as an attachment to an email. Why? Because I often get casually asked "oh and can you archive the data and email it to me ...; Created on 16 June 2021
30. Zoho CRM REST API: Stop Workflow from Triggering: / Zoho /; What? This is an article to show you how to use triggers but also how to stop them. We only found this an issue when using REST API v2.1 but also to show you how to configure triggers when using createRecord ...; Created on 16 June 2021
31. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... in an approval workflow but ran into issues when trying to update the record: { "response": { "message": "Error occurred", "uri": "/api/forms/json/P_ApplyLeave/updateRecord", "errors": ...; Created on 10 December 2020
32. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... window"); Known Issues Popup opens in the parent window: This only happens on certain machines and I couldn't narrow down the cause. I have tested on both Mac and PC but I had a client usin ...; Created on 06 November 2020
33. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... name. The issue is that if you use zoho.crm.searchRecords() this will work fine for company names without special characters such as the ampersand or parentheses. But what if amongst your records you ...; Created on 28 August 2020
34. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... IN datacenter: https://dre.zoho.in/delugeauth/callback Click on "Create" You will be issued a Client ID and Client Secret, make a note of these or leave this window to copy&paste into the next step. ...; Created on 12 August 2020
35. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... page for each minor issue. How? So I'm going to try and list solutions to minor errors we run into. Problem: Zoho OAuth Connection: ERROR_invalid_operation_type Sounds rather straightforward, ...; Created on 06 February 2020
36. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktops: / AutoHotkey /; ... test v_Leftest := a_MyArray[0,0] v_Central := a_MyArray[1,0] v_Rightest := a_MyArray[2,0] MsgBox 1: %v_Leftest% 2: %v_Central% 3: %v_Rightest% Now there is an issue in that Monitor ...; Created on 18 July 2019
37. Zoho Templates - Font size is inexplicably tiny: / Zoho /; What? This is an article resolving an issue where a template will shrink all the text when in PDF preview. Why? Ok doesn't need a song and dance about it, but I went home yesterday downtrodden ...; Created on 22 February 2019
38. Zoho Deluge - Update Creator from CRM: / Zoho /; What? This is an article documenting how to update Creator from a workflow written in a Deluge Script held in ZohoCRM. Why? I've also started this article to document an issue we encountered where ...; Created on 18 February 2019
39. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; What? This is an article explaining the code needed to write a PHP script which generates an access token for a service account which in turn is used to list files in a team's Google Drive. This is ...; Created on 02 February 2019
40. MySQL Transactions in PHP: / MySQL /; ... requires PHP 5.6 and above. For lower versions you can issue the MySQL commands directly like: mysqli->query("START TRANSACTION") mysqli->query("COMMIT") mysqli->query("ROLLBACK") Important note: ...; Created on 14 December 2016