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. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... Not sure about the rest of you, but I've been using this for pagination purposes and for the system to work out how many pages or loops in total it would need to do. How? Here's a couple of working ...; Created on 14 November 2023
12. Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSON: / Zoho /; ... it works then the connection string is fine. What I was doing?: I'm not saying this is the solution to whenever you get the above error; I'm just saying this what I was doing and this is what fixed ...; Created on 04 October 2023
13. Zoho Books: Generate Bank Text File for Download: / Zoho /; What? This is an article to document how we created a button off a Bill record in ZohoBooks which generates a text file to be sent to a bank and downloads it to the staff member's workstation. Why? ...; Created on 02 October 2023
14. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... This is the code used in a workflow triggered within ZohoCRM when a Quote is created or modified: // // initialize v_BooksOrgID = 123456789; v_BooksCustomerID = 0; m_CreateEstimate = Map(); l_CrmBillingAddress ...; Created on 18 September 2023
15. Zoho Creator: Sendmail a list of attachments: / Zoho /; ... void fn_Joel_Test() { /*** - tried with getUrl() but this doesn't work. - has to be an invokeUrl - set param name required - if file comes from a Creator form, no InvokeURL needed c_Form ...; Created on 20 July 2023
16. Zoho Deluge: Proper Case for Names: / Zoho /; ... to work using Zoho Deluge. How? There are a number of combinations that I won't have thought of but the below code sufficed for my current task, common English and some European names: // // ...; Created on 13 July 2023
17. Zoho Creator: Find Duplicates by Customer Name for Large Datasets: / Zoho /; ... } Caveat(s): There was a risk that the removeAll() command would remove every customer from the "all" list. That didn't happen so the above code works at time of print. Things can change though ...; Created on 12 July 2023
18. Zoho Deluge: Determine if Daylight Savings are in effect: / Zoho /; ... about 4 months until I can confirm this works. Why? I've covered this before in a fair few articles on this website but for clients in the US, where there could be 4 different timezones between customer, ...; Created on 03 July 2023
19. Zoho CRM: Change System Field Length: / Zoho /; ... but it is a workaround I have used and that worked when converting a lead to a deal. Note that this hack doesn't work on the system field label name (I tried) just on the length field. Use the translations ...; Created on 19 June 2023
20. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkit: / Zoho /; ... cases, a working example can return within the hour as authenticated. Use the following link to continue monitoring for when this has taken effect: https://zohomail.tools/#runChecks Source(s): ZohoCRM: ...; Created on 04 May 2023