Zoho Books: Get Invoice Payment Terms via APIhttps://www.joellipman.com/articles/crm/zoho/zoho-books-get-invoice-payment-terms-via-api.html

06 July 2023 -3 often displays "Net 56" instead. m_InvoiceDetails.put("payment_terms_label","Due end of next month"); // // loop through line items and populate for each m_SOLineItem in l_SalesOrderLineItems { m_InvoiceLineItem = Map();...

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

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

07 May 2024 td{ vertical-align:top; } #my-content table:first-child label{ text-transform: uppercase; color: #777; display:inline-block; width:100px; } #my-content table:first-child span{ font-weight:400; display:inline-block; min-width:100px; } #my-content...

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

Zoho Creator: Input Color Pickerhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-input-color-picker.html

14 October 2024 I've given it the field link name "Note_ColorPicker_Css" Add a radio field type, I've called it "Color Picker" Add a single line text field, I'm calling it "Hexadecimal" [Key field that will be used by the application later - so perhaps rename this to...

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

Warning call_user_func: First argument is expected to be a valid callbackhttps://www.joellipman.com/articles/cms/joomla/warning-call-user-func-first-argument-is-expected-to-be-a-valid-callback.html

22 November 2012 First argument is expected to be a valid callback in /home/.../templates/rt_affinity/rt_sectionrows.php on line 311 How? Copy & backup the file /public_html/.../templates/rt_affinity/rt_sectionrows.php Find the following piece of code around line 311:...

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

A for loop within a for loop in MS-DOShttps://www.joellipman.com/articles/automation/ms-dos/a-for-loop-within-a-for-loop-in-ms-dos.html

03 October 2013 technology belonging to the 90s - MS-DOS v6.22). The example wants to loop through a directory and then loop through the line it finds. Why? I use another technology for automation but sometimes the simpler solution is the one I make for other people to...

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

Zoho Deluge - MD5 functionhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-md5-function.html

19 November 2018 field can't be done via the documented methods (base64, urlencode or AES) as this exceeds 255 characters (it could be a multiline but this would defeat the objective of an Etag). How? Well I was going to document writing a Creator function but found a...

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

Zoho Creator: isBlank and isNull: Before or After?https://www.joellipman.com/articles/crm/zoho/zoho-creator-isblank-and-isnull-before-or-after.html

10 February 2025 Null is FALSE ---------------------- Value of TEST is NULL isBlank Preceding is TRUE isBlank Succeeding is FALSE: Error at line : 57, Value is empty and 'isBlank' function cannot be applied isNull Preceding is TRUE isNull Succeeding is TRUE Equals Blank...

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

Using K2 with jezReCaptcha plugin causing errorshttps://www.joellipman.com/articles/cms/joomla/using-k2-with-jezrecaptcha-plugin-causing-errors.html

25 September 2009 ) in /public_html/components/com_k2/lib/recaptchalib.php on line 67 I've managed to fix this in my site. Because you already force the recaptcha feature in your registration form and contact form (on this website I just went recaptcha-happy), then there...

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

Report Builder 2.0 - Hide Series1https://www.joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

06 May 2010 Add a condition to the WHERE clause Specify that the field name in the series fields is not blank So I've added the AND line to the above statement yielding: SELECT _SMDBA_.Incident.[Incident #] ,_SMDBA_.Incident.[Group Name] ,_SMDBA_.Incident.[Close...

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

Joe's CSV Chart Generator (JCG)https://www.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=40

26 May 2010 out of, includes almost every type of chart you can think of (though this program only uses chart types: Area, Bar, Column, Line and Pie). Note that AMCharts.com is free as long as you leave the copyright information. If you want to remove the copyright...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• 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 work but if not click on "Rebuild" Issues I ran into joomla Fatal error: Call to a member function getPath categories.php on line 435 I haven't found a way to automate this yet but you can fix all of these in one go by logging into your Joomla! 1.6.0...

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

PHP & MySQL Search Enginehttps://www.joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

09 March 2011 display function search_return_keywords($str) { $search = array ( '@ @si', // Strip out javascript '@ @si', // Strip out Inline Stylesheets '@[{].*?[}]@si', // Strip out Internal Joomla Curly Brackets commands? '@@si', // Strip out HTML tags...

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

Checklist for the local computer repairshttps://www.joellipman.com/hardware/checklist-for-the-local-computer-repairs.html

28 April 2011 per hourly rate Computer repair per hourly rate "I always 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...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

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

03 July 2011 [function.in-array]: Wrong datatype for second argument in /public_html/modules/mod_quicklistweblinks/helper.php on line 214 This is because you have not selected a thumbnail "service group" authorized to generate new thumbnails in the module...

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

Before and After, Highs and Lowshttps://www.joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

03 August 2011 ExecutionLogStorage.TimeStart), DATEPART(year, ExecutionLogStorage.TimeStart), Catalog.Name Chart-wise: create a line chart [Sum(Counter)] will be the data field, [ReportName] will be the series field and [DayOfYearRun] will be category field: So is...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 Limitations of Excel 2007 PivotTables Aesthetics: Drilldown bolded items are NOT the sum of a expanded node. (despite no line separator or the totalled value in the corresponding row) Show this week date range by default Use a WHERE clause:...

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

Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 with the following code: Explanation type="text" - standard attribute that tells the field this is an input field for single line of text. name="name" - attribute that assigns a variable name to this field so we can reference it later....

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

SSIS Convert a string into a datehttps://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 Known Issues [Convert Date [4228]] Error: An error occurred while attempting to perform a type cast. [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Convert Date" (4228) failed with error code...

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

Improve Default Joomla Search https://www.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 have never seen in any other system. I've googled and binged but could not find anything that documents how to bring it into line with other search systems. So here we go, hope this helps you. Why? I've created search systems for a plethora of other...

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

Joomla Component: Set default params on installationhttps://www.joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

24 October 2013 the Options of the component, and click on "Save"... despite the fact that I don't change anything. How? Add the following line to the XML installation file: script.php Now create a script.php file in the root folder of your component (ie. same as the...

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