Search - Joel Lipman .Com

1. 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
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. Zoho Creator: Change Radio into Tabs: / Zoho /; ... the "::after checked", hide the circle line and somehow style the inner dot to overlay or serve as background on the tab. But that was a bit too much CSS for my head so instead, I'm going to add yet ...; Created on 22 October 2021
11. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... other articles for integrating Shopify API with Zoho Creator: Zoho Deluge - Push Item to Shopify Zoho Creator - Integration with Shopify Checkout Storefront API Zoho Creator - Receive JSON via a Shopify ...; Created on 12 October 2021
12. Zoho CRM: Upload a Product Photo using Deluge: / Zoho /; ... = r_GetFullRecord.get("data"); v_CreatorPhotoUrl = ifnull(r_CreatorRecord.get("Display_Photo"),""); if(v_CreatorPhotoUrl!="") { // // download photo from your Creator (change connection and check ...; Created on 27 September 2021
13. Zoho CRM & Zoho Books: Get Books Currency and Tax IDs: / Zoho /; ... check the URL for whether it will be https://books.zoho.eu or https://books.zoho.com. You will also need your own CRM to Books connection name (joel_books) with scope to read settings: // our made ...; Created on 24 September 2021
14. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... = v_AddressIndex + 1; } // check that there was something to actually update rather than wasting an API call if(m_ShippingAddress.size() > 0) { // endpoint TLD is EU for Europe DC and COM for ...; Created on 22 September 2021
15. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... > input.DateTime_form_was_loaded.addSeconds(10)) { // do my stuff here } Method #2: Boolean checkbox to switch on/off workflow Another method I tried was adding a checkbox/decision box (boolean) ...; Created on 19 September 2021
16. Zoho CRM: Permission Denied for Quote Conversion Mapping: / Zoho /; What? A really quick article for anyone experiencing the same issue: As a super admin in CRM, I am denied permission to access the Quote Conversion Mapping page... Why? I wanted to map a billing ...; Created on 02 September 2021
17. Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd): / Zoho /; ... Additional You would of course need to check that there is nothing wrong with the date that was submitted. Especially if it is coming from a data source, the Zoho deluge .toList() fails the function ...; Created on 01 September 2021
18. Zoho CRM & Zoho Books: Get SalesPersons: / Zoho /; ... = zoho.crm.getRecordById("Sales_Orders",p_SoID); // // check if owner and get matching salesperson ID if(!isnull(r_SoDetails.get("Owner"))) { v_OwnerID = r_SoDetails.get("Owner").get("id"); v_Filter ...; Created on 30 August 2021
19. ZohoCRM: Process all records of a module: / Zoho /; ... you have a few hundred records, or a few hundred thousand records, we sometimes want to write a function that will check each record and mark it so that the process doesn't repeat on records that have already ...; Created on 24 August 2021
20. ZohoCRM: zoho.crm.searchRecords only returns certain records: / Zoho /; ... with a zoho.crm.getRecordByID() with a quote that works and a quote that doesn't Comparing both records JSON and finding the $converted system field is different. Checking the Zoho documentation for ...; Created on 29 July 2021