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. ZohoCRM: ZDK Client Script to retrieve Contact Email: / Zoho /; ... = ZDK.Apps.CRM.Contacts.fetchById(v_VendorContactID); // get the email on this contact record var v_ContactEmail = r_ContactDetails.Email; // check it isn't blank if (v_ContactEmail ...; Created on 20 July 2022
11. Zoho Inventory - Mark a package slip as delivered and shipped: / Zoho /; ... check the form was ticked and there is a package ID specified if(input.Mark_as_Complete && input.Zoho_Package_ID != "") { v_PackageID = input.Zoho_Package_ID; r_PackageSlip = zoho.inventory.getRecordsByID("packages",v_BooksOrgID.toString(),v_PackageID,"ab_inventory"); if(r_PackageSlip.get("package") ...; Created on 14 July 2022
12. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... gets automatically converted to the Kindle format. Fix for PDF file now showing on the Kindle If that is the case, here are a few things you can do. Check if your Kindle is connected to the ...; Created on 29 June 2022
13. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... + v_CrmContactID + "/Attachments/" + r_Attachment.get("id"); r_Download = invokeurl [ url :v_AttachmentEndpoint type :GET connection:"ab_crm" ]; r_Download.setParamName("file"); r_CheckIfDocumentAlreadyExists ...; Created on 11 March 2022
14. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... field of your Creator form. If your app needs the Storefront API (eg. website checkouts) then set these. Mine don't as the Creator app I'm making is for staff only. REST Admin API: Usage: Here' ...; Created on 14 February 2022
15. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... String crmAPIRequest Outputs: output message to user Date Created: 2022-02-11 (JoelLipman.com - Joel Lipman) - Initial release - Checks the user profile ...; Created on 11 February 2022
16. Zoho CRM: searchRecords with sorted results: / Zoho /; ... in l_SearchResults { // check that there is an ID on this record to avoid looping through error messages if(!isNull(r_Result.get("id"))) { // do stuff to each record... info r_Result.get("id"); } } // // ...; Created on 10 February 2022
17. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... and display 12.5% instead of 12.50%. Well there might be a longer solution without using a regular expression (regex), as in check for the decimal point, check each digit thereafter to see if there ...; Created on 08 February 2022
18. ZohoCRM: Template: not being able to edit a text box: / Zoho /; ... to say this is a strange issue and an even stranger fix, but I've tested this solution by getting a colleague to refresh the page and check it out as well as the client to go in and confirm the change was ...; Created on 25 January 2022
19. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
20. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; ... Transfer Protocol on a Port number of your choosing: Set for new imports to append, replace, or check if exists then insert/replace: Schedule to repeat: Every X Hours, Every Day, Weekly, Monthly: ...; Created on 12 January 2022