Search - Joel Lipman .Com

1. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... both of the methods below, you will need to setup a client script which runs when the product page is being modified: Login to ZohoCRM as a system administrator Give it a name, I'm calling mine "Products ...; Created on 13 December 2023
2. Zoho Books: System Values Maps: / Zoho /; ... m_NominalAccounts; / // --------------------------------- // get delivery methods r_DeliveryMethods = invokeurl [ url :"https://www.zohoapis.com/books/v3/deliverymethods?organization_id=" + v_BooksOrgID typ ...; Created on 07 November 2023
3. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkit: / Zoho /; What? A quick article on the SPF & DKIM setup to improve email deliverability from a ZohoApp and methods to check. Why? Not sure how I came across it as most of our customers don't use ZohoMail, ...; Created on 04 May 2023
4. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... = Map(); m_Params.put("amount",v_StripeAmount); m_Params.put("currency","gbp"); //m_Params.put("automatic_payment_methods[enabled]", false); m_Params.put("payment_method_types[]","card_present"); m_Params.put("capture_method","manual"); v_DescriptionString ...; Created on 16 March 2023
5. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... What I have Me,Myself,I\na,b,c What I want Me,Myself,I a,b,c How? So in this article I just want to list some various methods of inserting a new line character. Works on most ...; Created on 01 March 2023
6. Zoho CRM: searchRecords with sorted results: / Zoho /; ... (CRM, Creator, Books) seems to interpret this sorting feature differently. This article is an effort to find clear and working solutions. It is working again as of 2022-02-10. How? Two methods ...; Created on 10 February 2022
7. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense): / Zoho /; ... = "This is a test text"; // // build up the endpoint (see https://www.twilio.com/docs/usage/requests-to-twilio#http-methods for latest endpoint) v_Endpoint = "https://" + v_Account_SID + ":" + v_Auth_Token ...; Created on 16 December 2021
8. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... article to go through various methods I tried to prevent this from happening: First - Off: The one workflow to rule them all In the first instance, we don't want large amounts of code to be copied ...; Created on 19 September 2021
9. 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
10. 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
11. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... may want to find: Company Name: Father & Sons (Incorporated) Contact Name: O'Reilly How? Well I've tried various replace methods with regular expressions but the only method reliable enough ...; Created on 28 August 2020
12. Zoho Deluge: Get Image Uploaded in Creator Form: / Zoho /; What? So this is an article to document the methods I use to get an image uploaded in a form to display in a report or on another page. Why? There might be different articles out there and discussion ...; Created on 14 July 2020
13. JComments errors in PHP 7: plgContentJComments and JCommentsACL: / Joomla /; ... How? First some errors: ERROR: plgContentJComments Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; plgContentJComments has a deprecated ...; Created on 13 March 2020
14. Zoho Deluge - Get Current User ID: / Zoho /; ... being deprecated (end of life at the end of this year). So I'm familiar with the methods in API v2 or just using newer functions. Method #1: API v1 userResp = getUrl(("https://crm.zoho.com/crm/private/xml/Users/getUsers?authtoken=xxxxxxxxxxx&scope=crmapi&type=ActiveUsers")); users ...; Created on 08 April 2019
15. Minimal Privileges for MySQL Database Backup Cron Job: / cPanel /; ... database) to a copy of the database (inaccessible via other users). How? I want to list 2 methods here. One to create a .sql file of the backup but another to copy the contents to a copy of the ...; Created on 20 March 2019
16. Zoho Deluge - Update Creator from CRM: / Zoho /; ... person and adding our previous Super Admin account as a "Developer". How? I'm going to demo two methods here using the Setup the Connection Link Login to ZohoCRM as the creator super admin/owner ...; Created on 18 February 2019
17. Zoho Deluge - MD5 function: / Zoho /; ... be done via the documented methods (base64, urlencode or AES) as this exceeds 255 characters (it could be a multiline but this would defeat the objective of an Etag). How? Well I was going to documen ...; Created on 19 November 2018
18. Display a thumbnail of a Google Drive video: / Google /; ... redirects to something like: https://lh3.googleusercontent.com/=w320 Methods of getting the File ID #1 Right-click on the file and select "Get Shareable Link". If link sharing is already on, it ...; Created on 13 November 2018
19. Zoho Deluge - Get Full Day Name: / Zoho /; ... of the day (eg. "Mon"). My_Date = today; Day_Name = My_Date.toString("E"); // returns "Mon" How? Well a few methods. Method #0: Update 2020 Tested in CRM and Creator and this is working: My_Date ...; Created on 08 November 2018
20. Zoho Deluge - Get English Ordinal: / Zoho /; ... == "3" || This_Day_Date == "23") { English_Ordinal = "rd "; } // display info My_Date.toString("d") + English_Ordinal; How? I'm exploring various methods, so here's a couple using the ...; Created on 08 November 2018