Search - Joel Lipman .Com

1. 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
2. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Deluge: / Zoho /; ... is likely to be a linking module which has a multi-select lookup on both the deal/opportunity and products module. A multi-user lookup will tend to have something like "ModuleName_X_Users". Find records ...; Created on 28 April 2021
3. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API: / Zoho /; ... but I have since sent something similar to an API expecting nested arrays (not sure if they were PHP) and it works. Why? This took me several days and in the end only going through various forums ...; Created on 03 February 2021
4. Zoho Deluge: Sort a Map by a specific field: / Zoho /; ... looks something like this in a JSON parser: [ { "name": "Joel", "id": 46498, "date": "1977-11-14T12:30:00+00:00" }, { "name": "Anonymouse", "id": 8949, "date": "1923-10-16T15:00:00+00:00" ...; Created on 29 January 2021
5. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... . p_LeaveTill this is the value of "To" on the "Leave" form. Giving you something as per the following screenshot: Click on "Save" to accept this Note: It is important to add these parameters rath ...; Created on 10 December 2020
6. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... your action item Name the workflow Execute the action for Collection of record (this step is very important!) And you should have something like the following: Click through on "Add New Action": ...; Created on 06 December 2020
7. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... registrar's control panel, go through the process until this part is complete. Find the DNS Manager in your control panel, it might be called something like "Advanced DNS Editor", "Advanced Zone Editor" ...; Created on 17 November 2020
8. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... a Mac with admin privileges which would open the same popup link in the parent window. The solution however is to remove the base URL and only keep the URL as something like #Page:Notify. Do NOT add the ...; Created on 06 November 2020
9. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... should get prompted for the Mac/Admin password which you type in the terminal (will not display, just type away and press the Return key). The response will be something like “added 98 packages from 60 ...; Created on 24 October 2020
10. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... Fill in the new form to Create New Client: Client Name: put something descriptive so it is easy to identify if the client has 3rd-parties adding clients. eg. "JoelLipman_BooksConnector". Homepage ...; Created on 12 August 2020
11. AutoHotkey: Get Media Information and Display: / AutoHotkey /; ... unit to display Hours : Minutes : Seconds. We could have tried out some cool new DLL files for MS Windows 10 but we needed something lightweight that doesn't require any extra files and that could ...; Created on 07 August 2020
12. Zoho Deluge: Get Image Uploaded in Creator Form: / Zoho /; ... + zoho.appuri + "MyImages_Report/"; v_ImageSrc = v_ImageSrc + f_MyImages.ID + "/MyImage/image-download/" + v_PublishKey; v_ImageSrc = v_ImageSrc + "?filepath=/" + v_Filename; // yields something like ...; Created on 14 July 2020
13. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... yields something like // https://creator.zoho.eu/file/myadmin/myapp/myForm_View/123456789012345678/mySubform.myField/download/abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKL?filepath=/1234567890123_temp.pdf ...; Created on 15 May 2020
14. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktops: / AutoHotkey /; ... something like target: microsoft.windowscommunicationsapps_8wekyb3d8bbwe!microsoft.windowslive.mail. The easiest way to do this is to right-click and drag to the desktop (or wherever you want to store ...; Created on 18 July 2019
15. Zoho Deluge - Get Refresh/Access Token API v2: / Zoho /; ... mit "data" as something other than a JSON Array: m_Data = Map(); m_Data.put("data",m_RecordData); // MISSING .toJSONList() to convert m_RecordData to a JSON Array r_RecordUpdate = invokeUrl [ url :v_EndPoint ...; Created on 17 July 2019
16. Zoho Deluge - Get User Timezone, Country and Location: / Zoho /; ... v_Url ); Returns something like: { "ipAddress": "147.188.254.175", "continentCode": "EU", "continentName": "Europe", "countryCode": "GB", "countryName": "United Kingdom", ...; Created on 03 June 2019
17. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; ... yields I am Joe Not a regular expression but something I use to pad months and dates in a date format: v_MyString = 2; // February v_FormattedString = leftpad(toString(v_MyString), 2).replaceAll(" ...; Created on 31 May 2019
18. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; ... Zoho doesn't have a function to generate random numbers or strings. There are workarounds however. How? The first note is that there is something that can emulate a random number... well it's not ...; Created on 09 May 2019
19. Zoho Templates - Font size is inexplicably tiny: / Zoho /; ... pixels), cropping out excess whitespace, and re-uploading this fixed the problem. Step #1 Remove any images that you uploaded to Zoho and you've included in your HTML — this will be something ...; Created on 22 February 2019
20. Excel - Check a column for values found in another column: / Excel /; ... to other cells. You should end up with something like this (I have added some conditional formatting which colors the cells red or green for demonstration purposes): If you understand this ...; Created on 14 February 2019