Search - Joel Lipman .Com

1. ZohoCRM: Make either Mobile or Email mandatory: / Zoho /; What? A really quick article on a pretty cool requirement, making 2 fields mandatory but if one is completed then making the other optional. Why? My use-case is that the mobile or email field ...; Created on 03 October 2024
2. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... document gets sent to the end user Additional requirements: The signed version gets attached to the custom module record a ZohoSign Document record needs to be created to track the progress of ...; Created on 06 August 2024
3. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... because you have it processing data rather than responding straight away (less than 1 second requirement) to Shopify with "yes received" response. As such, here's a function which lists the Shopif ...; Created on 22 April 2024
4. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... Why? There were several alternatives we considered beforehand which still didn't fit the requirement: A client's first-line agents would have a lead record with the status "New Lead". The client ...; Created on 11 February 2022
5. Zoho CRM: searchRecords with sorted results: / Zoho /; ... in mind script execution limits set by Zoho. Set the search criteria string to your specific requirements (:equals:, :starts_with:, |=|). If 1 expression then you can omit the parenthesis. If multiple ...; Created on 10 February 2022
6. Zoho Templates - Font size is inexplicably tiny: / Zoho /; ... reserved for Zoho rendering (which did nothing to fix this problem), I found the cause of all the pain. I was setting a cover page (as per the client's requirements) with a background image and the logo ...; Created on 22 February 2019
7. GDPR Privacy Policy: / Static Items /; ... and other communications that we provide to you electronically satisfy any legal requirement that such communications be in writing. COPYRIGHT All content included on this site, such as text, graphics, ...; Created on 14 February 2019
8. Joes Word Cloud (JWC) Download: / Downloads /; ... languages. But broke something else... - Added requirement to only take words from Published articles.- Date Uploaded: Thu, 21st Oct 2010 1.1 - Added Joomla Admin Panel option: Cache-mode- Date Uploaded: ...; Created on 07 September 2015
9. A quick run through of setting up an export process in SITS: / Extensible Markup Language /; ... which will be specific to your business requirements. Why? If you're developing in SITS, and you use the client, the first time(s) you do this, the task is rather daunting. Having done it a few ...; Created on 21 August 2014
10. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; What? This article details a method we used on a search form in a SQL Server Reporting Services (SSRS) environment. The requirement (amongst others) was that the report ran in less than a few seconds. ...; Created on 07 March 2014
11. Generate a Timesheet in MySQL: / MySQL /; ... Sunday 03:00 04:00 - - 4:00 41:45 Some Requirements; StartTime will be the earliest someone starts work that day. EndTime will be the latest someone works that ...; Created on 05 December 2013
12. Oracle: order by subquery missing right parenthesis: / Oracle PL/SQL /; What? A quick note on how I got round one this one. Why? Often enough, our requirement is that the latest record from another table is associated with the current row, and often enough we get ...; Created on 05 December 2013
13. Client Services: Website Development Agreement: / Static Items /; ... based on the initial requirements up to and including the User Acceptance Testing (UAT) date (not yet agreed, but about a week prior to release date). JoelLipman.Com will make the source files available ...; Created on 15 November 2013
14. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... case, a mixture of mostly lowercase and some UPPERCASE. Why? I'm writing this article because other solutions on the net were either incomplete, did not work for me or simply did not match the requirements ...; Created on 04 October 2013
15. SSIS Skip Blank Rows in Flat File Source: / SQL Server Integration Services /; ... is not null and data column is not blank. Derived Column Task: Format keycolumn as per your requirements and use substring on trimmed DataColumn to retrieve each data column. Additional ...; Created on 23 April 2013
16. Stop Excel Row Height Self-Adjust on Refresh: / Excel /; ... and production, means that anyone with access to the Excel spreadsheet can go and view the connections and see the username/password details (granted read-only access). One of the requirements was that ...; Created on 30 September 2011
17. SSRS Querying on either of 2 Parameters: / SQL Server Reporting Services /; ... dataset queries and joined the table containing the other parameter (@StudentADAccount) in each dataset query, which slowed it down a little but the requirement was met. If your end-users complain, do ...; Created on 19 July 2011
18. Joes FREE Website Thumbnailer (JWT): / Product Documentation /; Tested on: Windows XP SP3, Windows 7 (both 32-bit) Tested with: MS Internet Explorer 7 libraries System Requirements: Used ~55Mb RAM on 1.6Ghz PC ...; Created on 28 June 2011
19. Set default parameter dates to start and end of month: / SQL Server Reporting Services /; Situation The requirement in a lot of my reports in SSRS has always been a date range rather than just the one date. The user must be allowed to select all results between two dates instead of just ...; Created on 05 April 2011
20. SSRS Hide results table if empty: / SQL Server Reporting Services /; ... below will also let you do this (requirements: common sense or the IQ of a duck). It's what I've been searching for for the past hour and although you may think I'm just adding to the cyberspace pile ...; Created on 29 March 2011