Advanced Search

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 items is required, the following 57 results were found.

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

    A quick reminder on when I want to apply overall Tax or remove Tax from a quotes product line items. Why? I would apply the standard update function and although the response would say it modified the record, the tax wouldn't apply both visually and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  2. Zoho CRM: Standard Setup for Tax Rateshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-standard-tax-rate-setup.html

    Information, edit the field "Tax" (multi-select) and select both tax rates Now go to a transactional module that has line items and use the product When you click on the edit icon in the line item "Tax" you will see both options available to be ticked,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.https://www.joellipman.com/articles/crm/zoho/zoho-books/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

    and conditions", "customer_id": "234567890123456789", "payment_terms": 30, "salesperson_id": "345678901234567890", "line_items": [ { "item_id": "456789012345678901", "discount": 0, "quantity": 1, "description": "A test product description" } ],...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  4. Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

    // not working // use inventory_items l_Variants.add(m_Variant); m_Product.put("variants",l_Variants); // // do photos if(input.Photos_Changed) { l_AllImages = List(); v_PositionIndex = 0; for each v_ShopifyImageSrc in l_ShopifyPictures {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  5. Zoho Creator: eBay: Get Item Transactionhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-ebay-get-item-transaction.html

    m_Params.put("ErrorLanguage","en_GB"); m_Params.put("DetailLevel","ItemReturnCategories"); // // include fixed price items m_Pagination = Map(); m_Pagination.put("PageNumber",v_Page); m_Pagination.put("EntriesPerPage",v_PerPage);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  6. Zoho Creator: Populate a Multi-Lookuphttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-populate-a-multi-lookup.html

    somewhat better to use the built-in interfaces provided by Zoho Creator. What I really needed was a way to display the line items from a package slip taken from Zoho Inventory. I'd prefer if it was included in the list view or a Zoho Creator report....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  7. ZohoDeluge: Check Shipment Status via DHL APIhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zohodeluge-check-shipment-status-via-dhl-api.html

    I've set up a nightly schedule which checks on all the shipments from a certain date and updates the shipment status for items that have been delivered: Login to ZohoInventory > Setup (Cog Icon) > Automation > Schedules > New Schedule > I'm calling mine...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  8. Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

    display:inline-block; min-width:100px; } #my-content table:first-child tr td:nth-child(2){ width: 240px; } /* line items */ #my-line-items thead tr th{ color: #777; text-align:right; text-transform: uppercase; vertical-align: bottom; border-bottom: 1px...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  9. ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

    as an adjustment with the description "Rounding Off": v_TotalAdjustments = 0.00; for each m_ZCrm_LineItem in l_ZCrm_LineItems { v_ListPrice = ifnull(m_ZCrm_LineItem.get("List_Price"),0); if(v_ListPrice.toString().contains(".")) {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  10. 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

    Joomla v2.5.x database and website files Note the CURRENT super user identification number "ID" and alias (name) Ensure all items are "checked-in" (Do a "Global Check In") Install new Joomla: Install Joomla! CMS v3.4.x with Demo Content (eg. 3rd-party...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  11. SSRS Hide results table if emptyhttps://www.joellipman.com/component/content/article/ssrs-hide-results-table-if-empty.html?catid=75&Itemid=165

    like: =IIF(Sum(Fields!Counter.Value, "Equipment")>0, True, False) If you're bugged by the warning "Overlapping report items are not supported in all renderers" then I'd suggest you use method #1. Issues I ran into: I replaced the empty dataset with the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  12. SSRS Stop Scrolling Behindhttps://www.joellipman.com/component/content/article/ssrs-stop-scrolling-behind.html?catid=75&Itemid=165

    mode is switched on as per the following image: Cycle through each static object and set FixedData to False (ensure all items are set to false or it will error): Save and test on the ReportServer. Background: If you need to visualize how I could have...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  13. Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/else/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

    that in my test, there was only 1 user (me). There are reports though that some people set up websites with NO 3rd-party items whatsoever... For those of you with this issue, I'd double-check your website host allows Joomla and if they don't, look for...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  14. Excel PivotTable Filter List Orderinghttps://www.joellipman.com/component/content/article/excel-pivottable-filter-list-ordering.html?catid=110&Itemid=165

    (or name of field) from the dropdown. (NOTE the "More Options" button) Click on OK to sort the values Note: Office 2010: If items did not sort, then remove the column from the PivotTable altogether, hit the Data Refresh button Add the column back to the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  15. Is it a scam? Gumtree.com's warning signshttps://www.joellipman.com/component/content/article/is-it-a-scam-gumtreecoms-warning-signs.html?catid=116&Itemid=165

    Cheque overpayment. A buyer, prospective tenant or even an employer will send you a cheque worth more than the value of the items/rent/job. They’ll then ask for the surplus money to be returned to them or a third party, for example ‘to pay for...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  16. Passwords: Did-you-knowhttps://www.joellipman.com/component/content/article/passwords-did-you-know.html?catid=116&Itemid=165

    following is a list of items I use to include on password checker pages: A program called LC4 (formerly L0phtCrack) used by governments and the military boasts being able to crack 90% of user passwords in under 48 hours on a Pentium II/300....

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  17. Zoho Deluge - Store and repopulate a multi lookup list in Creatorhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-store-and-repopulate-a-multi-lookup-list-in-creator.html

    } // // restore item in lookup input.myLookup = l_RememberLookup; // // repopulate lookup options (not selected items) for each r_EntryID in l_AllowedEntries { input.myLookup:ui.add(r_EntryID); } Additional Note(s): If removing elements, even if you are...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
Results 41 - 57 of 57