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. GoDaddy Apache cPanel: Install SSL Certificate: / cPanel /; What? An article to remind me how to install an SSL certificate with GoDaddy. Why? A quick reference for myself as I found that with GoDaddy, a purchased SSL certificate seems to require re-installing ...; Created on 07 April 2022
11. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... wide web that had a working solution. My use-case here is that I have built an eBay integration between Zoho Inventory and... eBay. Out-of-the-box, and at-time-of-print, Zoho Inventory only syncs eBay ...; Created on 31 March 2022
12. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; What? This is a quick article on how I built my 2022 workstation and got 5 monitors working with only 1 graphics card. Why? This took me a good few hours to get working so I thought this article ...; Created on 12 March 2022
13. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... the code I use when a "Addition of a row" workflow is triggered on that subform. This makes sure I don't download it again and create a new Creator record to hold the same file but in a new record, as wel ...; Created on 11 March 2022
14. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... (triggers the next code snippet / workflow on user input of "calendar day select") v_PreselectedValue = zoho.currentdate.toString("EEEE") + "" + zoho.currentdate.toString("d") + "" + zoho.currentdate.addDay(v_DateIndex).toString("MMMM"); input.Calendar_Day_Select ...; Created on 09 March 2022
15. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... wanted that if the status had changed to something else, the first-line agent would not be allowed to set it back to "New Lead". Automations and workflows could however (run as Administrators). Mapping ...; Created on 11 February 2022
16. Zoho CRM: searchRecords with sorted results: / Zoho /; What? This is an article to document how to use the searchRecords function in CRM and to sort the results response. Why? This is unclear and not always working as coded below since each system ...; Created on 10 February 2022
17. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... I'm aware of is a regular expression. So the first expression I came up with worked to a certain point but didn't round up the numbers, in other words, it didn't remove the unnecessary zeros. Note ...; Created on 08 February 2022
18. ZohoCRM: Template: not being able to edit a text box: / Zoho /; What? This is a bit of an odd article with not 100% certainty on what the cause/outcome would be for your case but worked for us. This documents the steps taken to edit/modify the header on a sales ...; Created on 25 January 2022
19. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
20. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... (with different v_Webhook_Key). If it still doesn't work then try solution #2: using a third-party server detailed further in this article. Solution #2: Using Third-Party Server If this doesn't work ...; Created on 10 January 2022