Search - Joel Lipman .Com

1. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; What? A quick note here on how to connect to the DHL API and check on a package given a tracking number. Why? In our megafunction to generate a customer, a product/item, a sales order, an invoice, ...; Created on 21 March 2023
2. Excel - Check a column for values found in another column: / Excel /; What? This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook). How? So for demonstration ...; Created on 14 February 2019
3. AutoHotkey: Check Windows Folder Sizes: / AutoHotkey /; What? So I needed to clear space on a workstation's C drive. There are other programs about and even some built-in to MS Windows that could potentially be used. This is a quick article on how to ...; Created on 28 January 2019
4. Zoho Deluge: Check Time Booking Slots: / Zoho /; What? Just wanted a note to get in my head the logic if checking a requested time slot isn't a double-booking (as in, the time slot doesn't overlap a previous booking. How? Given a date/time and ...; Created on 05 December 2018
5. Things to Check if Joomla Password Reminder email not being sent: / Joomla /; ... to check: Check the email message even exists: Login to your Joomla Admin Panel Navigate to Extensions > Language Manager Click on the “Overrides” label Click on “New” (but don’t create a ...; Created on 09 May 2013
6. Deserialization and cannot checkout files in TFS: / Team Foundation Server /; Why? So I get back from annual leave and I can't check-out / check-in any files in a Visual Studio 2010 project. All my colleagues can. What? Rather silly I know and the solution is one of those ...; Created on 03 January 2013
7. Code Troubleshooting Checklist: / Web-Development /; ... error in understandable and diagnosable parts? Checked appropriate services are running? Questions for the customer Can you access the service? Can you open other similar files in ...; Created on 03 June 2011
8. Checklist for the local computer repairs: / IT Support /; ... had work order forms in duplicate. Right above the signature line was a BIG BOLD WARNING ABOUT LOSS OF DATA and “Check this box to have your data backed up for $75. Then, I’d charge them $150 for “forensic ...; Created on 28 April 2011
9. Developer's Checklist: Taking over a projec: / Web-Development /; ... exaggerate a little); but seriously, I needed a checklist that works for me. Most Difficult? My hardest project was (still is) one created by a PhD student who graduated and left the institution. ...; Created on 01 March 2011
10. Security Checklists: / Joomla /; Basically the gist of http://docs.joomla.org/Security_Checkli … omla_Setup is as follows: Security Checklist 4 - Joomla Setup 1. Install official versions of Joomla 2. Change the default administrator ...; Created on 06 September 2009
11. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... level or stock check of all the products that are currently listed in a client's eBay store; we want to get the stock level and then use this data to synchronize with data held in Zoho Inventory... How? ...; Created on 01 March 2023
12. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; What? An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this ...; Created on 28 February 2023
13. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... mode is only available in the most expensive subscription plan. NSFW will likely be blocked. Installing Stable Diffusion on a local server is the recommended stealth mode. Check out Matt Wolfe's video ...; Created on 11 February 2023
14. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... + v_CandidateZohoID + r_Data.get("id") + ")"; l_CheckExists = invokeurl [ url :v_SearchEndpoint type :GET connection:"ab_recruit" ]; v_CountExists = 0; if(!isnull(l_CheckExists.get("data"))) { for ...; Created on 08 February 2023
15. ZohoCRM: Import Attachments: / Zoho /; ... here is called "Attachments_001.csv"... I didn't do that, this process seems to have done that): On the next step, check your Attachments CSV has the mandatory columns and as previously mentioned, Attachment ...; Created on 16 January 2023
16. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... // check if end date is specified and if it is then add to this row v_EndDate = null; v_EndDateValue = ZDK.Page.getField('Actual_Finish_Date').getValue(); if (v_EndDateValue !== null) ...; Created on 09 December 2022
17. Zoho Deluge: Generate a loop or list of any size: / Zoho /; ... of weeks thereafter). This needs to be dynamic as it is a schedule run daily checking the availability of a staff member for the upcoming week. How? As mentioned, using leftpad takes 2 parameters, ...; Created on 21 October 2022
18. Zoho Recruit: Rollup Number of Recruit Candidates to CRM Account: / Zoho /; ... = zoho.crm.searchRecords("Accounts","Account_Name:equals:" + v_SchoolName,1,10,m_Blank,"zcrm"); for each r_School in l_SchoolSearch { // check no search error and valid records are returned if(!isnull(r_School.get("id"))) { // ...; Created on 19 October 2022
19. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; ... get the quote details given a record ID r_QuoteDetails = zoho.crm.getRecordById("Quotes",p_QuoteID); // // check target email is not null/blank if(!isnull(r_QuoteDetails.get("Email"))) { v_Url ...; Created on 18 August 2022
20. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... and payment date to appear on the invoice. How? This sounds rather straightforward, write a function that given an invoice, checks the customer payments and updates the custom fields. Executing ...; Created on 17 August 2022