Search - Joel Lipman .Com

1. MooTools Framework: / Category /; Created on 05 March 2020
2. jQuery Framework: / Category /; Created on 05 March 2020
3. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; What? An article on something that has taken me several days to get working: Get Zoho Books or Zoho Inventory that when an invoice is marked as paid, update 2 custom fields with the Payment Method, and ...; Created on 17 August 2022
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. Zoho Deluge: Get All Orders from eBay: / Zoho /; What? Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay. Why? Our use-case is a data migration from eBay to a fresh instance ...; Created on 29 March 2023
12. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; What? A super quick article on getting the business hours set in ZohoCRM. Why? When creating a booking system in ZohoCreator, I want to enter the default working shift for an employee either existing ...; Created on 28 March 2023
13. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; What? A very quick article of a quick solution but at least a working example of an ANSI-SQL (ZohoSQL) query pivoting campaign results vs contacts. Why? Simply the client wanted a report on customers ...; Created on 20 March 2023
14. ZohoCRM: Get All eBay Active Listings: / Zoho /; What? Another one of these articles talking about getting all the active product listings from eBay for a specific client. Why? Our use-case scenario here is that we want to get an inventory ...; Created on 01 March 2023
15. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... given some lists and strings and although the same code worked great on one Zoho CRM, another client's ZohoCRM was not accepting "\n" as a new line character and instead would render/display it as "\n"... ...; Created on 01 March 2023
16. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... that were in practice added to the same function and that worked at time of print. Note that this uses the old Trading API as the new API is only available in Sandbox??? I won't go into how to generate ...; Created on 28 February 2023
17. Zoho Creator: Disable/Hide the add and delete subform row buttons: / Zoho /; ... you know the code to remove this field, then you know what I mean. In Workflow mode: add a workflow to the form whenever it is created or edited, on load of the form; I call mine "OnLoad". For Deluge ...; Created on 28 February 2023
18. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... query which will now retrieve 10 products per page and loop through 3 pages for use in Zoho Deluge. If this works, we can increase the number of pages as well as the number of products per page: The ...; Created on 20 February 2023
19. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... commands Stealth Mode To keep images private, send these as direct messages to the Midjourney Bot. Just bear in mind that any image in a prompt can be accessed if people work out the link. "Stealth" ...; Created on 11 February 2023
20. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... this one "jl_recruit". The Deluge code for workflow /* ******************************************************************************* Function: void fn_AB_AssociateVacancy2Candidate(int ...; Created on 08 February 2023