Licence GNU/GPLhttp://mail.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 To prevent this, the GPL assures that patents cannot be used to render the program non-free. The precise terms and conditions for copying, distribution and modification follow. TERMS AND CONDITIONS 0. Definitions. “This License” refers to version 3 of...

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

Terms & Conditionshttp://mail.joellipman.com/static-items/terms-conditions.html

30 May 2009 If you continue to browse and use this website you are agreeing to comply with and be bound by the following terms and conditions of use, which together with our privacy policy govern Joel Lipman .Com's relationship with you in relation to this website....

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

GDPR Privacy Policyhttp://mail.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 through relevant privacy notices presented in context and choices that are on brand. More info about GDPR. Terms & Conditions Conditions of Use Welcome to our online store! JoelLipman.com and its associates provide their services to you subject to the...

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

ZohoCRM: Using Criteria with Module Record Counthttp://mail.joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

14 November 2023 and double. You can search for a maximum of 10 criteria (with same or different columns) with equals and starts_with conditions. The only operator that is supported for encrypted fields is equals. When you use "equals" for multiple conditions, and if...

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

Joomla WHERE clause with ORhttp://mail.joellipman.com/articles/cms/joomla/joomla-where-clause-with-or.html

16 July 2014 . ' = '. $db->quote('true'),'OR') ->where($db->quoteName('condition2') . ' = '. $db->quote('true')) Method #2 - array: $conditions = array( $db->quoteName('condition1') . ' = true', $db->quoteName('condition2') . ' = true' ); $query->where($conditions,...

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

Joes Quicklist Weblinks (JQW)http://mail.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 equal. The module specifies the size of the image. The module keeps generating website thumbnail preview images on TWO conditions: 1) you are logged in to the front-end of the Joomla! website as an authorized "service group" user (as specified in the...

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

Stop Excel Row Height Self-Adjust on Refreshhttp://mail.joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

30 September 2011 would be like a magician revealing the secrets to his tricks... no it wasn't really, time was the issue. Additional conditions Direct access to our databases, both development and production, means that anyone with access to the Excel spreadsheet can go...

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

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

24 October 2014 airport, airfield, military, private or listed building. Dynamic Zones are created using data fed for extreme weather conditions, earthquakes (by earthquake.usgs.gov) and at some point temporary flight restrictions. Currently Listed Zones: Worldwide...

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

CSS Ordered List 1, 1.1...1.10 Formatting and Alignmenthttp://mail.joellipman.com/articles/web-development/css/css-ordered-list-1-1-1-1-10-formatting-and-alignment.html

10 July 2019 correctly. Why? I'm finding that I need to do this quite often for some clients who want to include their terms and conditions in quote/invoice templates and want the HTML to be indented neatly. Other examples out there will work, but I found that once...

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

ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.http://mail.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

22 September 2021 "currency_code": "GBP", "reference_number": "Salespersons Test Reference", "terms": "These are our test terms and conditions", "customer_id": "234567890123456789", "payment_terms": 30, "salesperson_id": "345678901234567890", "line_items": [ { "item_id":...

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

ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 new one. - Fixed reference_number being included on customer payment. Date Modified: 2023-03-21 (Joel Lipman) - Added if conditions to not adjust stock level if item has enough quantity then that purchased - Adds tracking number and carrier to shipment...

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

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 + " " + v_Icon_LinkedInHTML + " " + v_Icon_PinterestHTML + " " + v_Logos_PartnersHTML + " Important Terms & Conditions: By choosing to purchase or hire... "; // // get all active users in CRM m_UserMapping = Map(); v_Endpoint =...

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

Zoho Creator: Render to PDF with margins and page numbershttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 I've put some really small print here just so that you don't really read this and appreciate that we have terms and conditions like every other business. Page of Copyright © My Company Ltd. All Rights Reserved. Additional Notes to Self: Some...

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

ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 final balance invoice, we are deducting the deposit v_DepositAmount = Math.round((v_QuoteGrandTotal / 2) * 100) / 100; // conditions based on the invoice type if (v_InvoiceType == "Final Balance") { v_DepositAmount = -Math.abs(v_DepositAmount); } //...

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

Zoho CRM Client Script: Map Quote to Invoicehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-client-script-map-quote-to-invoice.html

09 October 2025 ZDK.Page.getField('Currency').setValue(o_QuoteDetails._Currency); ZDK.Page.getField('Terms_and_Conditions').setValue(o_QuoteDetails._Terms_and_Conditions); ZDK.Page.getField('Adjustment').setValue(o_QuoteDetails._Adjustment); // field mapping of quoted...

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

ZohoCRM & Xero: Function to pull most recent quoteshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

13 October 2025 m_UpsertCrmQuote.put("Xero_Reference",ifnull(m_ThisQuote.get("Reference"),"").trim()); m_UpsertCrmQuote.put("Terms_and_Conditions",m_ThisQuote.get("Terms")); // // some standard CRM Quote fields we can populate v_CrmQuoteStatus =...

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

MySQL Transactions in PHPhttp://mail.joellipman.com/articles/database/mysql/mysql-transactions-in-php.html

14 December 2016 before committing any changes to the data. This where transactions are useful. We can run the queries, then check if some conditions are met before committing the changes in the data: $mysqli->begin_transaction(); $mysqli->query ("UPDATE 'accounts' SET...

• Type: Article
• Author: Ike Francis
• Category: MySQL
• Language: en-GB

Zoho Inventory Template Issue: First Page is Blankhttp://mail.joellipman.com/articles/crm/zoho/zoho-inventory-template-issue-first-page-is-blank.html

15 November 2018 table would display on the first page, the product line items would then print on the second page, with the terms and conditions or small print notes on a third page. How? Printing to PDF or saving as a PDF lets me preview the page breaks based on the...

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