Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming value is required, the following 197 results were found.

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

    which boxes to output Under "Export format", specify any code lookups (eg. for CAP_STAC, we want the code and the lookup value/name and then something to display if the lookup fails: &G[STA.SRS:·|·]&ABLANK="*InvalidCode*|*InvalidCode*", will output...

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

  2. Add attribute xsl:nil=true on empty elements using XSLThttps://www.joellipman.com/articles/cms/website-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

    XML element as NULL using the attribute "xsi:nil". I'm going to use a very short example by providing a blank date of birth value: -- What I have: // -- What I want: Why? Outputting from SITS:Vision to our staging environment, the application would only...

    • Type: Article
    • Author: Joel Lipman
    • Category: XML Stylesheet Language Transformations
    • Language: *

  3. MS Excel: Convert a text to a numberhttps://www.joellipman.com/component/content/article/ms-excel-convert-a-text-to-a-number.html?catid=110&Itemid=165

    This is a quick article on how to convert some cells in Microsoft Excel to number values... Why? OMG. Seriously Microsoft! I have spent an hour trying to convert a column of currency values to a number using Microsoft Excel 2010. Since when did MS Excel...

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

  4. Zoho Deluge: Adding / Removing Total Tax from a Quote Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-adding-removing-total-tax-from-a-quote-record.html

    = List(); m_TaxOption1 = Map(); m_TaxOption1.put("percentage",20); m_TaxOption1.put("name","VAT"); m_TaxOption1.put("value",v_TotalTax); l_TaxOptions.add(m_TaxOption1); m_TaxOption2 = Map(); m_TaxOption2.put("percentage",0); m_TaxOption2.put("name","No...

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

  5. Zoho Deluge: Push Multi-Select Picklist containing Commas from CRM to Creatorhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-push-multi-select-picklist-containing-commas-from-crm-to-creator.html

    The CRM module has a multi-select picklist which will use commas to delimit but one of the options has a comma in its value. // What I have in CRM: {"My_MultiPicklist":["Option1","Options 2, 3"]} // What Creator understands: FAILS...

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

  6. Zoho Creator: Set Up Custom Domain for Customer Portalhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-set-up-custom-domain-for-customer-portal.html

    or "DNS Zone Editor": If the subdomain has a CNAME record, modify it as per the below (not the "Name" just the "CNAME" value) Name will be something like .mydomain.com. and www..mydomain.com. TTL = 300 Type = CNAME CNAME = creator.cs.zohohost.com or...

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

  7. Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-reject-an-application-for-leave-in-deluge.html

    p_Dept as the name of the "Department"... this is found on the Employee form not the leave form. p_LeaveFrom this is the value of "From" on the "Leave" form. p_LeaveTill this is the value of "To" on the "Leave" form. Giving you something as per the...

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

  8. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

    + v_UserID + ")"; l_SearchResults = zoho.crm.searchRecords("Vendors_X_Users",v_SearchCriteria); Code to Add a value to a multi-lookup (on Create Record): // sample code when creating a record in a module that contains a lookup m_Create = Map();...

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

  9. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

    m_Record.put("Name",""); m_Record.put("Address",""); m_Record.put("Territory",""); // // split values by commas l_FieldValues = r_Data.toList(","); if(l_FieldValues.size()>0) { m_Record.put("EmployeeID",l_FieldValues.get(0)); }...

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

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

    SID you obtained in the steps above v_Account_SID = "ABCDEFabcdef0123456789ABCDEFabcdef"; // // set this to the authtoken value obtained earlier v_Auth_Token = "1234567890aaaabbbbccccddddeeeeff"; // // set this to your Twilio number (dialing/texting...

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

  11. Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

    field payment mode m_MiniCustomField = Map(); m_MiniCustomField.put("api_name","cf_payment_method"); m_MiniCustomField.put("value",v_PaymentMode); l_NewCustomFields.add(m_MiniCustomField); // // add custom field payment date m_MiniCustomField = Map();...

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

  12. Zoho CRM: Manage a subform using Client Scripthttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-manage-a-subform-using-client-script.html

    a subform using a Zoho CRM Client Script. Why? A client wanted an automation on-the-fly that when selecting a specific value in a field, a row would be added to a subform contained herein. How? Well I won't go in to detail on how to add a client script,...

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

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

    the most recent mySQL version -- installed. These are NOT the same as apostrophes used in SQL to define -- non-numerical values. -- ----------------------------------------------------------------------------- -- -- 1. replace all database names in the...

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

  14. 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

    respective commands to update the Installer ID in these as well. Copy over users (but with disabled accounts): CHANGE the value of @v25_admin_id to the number (in my example "42") to the admin ID of your installer ID. --...

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

  15. Print Directory Contents to a Filehttps://www.joellipman.com/component/content/article/print-directory-contents-to-a-file.html?catid=80&Itemid=165

    you are unsure this will work) Add a key to this one called "command" Under the "command" key, there should be a new string value called "(Default)". If there isn't create a New "String Value", name it "(Default)" Double-click this string value and type...

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

  16. The ReportServer Databasehttps://www.joellipman.com/articles/else/database/the-reportserver-database.html

    NULL This is the rendering format. Mostly RPL if viewed in MS Internet Explorer. Parameters ntext NULL Parameters and the values they were submitted with. TimeStart datetime NOT NULL Time report started to run. TimeEnd datetime NOT NULL Time report...

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

  17. T-SQL Record Separatorhttps://www.joellipman.com/articles/else/database/t-sql/t-sql-record-separator.html

    need to add an actual row separating the different days which is either blank or full of hyphens/dashes. Stage #2: Replace values in last data row with blanks The trick to this is to get Stage #1 working for you with your query and then for every column...

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

  18. Stored Procedure to List Distinct Values and Countshttps://www.joellipman.com/articles/else/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

    but using this stored procedure means I only specify the table and then the columns. How? IF OBJECT_ID('usp_ListDistinctValuesAndCounts', 'P') IS NOT NULL DROP PROCEDURE [usp_ListDistinctValuesAndCounts]; GO CREATE PROCEDURE...

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

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

    PivotTable Report...resources in row (along the side)......staff in columns (along the top)......persondays in values (the number my bosses want - 7h 24m or 26640s is 1 person day)... With date range as parameters...ouch......and it was so easy up...

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

  20. Getting the mysql where in delimited string to workhttps://www.joellipman.com/articles/else/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

    statement "WHERE IN (c.RoomImages)", this is interpreted as a string and when converted to a number only retrieves the first value before the first comma. Consider the following, the first query is how MySQL interprets the query and the second is what I...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
Results 61 - 80 of 197