ZohoCRM: Make either Mobile or Email mandatoryhttps://joellipman.com/articles/crm/zoho/zohocrm-make-either-mobile-or-email-mandatory.html

03 October 2024 then Mobile Required" Select the Email field as the primary field to control this rule Set the condition that the email "is empty" > click on the "Next" button Set Mandatory FIelds > and select "Mobile" Repeat these steps to add another rule: Call it...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Border settings not saving in SSRShttps://joellipman.com/articles/microsoft/ssrs/border-settings-not-saving-in-ssrs.html

24 March 2011 time googling and still didn't find an answer. My situation is that I wanted to put an expression to format the border (empty cells have a border and non-empty don't). This was so that a grid would show for empty spaces. I wasn't getting very far...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Using a HTML form and PHP to upload a filehttps://joellipman.com/articles/web-development/php/using-a-html-form-and-php-to-upload-a-file.html

17 September 2009 . " "; The key of the above array is the name of the variable you passed in your HTML form. If the above yields NO empty data (and size is not 0) then it was successful. If not, then either your system isn't accepting the file type you are trying to...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Installing phpBB3 for Joomla with a RocketTheme templatehttps://joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 other link returned an error something along the lines of "template tpl load file styles prosilver login body does not exist empty". I backed up my local copy of the prosilver folder as well as my local copy of the Affinity for phpBB3 template. I...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Accessing a MySQL Database with Business Intelligence Development Studiohttps://joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 New Report" Select the "Shared Data Source" you just created > Next Click on the "Query Builder" button Right-click on any empty space in the first frame > Select "Add Table..." Add and specify the query as you would with any SQL query. (to create the...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

CSS keeping the footer at the bottomhttps://joellipman.com/articles/web-development/css/css-keeping-the-footer-at-the-bottom.html

25 April 2011 } #content { position: relative; top: 0; width: 900px; margin: 0 auto; min-height: 500px; /* to stop footer coming up on empty pages */ background-image: url("../images/bg_contentbox.png"); /* semi transparent background */ } #footer { position:...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: en-GB

Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 "screenshots" exists in the folder this program is run from. If it doesn't see one, it tries to create one. I personally empty that folder after a batch process but no, the program doesn't care. Question How can this be 100% FREE? Answer: I'm being...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Migrate Joomla Users to WordPresshttps://joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

03 October 2011 Joomla or Wordpress that you have a PHP enabled server available. Here's code to top off the user migration, save it to an empty PHP file and upload/run it on your server: please test before using!

• Type: Article
• Author: Joel Lipman
• Category: Wordpress
• Language: en-GB

Generate Academic Calendar using MySQLhttps://joellipman.com/articles/database/mysql/generate-academic-calendar-using-mysql.html

27 November 2012 468 2012/2013 52 2013-07-08 I'll use this table to create the calendar. Query #1: Works from command-line but may generate "Empty Query 1065" SELECT calendar.WeekNumber AS AcademicWeek, DATE_FORMAT(calendar.StartDate, '\%e-\%b-\%y') AS Mon,...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Battery Constantly Drained on iPhonehttps://joellipman.com/articles/apple/battery-constantly-drained-on-iphone.html

27 November 2012 I think this is a brilliant example where trying to fix the problem is the very cause of the problem in the first place: The empty arrow next to the battery indicator tells you that location services is enabled but it is attached to a reminder that...

• Type: Article
• Author: Joel Lipman
• Category: Apple
• Language: *

Quickly update all content in mySQL database replacing a stringhttps://joellipman.com/articles/database/mysql/quickly-update-all-content-replacing-a-string.html

03 February 2013 CONCAT('%',@stringtoFind,'%') OR `fulltext` LIKE CONCAT('%',@stringtoFind,'%') You might get some errors talking about some empty rows but don't be deceived as the update will have happened anyway. Other Searches Search and Replace a string in a mySQL...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Administrator Program Shortcut without Prompthttps://joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 I leave this blank but you could specify a working directory. OK the dialogs and close the Task Scheduler Right-click on an empty space on the desktop and select New > Shortcut Type in the task with the format schtasks /run /tn "task-name" schtasks /run...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

T-SQL: Parse an XML valuehttps://joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 FROM [dbo].[XML_EVENTS] Issues: XQuery [value()]: 'value()' requires a singleton (or empty sequence), found operand of type 'xdt:untypedAtomic *' This is because more than one record was returned so you need to surround with brackets and append a [1] as...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Hide a Drive per User in Windows 7https://joellipman.com/articles/microsoft/windows-os/hide-a-drive-per-user-in-windows-7.html

28 March 2014 In the right pane of Explorer, right click on a empty area, click on New > DWORD (32-bit) Value > type NoDrives > Enter. Right click on the DWORD you just created and click on Modify. Type in the drive option hex or decimal number from the list below...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Windows Live Mail Error ID: 0x8DE00005https://joellipman.com/articles/microsoft/windows-os/windows-live-mail-error-id-0x8de00005.html

14 December 2016 (changing the log-on username to your own): The downloading of all your folders will take a while so don't panic if you find empty folders. Doing a 'send/receive' will bring up the dialog showing its progress. Source: Windows Live Mail and Outlook Mail...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: en-GB

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 = '/access_token.dat'; 2b. Specify the impersonator Now for testing purposes you should leave this next variable as an empty string. If you leave this blank, the script will run through and connect to Google Drive using the Service Account. The script...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

MS Excel - Split Workbook into separate files per sheethttps://joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 each sheet into a file each. And we want all the files generated to be created in the same folder. Move the Excel file to an empty folder of its own With Excel open (ensure editing is enabled) hold down ALT and press F11 (Alt+F11) Go to Insert > Module...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Convert Past Date to Time Ago in PHPhttps://joellipman.com/articles/web-development/php/convert-past-date-to-time-ago-in-php.html

16 May 2019 plural/singular (should always be a positive number) $v_Str .= $a_UnitValues[$i]>1 ? 's' : ''; // only add to array if not empty/zero if($v_Str!='') $a_UnitPairs[] = $v_Str; } // take first item of array (round up to largest unit) $v_ReturnStr =...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Zoho Deluge - Some Useful Regular Expressionshttps://joellipman.com/articles/crm/zoho/zoho-deluge-some-useful-regular-expressions.html

31 May 2019 in Zoho Deluge. We match a pattern and replace everything out that conforms to the criteria so a true response will be an empty string: v_MyRegEx = "^[A-Za-z0-9._-]+@[A-Za-z0-9._-]+\.[A-Za-z]{2,}$"; v_MyString = "somewhere@beyondthesea.com";...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Search Records with Special Characters (COQL)https://joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 } Note that for the above, if there are no matching records, r_Coql will simply return an empty string. Hence the check for isNull on the keys info and data. And yes, the part that took me about 8 hours and the key point above is to replace the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *