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

  1. ZohoCreator: Basic Widget with Zoho Datahttps://joellipman.com/articles/crm/zoho/zoho-creator/zohocreator-basic-widget-with-zoho-data.html

    !== undefined) { v_ShopifyID = queryParams.p_ShopifyID; } // Setup a config to find this record (use a custom report that only has the 2 searchable fields) var config = { appName : "joes_quote_builder", reportName : "Contacts_Report_SearchableByWidget",...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  2. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

    Off a button on the maintenance record Purpose: Function used by button off maintenance record to send a Maintenance Report to the customer contact. Inputs: Record ID Outputs: Attachment to the CRM record Date Created: 2024-08-07 (Joel Lipman) - Initial...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. MS Excel - Sort pivottable column headings by datehttps://joellipman.com/component/content/article/sort-pivottable-column-headings-by-date.html?catid=110&Itemid=165

    Excel 2010 with the projects down the left (in the first column) and the days of the week along the top. Why? The excel report would hit a bug where it couldn't work out that 10 (Wednesday) happened after 8 (Monday). How? See the following screenshot...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  4. Zoho People and Zoho Analytics: Push all Employee Salary Data to Analyticshttps://joellipman.com/articles/crm/zoho/zoho-people/zoho-people-and-zoho-analytics-push-all-employee-salary-data-to-analytics.html

    an objective is created or edited. Purpose: Pushes the data and columns we need to Zoho Analytics to produce an Objectives report with the requested columns. Inputs: int p_RecordID Outputs: - Date Created: 2026-03-26 (Joel Lipman) - Initial release Date...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  5. SSRS Templates in BIDS 2008https://joellipman.com/component/content/article/ssrs-templates-in-bids-2008.html?catid=75&Itemid=165

    Open a Windows Explorer and make a duplicate of the report that you want to use as a template. Rename the copy (suffix with template?) Remove objects unique to the report and leave elements for all reports. File > Save selected item as... For SSRS...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  6. MS-DOS: Copy folders without overwriting fileshttps://joellipman.com/component/content/article/ms-dos-copy-folders-without-overwriting-files.html?catid=51&Itemid=165

    Be Defined (retry error 67). :: :: Logging Options : :: /L :: List only - don't copy, timestamp or delete any files. /X :: report all eXtra files, not just those selected. /V :: produce Verbose output, showing skipped files. /TS :: include source file...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  7. Quadcopter App with Flight Restrictions (JQA)https://joellipman.com/component/content/article/quadcopter-app.html?catid=53&Itemid=165

    distance/duration - Pilot: view top rated equipment - Pilot: rate other configurations (looks and performance) - Pilot: report a location as restricted or recommended for flying - Pilot: know a flight club? send us the details. - Pilot: start stop log...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  8. Zoho Deluge - Counting in a Map dataTypehttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-counting-in-a-map.html

    number of products allocated to an account or in total for a purchase order. Let us assume we have the following in a form/report called "Stock_Upload": RowID Name SKU Account Email 0001 Test Product 1 TEST001 test1@joellipman.com 0002 Test Product 1...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  9. Zoho Creator: Expecting ZC_SUBFORM_250 expression found COLLECTIONhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-expecting-zc-subform-250-expression-found-collection.html

    ); Events I have used this task which contradicts documentation: In a custom function In an Action item in Report In a schedule workflow Source(s): Zoho Creator - Insert rows in Subform (via Deluge Script)

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  10. Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Divhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-page-toggle-on-off-switch-hide-display-a-div.html

    how to create an on/off toggle switch that hides and displays between 2 div layers in a Zoho Creator Page (so not a form or report but a page). Why? This is written at a time when Javascript or interactive pages that change on the fly based on a mouse...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  11. Zoho Creator: Receive JSON via a Shopify Webhookhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-receive-json-via-a-shopify-webhook.html

    with joels_creator Give it a lowercase Connection Link name Select the scopes: ZohoCreator.form.CREATE and ZohoCreator.report.CREATE Click on Create and Connect > Note the connection link name (if you've already forgotten) Create a REST API Zoho CRM...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  12. Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name)https://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-bookings-full-name-appears-in-last-name.html

    A quick article to explain why the full name might appear in the last name field in Zoho CRM. Why? We had a customer report the issue that sometimes the full name of a contact was appearing in the last name field and creating a contact called "Firstname...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  13. Zoho CRM: Upload a Product Photo using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-upload-a-product-photo-using-deluge.html

    use another invokeUrl to upload the photo to CRM: // init v_AppOwner = "joel_the_awesomest"; v_AppName = "joels_app"; v_ReportName = "My_Report"; // specify your CRM record ID for this product v_CrmProductID = 1234567890123456789; // specify your...

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

    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. How? We would think it similar to a picklist/dropdown where you simply add an option to the picklist and then specify...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  15. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://joellipman.com/articles/crm/zoho/zoho-recruit/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

    This article is just in case it comes up again (has twice now) where a client wants a report on candidates and associated job openings in Zoho Recruit. Why? We're creating a custom module where our client wants to query Zoho Recruit via the API but...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Recruit
    • Language: *
  16. ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-integrate-chatgpt-to-zohozia.html

    standards. - OpenAI ChatGPT BBC News: ChatGPT bug leaked users' conversation histories 2023-03-23 PCMag UK : ChatGPT Users Report Seeing Other People's Conversation Histories [...report the payment page for ChatGPT Plus possibly exposing email addresses...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  17. Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttps://joellipman.com/articles/crm/zoho/zoho-books/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

    Function: void ZohoBooks.fn_SendZohoBooksInvoice(int p_OrderID) Trigger: On Demand when button in report is clicked Purpose: This will send a ZohoBooks invoice directly to its recipient Inputs: Zoho Creator record ID of the order Outputs: - Date...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  18. Zoho Analytics: Create a Monitoring System with Imageshttps://joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-create-a-monitoring-system-with-images.html

    the monitoring system. Preferably use the workspace that has the data to check. For demo purposes, I'm going into the CRM Reports workspace > Click on "Create" > Then select "Dashboard": Then in the top right of the dashboard, I'm going to click on the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  19. Include a carriage return in a column headinghttps://joellipman.com/component/content/article/include-a-carriage-return-in-a-column-heading.html?catid=78&Itemid=165

    might seem trivial but these little aesthetic changes done at the database level can save some time. Why? I have an Excel report which dynamically gets its content from a data source located on a database on the other side of the world. I want the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  20. Formatting a date in an MDX queryhttps://joellipman.com/articles/else/database/t-sql/formatting-a-date-in-an-mdx-query.html

    =FormatDateTime(Fields!BirthDate.Value, DateFormat.ShortTime) Unfortunately if you are using US dates and want the report to use a specific European date format and you spend as long as I did searching the web for a solution, then ignore all the above....

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
Results 61 - 80 of 92