Search - Joel Lipman .Com

1. MooTools Framework: / Category /; Created on 05 March 2020
2. jQuery Framework: / Category /; Created on 05 March 2020
3. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... on "My Folders" and then checking the URL https://workdrive.zoho.com/home//privatespace/folders/ Getting the teamfolder ID: Access the folder in workdrive and check the URL: https://workdrive.zoho.com/home//teams//ws//folders/files or https://workdrive.zoho.com/home//teams//ws//folders/ ...; Created on 11 September 2024
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... Go back to the contact record, and upload the file to the attachment... Some customers say this is unworkable and takes far too long, especially the part of adding the various field placeholders ...; Created on 06 August 2024
13. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; What? A very quick article on how to check what the statement execution limit is on the Zoho application you are working in. Why? Our use-case is that an application we built in Zoho Creator was ...; Created on 31 July 2024
14. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... workspace you want to create the monitoring system. Preferably use the workspace that has the data to check. For demo purposes, I'm going into the CRM Reports workspace > Click on "Create" > Then select ...; Created on 25 July 2024
15. Zoho Projects: Get All Events: / Zoho /; What? A quick article because I couldn't find anything that documented this with a working example. Why? The use-case here is that we want to make a ZohoCreator page display events for this month ...; Created on 22 July 2024
16. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... is. So we have a workaround, by sending all the data including the custom fields per line items to ZohoAnalytics; and in ZohoAnalytics importing a table based on a query which joins the sales orders and ...; Created on 09 July 2024
17. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... and the system managers need to be notified in advance of any errors with the intention to be able to correct any inconsistencies themselves. How? We're going to add a scheduled workflow on a daily ...; Created on 02 July 2024
18. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... by going through forum posts from 7 years to 2 years ago. The following will work in May 2024 following the API domain change. The use-case is that the customer wants the item/product rate taken ...; Created on 23 May 2024
19. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... everyday for 3 days then escalate to a specified user". Why? Sorry Zoho! I tried using the interface to set up a workflow or any other mechanisms within ZohoCRM that allowed me to set up a daily ...; Created on 14 May 2024
20. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... cut even more time, we could store it directly in ZohoCRM and have a CRM workflow/automation forward it to Zoho Creator. m_WebhookLog = Map(); m_WebhookLog.put("Name","Shopify - Inventory Update - " + ...; Created on 22 April 2024