Search - Joel Lipman .Com

1. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... > Connections) Click on "Add Connection" and click on "Zoho OAuth" Give a lower connection name, eg. "joels_connector" Select the scope ZohoProjects.timesheets.ALL as a minimum (or CREATE/READ): ...; Created on 30 April 2021
2. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Deluge: / Zoho /; ... creating a record in a module that contains a lookup m_Create = Map(); m_Create.put("Name","Joels Amazing Test"); r_Create = zoho.crm.createRecord("Tests", m_Create); // now take the ID that was created ...; Created on 28 April 2021
3. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API: / Zoho /; ... "data": { "member_id": "123456", "channel_name": "shopify", "item_name": "Joel's Awesome Life", "item_price": "priceless" } } What Zoho sends to the 3rd-party API: Sending a map request ...; Created on 03 February 2021
4. Zoho Deluge: Sort a Map by a specific field: / Zoho /; ... Joel 1977-11-14T12:30:00+00:00 8949 Anonymouse 1923-10-16T15:00:00+00:00 335448 Amazing 1997-07-05T23:15:00+00:00 What I want: id name date --------------------------------------------- 335448 ...; Created on 29 January 2021
5. Zoho Deluge: Convert Map to HTML Table without a FOR loop: / Zoho /; ... NameLast NameID Joel Lipman 1 Another Person 2 How? This is a bit of a dirty solution and as long as "id" is not your first column (because "id" can be found in names like "David") it will work. ...; Created on 11 January 2021
6. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... Created: 2020-10-27 (Joel Lipman) - Initial release - Workflow to calculate 80% dept workforce - Returns response as popup - Cancels submit with ...; Created on 10 December 2020
7. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... the domain joellipman.com. Why? This took me a bit of going backwards and forwards to Zoho rather than getting my client to do this. The aim is to take up as little time as possible of the third-parties ...; Created on 17 November 2020
8. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... zet init You will be given a list of Zoho services, use the arrow up/down keys to select “Zoho Creator” and press the return/enter key. Give the project a name: eg. “joels_awesome_app” (without ...; Created on 24 October 2020
9. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... access/refresh tokens using OAuth2.0. Usually used with an invokeUrl: response = invokeUrl [ url: "https://books.zoho.com/api/v3/estimates?organization_id=12346789" type: GET connection: "joelconnector" ...; Created on 12 August 2020
10. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... and nor is List when submitted as a file attachment. sendmail [ from: zoho.adminuserid to: "info@joellipman.com" subject: "Testing an attachment" message: "This is a test" attachments: file: ...; Created on 15 May 2020
11. Zoho Deluge: Duplicate/Clone a Record: / Zoho /; ... for "Invoices": /* Function: fn_Button_CloneInvoice Purpose: This function duplicates a CRM invoice Parameters: p_InvoiceID (CRM ID of the invoice) Returns: Nothing Author: Joel Lipman Date Created: ...; Created on 17 March 2020
12. Joomla: Remove IDs from URLs for out-of-the-box SEF: / Joomla /; Applies to Joomla! CMS v3.5.x What? This is a short article on how to remove the ID numbers from your Joomla website addresses for search engine friendly URLs. // What I have www.joellipman.com/index.php?option=com_content&category_id=4&article_id=123-article-alias // ...; Created on 14 March 2020
13. Zoho Deluge: Convert Map to URL Parameters: / Zoho /; What? A quick article on converting a Map (associative array with keys and values) into a URL string to pass as URL parameters. How? Let's first define a map: m_Payload = Map(); m_Payload.put("client_id","my-unique-client-id"); m_Payload.put("redirect_uri","https://www.joellipman.com"); m_Payload.put("response_type","code"); m_Payload.put("scope","my_api_scopes"); m_Payload.put("prompt","login"); Great! ...; Created on 09 March 2020
14. CSS Center an iFrame Horizontally and Vertically: / Cascading Stylesheets /; What? So this is a quick article to demo how to center an iframe horizontally and vertically in a screen/viewport in pure CSS (no JavaScript allowed). This CSS centers it by its center point rather ...; Created on 23 September 2019
15. Zoho Deluge - Counting in a Map dataType: / Zoho /; ... us assume we have the following in a form/report called "Stock_Upload": RowID Name SKU Account Email 0001 Test Product 1 TEST001 test1@joellipman.com 0002 Test Product ...; Created on 02 September 2019
16. MS Excel - Open CSV with Long Numbers: / Excel /; ... ID,Name,Phone,Record ID 1457102000000135533,Joel,00441234567890,1457102000000165989 1457102000000135566,Stanley,01709123456,1457102000000167543 1457102000000135608,David,00331234567890,1457102000000166795 My ...; Created on 23 July 2019
17. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktops: / AutoHotkey /; ... shortcuts) then run the shortcut: RunWait, "C:\Users\Joel\Documents\_shortcuts\Mail - Shortcut.lnk" Without a shortcut, the command to run is: RunWait, "C:\Windows\explorer.exe" "shell:AppsFolder\microsoft.windowscommunicationsapps_8wekyb3d8bbwe!microsoft.windowslive.mail" ...; Created on 18 July 2019
18. Zoho Deluge - Get Refresh/Access Token API v2: / Zoho /; ... ID in books m_CreateContactPerson.put("first_name", "Joel"); m_CreateContactPerson.put("last_name", "Lipman"); m_CreateContactPerson.put("email", "This email address is being protected from spambots. You need JavaScript enabled to view it."); m_CreateRecord = Map(); m_CreateRecord.put("JSONString",m_CreateContactPerson); r_Respons ...; Created on 17 July 2019
19. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... As Range Dim xRow As Range Dim SplitRow As Integer Dim xWs As Worksheet On Error Resume Next xTitleId = "JoelsTooCoolForExcel" Set WorkRng = Application.Selection Set ...; Created on 11 February 2019
20. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019