Forum Ruleshttps://www.joellipman.com/static-items/forum-rules.html

31 May 2009 Breaking rules result in punishments. There are several types of punishments: Warning - This is where a public announcement is made that mentions your name and that you have broken a rule. I will determine whether you knew what you were doing was wrong...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile)https://www.joellipman.com/articles/crm/zoho/zoho-crm-using-a-function-for-validation-rules.html

11 February 2022 option in the Lead Status picklist: Login to ZohoCRM > Setup > Customization > Modules and Fields > Leads Select "Validation Rules" and cick on "New Validation Rule" Choose the layout, this has to be the highest level (I think) as a custom lead layout...

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

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 0)); INSERT INTO `my_new_database`.my_prefix_assets ( `parent_id`, `lft`, `rgt`, `level`, `name`, `title`, `rules`) SELECT @new_jos_banners_parent_id AS parent_id, @new_jos_assets_id_last_lft:=@new_jos_assets_id_last_lft+2 AS lft,...

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

Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 = 'Uncategorised' LIMIT 0,1); INSERT INTO `v34_db`.`v34_assets` ( `parent_id`, `lft`, `rgt`, `level`, `name`, `title`, `rules`) SELECT @assetParentID, a.`lft`, a.`rgt`, a.`level`, CONCAT('com_content.article.',...

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

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

03 October 2024 is required. Both aren't required but at least one should be. How? We can do this without code and only using ZohoCRM layout rules. Let's take a contact record for demo purposes: If I enter a phone number: If I enter an email: And then let's specify a...

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

A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 Store/save your SMG Setting up the DataChange Out Rule (DOR) This is where we can link to other entities and create the rules on changes to the relevant fields Run DOR from the menu system Enter a DOR code (we kept this the same as the the XET and EOR...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 involved). Regulations: Flight regulations are fed from api.joellipman.com and currently default to the principal global rules set out by the Federal Aviation Administration (FAA), UK Civil Aviation Authority (CAA) and European Air Transport Command...

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

Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 scalable, award-winning, accurate representations of heraldic symbols, attention to detail, consistent with heraldic rules::3 deformed, unrealistic symbols, lack of detail, inconsistent with heraldic rules::-2 thumbnail: ::5 Bright High-Contrast...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

GDPR Privacy Policyhttps://www.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 consent to exclusive jurisdiction and venue in such courts. Arbitration under this agreement shall be conducted under the rules then prevailing of the American Arbitration Association. The arbitrators' award shall be binding and may be entered as a...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Could not instantiate mail functionhttps://www.joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

09 May 2011 refused 111 Can't open SMTP stream. One common problem people have is an incorrectly setup mail system. Here is a list of rules that must be followed: I took this from Direct Admin but it has some useful guidelines for these kind of issues: How to setup...

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

Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 may be denied when the modification itself materially and adversely affects the operation of the network or violates the rules and protocols for communication across the network. Corresponding Source conveyed, and Installation Information provided, in...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

htaccess Rewrites SEF URL and submits to PHPhttps://www.joellipman.com/articles/web-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

05 September 2013 Anything not ending in ".html" will simply return a 404 error. I've included my error rules (they basically redirect to a branded error page). So I sanitize on the receiving index.php file: Check for possible Code Injection Do NOT allow the use of...

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

Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

04 June 2014 leading and trailing spaces SET @Ret = LTRIM(RTRIM(@Ret)); -- capitalize first character of data irrespective of previous rules SET @Ret = UPPER(SUBSTRING(@Ret,1,1)) + SUBSTRING(@Ret,2,LEN(@Ret)); END ELSE BEGIN -- return the string unaffected if it is...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 (your safari browser can not display this page anymore) Type: zet validate You should get a response saying that Validation Rules passed successfully. Now Type: zet pack You should get a response saying something like “Extension packed successfully as …...

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

Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-text-sms-using-twilio-api-localsense.html

16 December 2021 Adapting it to trigger off a scheduled workflow of a call/meeting Login to ZohoCRM > Setup > Automation > Workflow Rules > Create Rule Module is "Calls" Rule Name can be whatever you want, I'm calling mine "Calls - Send SMS Reminder 1 Hr Before" When is...

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