Search - Joel Lipman .Com

1. MooTools Framework: / Category /; Created on 05 March 2020
2. jQuery Framework: / Category /; Created on 05 March 2020
3. Zoho CRM REST API: Stop Workflow from Triggering: / Zoho /; ... or updateRecord. Why? We had a Creator app updating a CRM record which in turn had a workflow to update the Stage in Creator (so a user can change the stage in CRM and it would reflect this in the ...; Created on 16 June 2021
4. COVID-19: Working from Home: / Articles /; Ergonomic adjective "relating to or designed for efficiency and comfort in the working environment." So it's pretty important not to be slouching over the coffee table for hours or days on end. I ...; Created on 05 July 2020
5. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... size of about 11Mb. In order for an import process to work, the import would only accept XLS files no greater than 1Mb. So our script has to split a single spreadsheet into multiple worksheets of 3000 ...; Created on 11 February 2019
6. Display Feeds to major Social Networks: / Web-Development /; What? A quick article on how I displayed feeds from the company's social network pages in one page. Why? There are 3rd-party apps that let you do this, some paid, some not. This was for a staff ...; Created on 16 May 2016
7. Export/Import Database using MySQL Workbench: / MySQL /; What? This article isn't unique as there are other tutorials out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database. Why? ...; Created on 05 February 2013
8. Getting the mysql where in delimited string to work: / MySQL /; ... this work is not mine and comes from a clever function by Chris Stubben in the MySQL Forums: BEGIN DECLARE i INT DEFAULT 0; -- total number of delimiters DECLARE ctr INT DEFAULT 0; -- counter for ...; Created on 02 January 2012
9. Joes Network Transmission Detector (JTD): / Product Documentation /; ... it do? Amazing. It detects transmissions over a network. Basically on a computer that isn't on a network (ie. not connected to the internet), this program is extremely boring and doesn't do anything. ...; Created on 29 September 2011
10. Zoho Deluge: Zoho Bookings Get Available Slots: / Zoho /; ... = zoho.bookings.getAvailableSlots(, , , ); Set up your connector with the following scope: zohobookings.data.CREATE Get the workspaces: // // get workspaces r_WorkspaceResults ...; Created on 23 June 2021
11. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... then press the numbers in the numeric pad (while still holding down the ALT key), then let go of the ALT key. Remember: This will not work with the numbers at the top of your keyboard unless you ...; Created on 03 June 2021
12. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... included in my v2.1 example above. Should be submitted even if tax at line item level is 0. Triggers when using REST API v2.1 When using the REST API (even v2.0), the workflow/approval/blueprint triggers ...; Created on 17 May 2021
13. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... to when trying to enter a time against a project Task but this article is focused on getting this working against Project Issues. Also note, we will refer to Project Issues in this article, but in the ...; Created on 30 April 2021
14. 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
15. 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
16. 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
17. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... article because I keep forgetting on how to do this. I have a specific order of steps on how I do this, you may find other ways but this is one that works for me. How? So here's an overview and then ...; Created on 06 December 2020
18. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... usually have 3: .joellipman.com (used in verification), .joellipman.com and www..joellipman.com (for the subdomain). I have had this working with the 2 CNAME records though. Some providers say this ...; Created on 17 November 2020
19. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... and even in some cases only as an additional link in the form. The example below is for use in a customer portal on the click of a report button (report workflow). How? This will create a popup ...; Created on 06 November 2020
20. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; What? This is an article documenting how to create a Zoho Creator Widget which includes the Bootstrap and jQuery frameworks as well as other JavaScript functionality. Why? Quite simply that at ...; Created on 24 October 2020