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

  1. Zoho Inventory: Mark a package slip as delivered and shippedhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-mark-a-package-slip-as-delivered-and-shipped.html

    own ZohoBooks/ZohoInventory Org ID v_BooksOrgID = 123456789; // // check the form was ticked and there is a package ID specified if(input.Mark_as_Complete && input.Zoho_Package_ID != "") { v_PackageID = input.Zoho_Package_ID; r_PackageSlip =...

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

    == null] sort by Added_Time desc range from 0 to 100; for each c_Appt in l_Appointments { // // get package references specified in a previous multi-line text field l_PackageRefs = c_Appt.Associated_Package_Slips1.toList(); // // important to declare...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. ZohoAnalytics: Pivot Campaigns vs Contactshttps://www.joellipman.com/articles/crm/zoho/zohoanalytics-pivot-campaigns-vs-contacts.html

    cp."Contact Id"=c."Id" Caveat(s) You may have noted a few caveats with this solution: This query needs each campaign name specified to see the results per contact person. You can only use this in another dataset which won't use a sub-query more than 2...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. ZohoCRM: Get Organization Business Hours using Deluge/APIhttps://www.joellipman.com/articles/crm/zoho/zohocrm-get-organization-business-hours-via-deluge-api.html

    function cannot be applied: Possibly due to me trying to create and declare the subform before having specified any record to insert it into. Expecting ZC_SUBFORM_109 expression found COLLECTION expression: I may have tried to make a subform equal the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. Zoho Deluge: Get All Orders from eBayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-all-orders-from-ebay.html

    GetOrders call for order (sales) management. /* Function: fn_GetEbayOrders() Purpose: Queries eBay for all orders for a specified year Date Created: 2023-03-29 (Joel Lipman) - Initial release Date Modified: 2023-03-29 (Joel Lipman) - Added in ability to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  6. ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://www.joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

    number and carrier to shipment record on either creation or modification. - Only creates shipment order if shipped time is specified. - Only marks shipment as delivered if DHL API checked and status returned is delivered Date Modified: 2023-03-22 (Joel...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  7. Zoho CRM: ZDK Client Script: Auto-Select Pipeline based on User Departmenthttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zdk-client-script-auto-select-pipeline-based-on-user-department.html

    A super quick article on how to pre-select the pipeline on deal creation within CRM based on the department specified on a user's profile. Why? A client asked that when staff create a deal/opportunity record in CRM, the pipeline is automatically...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

    hash in the URL (after "/folders/") For this function, I have a connection called "zworkdrive" which has the scopes as specified in the function header. Also note, that this Zoho instance is in the EU datacenter (zoho.eu) rather than the US datacenter....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. ZohoCreator: Basic Widget with Zoho Datahttps://www.joellipman.com/articles/crm/zoho/zohocreator-basic-widget-with-zoho-data.html

    URL - Cannot use window.location URL var queryParams = ZOHO.CREATOR.UTIL.getQueryParams(); // Check parameters were even specified if (queryParams.p_ShopifyEmail !== undefined) { v_ShopifyEmail = queryParams.p_ShopifyEmail; } if (queryParams.p_ShopifyID...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. Zoho Books / Inventory: Get Item Rate from a Price Book/Listhttps://www.joellipman.com/articles/crm/zoho/zoho-books-inventory-get-item-rate-from-a-price-book-list.html

    domain change. The use-case is that the customer wants the item/product rate taken from the item record, if a pricebook is specified and the item exists within it, then it takes the rate from the pricelist. Note that when I refer to pricebook, this is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. Prices get rounded up in Virtuemarthttps://www.joellipman.com/articles/ecommerce/virtuemart/prices-get-rounded-up-in-virtuemart.html

    After modifying tax rates and ensuring these were all the same, we also found that this was due to a country not being specified under the Store configuration within VirtueMart.

    • Type: Article
    • Author: Joel Lipman
    • Category: Virtuemart
    • Language: *
  12. Change Regional Settings for your Reporthttps://www.joellipman.com/articles/microsoft/ssrs/change-regional-settings-for-your-report.html

    a MS SQL Server 2008 instance were dependent on either the server or the client machine. Realised that this was actually specified in the report. Here's a quick note on how to set Dates and Times used in parameter fields to UK format (dd/MM/yyyy). You...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  13. MySQL Commands to display all columnshttps://www.joellipman.com/articles/database/mysql/mysql-commands-to-display-all-columns.html

    BY TABLE_NAME, COLUMN_NAME The following is a MYSQL query that finds all columns that had the data_type TEXT across a specified database (eg. sample_db): SELECT CONCAT(TABLE_NAME, '.', COLUMN_NAME) AS value FROM information_schema.COLUMNS WHERE...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  14. SSRS Expand specific drilldown by defaulthttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-expand-specific-drilldown-by-default.html

    specify the date as it's a report parameter. What we want The user will select a date. We want the report to open with the specified day expanded and the remaining days that week to be collapsed (hidden). The first time I did this, I couldn't expand the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  15. SSRS Repeat Headers in PDF Reporthttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-repeat-headers-in-pdf-report.html

    the box "Repeat header columns on each page. Situation I have a report which has been set to landscape with zero margins specified. Although BIDS acknowledges that I want this to output to A4 with the correct measurements, the report doesn't seem to...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  16. CSV Chart Generatorhttps://www.joellipman.com/component/content/article/csv-chart-generator.html?catid=40

    and I myself don't put any copyright information on the end product. I needed a program to: + Group all the data by a specified column + Generate interactive flash charts The program was intended to chart EventViewer "Security" logs but I quickly found...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  17. Joes Chart Generator (JCG) Downloadshttps://www.joellipman.com/component/content/article/joes-chart-generator-jcg-downloads.html?catid=92

    VersionPlatform ChangeLogOptions1.0+ Group all the data by a specified column + Generate interactive flash charts - Date Uploaded: Wed, 15th Sep 2010 Download

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
Results 61 - 77 of 77

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.