Search - Joel Lipman .Com

1. Zoho CRM: Standard Setup for Tax Rates: / Zoho /; ... finance team. This is a quick run-through for a standard setup to include UK tax/vat. How? Here's a quick step-by-step to follow: Login to ZohoCRM as an Administrator Go to Setup > Customization ...; Created on 02 September 2021
2. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date String: / Zoho /; What? So this is a super quick note that I'll probably remember anyway but just in case, I'm writing this article so I don't spend time researching it later. Why? I'm synchronizing Xero Invoices ...; Created on 04 May 2020
3. Zoho CRM: searchRecords with sorted results: / Zoho /; ... listed here, the standard searchRecords() and then the getRecords() functions: Set the record ID to your own record ID. Set the list of pages to the number of pages you want to search. Keep ...; Created on 10 February 2022
4. Zoho Deluge: Generate List of TimeZones: / Zoho /; ... - Yekaterinburg (GMT+5:00) Kerguelen (GMT+5:00) Maldives (GMT+5:30) India Standard Time (GMT+5:30) Colombo (GMT+5:45) Kathmandu (GMT+5:00) Mawson (GMT+6:00) Vostok (GMT+6:00) Almaty (GMT+6:00) ...; Created on 19 October 2021
5. Zoho Deluge: Push a value to a datetime field in CRM: / Zoho /; ... + v_CreatorTime.toString("Z").subString(3); info v_CrmTime; // yields 2021-09-10T12:49:31-07:00 and vice-versa CRM to Creator Depends on the format of the datetime in your Creator field but standard ...; Created on 10 September 2021
6. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirects: / Zoho /; ... Standard as for any usual form without a redirect. Drag a decision box field on to the form; we are calling ours "Save & Close" with the field link name as "Save_and_Close" (the field link name is important ...; Created on 27 July 2021
7. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... to update the field with label "Group Name" but API name "Grouping" in a list item column. The standard code you used to use even for REST API v2.0 would have been something like the following: // // ...; Created on 17 May 2021
8. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Deluge: / Zoho /; ... CRM modules called a "LinkingModule" (as opposed to standard modules and custom modules). Quick way to determine the API name of the linking module: Go to setup > Developer Space > functions. Create ...; Created on 28 April 2021
9. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... modified with content/text and the popup size will automatically resize based on content. I tend to use the first solution combined with a form/table of standard messages allowing the client to enter ...; Created on 06 November 2020
10. Zoho Deluge - Determine Quarter from Date with Fiscal Year: / Zoho /; ... = ; l_MonthNames = ; Here's the standard code you'd expect if your Fiscal year starts in January (Divide by 3 and round up): for each v_Month in l_Months { v_Quarter = (v_Month.toLong() / ...; Created on 31 January 2020
11. Autohotkey - Chrome Profiles in Alphabetical Order: / AutoHotkey /; ... to open the profile. As an overview: Setup a standard AutoHotkey GUI Loop through Google Chrome Profile folders named "Profile 1", "Profile 2", etc. Scan the preferences file for JSON key "name" and ...; Created on 07 January 2020
12. Zoho Deluge: Adding / Removing Total Tax from a Quote Record: / Zoho /; What? A quick reminder on when I want to apply overall Tax or remove Tax from a quotes product line items. Why? I would apply the standard update function and although the response would say it ...; Created on 20 August 2019
13. Zoho Deluge - Get Refresh/Access Token API v2: / Zoho /; ... using Zoho Deluge and not another server-side script such as PHP to send the requests via API. Following standard OAuth 2.0 procedures, we will get a Code to generate a Refresh token, once we have ...; Created on 17 July 2019
14. Zoho Deluge - Get distance between two coordinates: / Zoho /; ... from the JavaScript library figuring if it supports cos() then try this standard function. Note this has only been tested in Zoho Creator rather than Zoho CRM. How? This function returns the distance ...; Created on 11 June 2019
15. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... '] = 'https://www.googleapis.com/auth/drive'; $api['gapis']['drive']['files'] = 'https://www.googleapis.com/drive/v3/files'; 4. Declare a PHP function to send requests using cURL A stand ...; Created on 02 February 2019
16. Google Authentication - OAuth 2.0 using PHP/cURL: / Google /; ... to use the mentioned token based authentication. I find myself going through the motion and designing on a per-app basis so I wanted a standard way of doing it and I'll update this article as I improve ...; Created on 31 October 2018
17. Protecting your Joomla Administrator Section: / Joomla /; ... affect the standard visitors to your Joomla website (specifically those not interested in logging into the administrator section). Updated for Joomla 3.x but pretty much the same system as used for previous ...; Created on 23 October 2015
18. Import Excel CSV file as JavaScript array: / Excel /; What I have: A CSV file exported from Excel along with double-quotes label1,label2 item1a,item2a item1c,"item2c,c" item1b,item2b What I want: To read the file (stored on the server) and ...; Created on 05 October 2015
19. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... Set to your v2.5.x admin ID to NOT migrate as per standard users SET @v25_admin_id=42; -- Set this to the ID number of the user in your Joomla 2.5.x -- Standard Users: INSERT INTO `v34_db`.`v34_users` ...; Created on 12 September 2015
20. Joes Quicklist Weblinks (JQW) Downloads: / Downloads /; ... Strict Standards Issue: New Operator removed for PHP5+. - Fixed Bug: Object without reference: Child object design converted to Object array.- Date Uploaded: Thu, 31st Oct 2013 3.0 - Fixed Bug: Version ...; Created on 07 September 2015