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

  1. ZohoDeluge: Check Shipment Status via DHL APIhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zohodeluge-check-shipment-status-via-dhl-api.html

    = leftpad(" ",v_DaysAgo).replaceAll(" ",",").toList(); // // loop through for each index v_Index in l_GeneratedList { // output to developer for debug purposes v_Date = zoho.currentdate.subDay(v_Index).toString("yyyy-MM-dd"); info v_Date; // // set...

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

    a fresh instance of Zoho Inventory. In this task, we are simply getting a CSV with all the order IDs for a particular year output as a spreadsheet. How? Similar to how we retrieved the eBay active listings (see article link above), we're going to use...

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

    v_OrderDate = zoho.currentdate.toString("yyyy-MM-dd"); v_Page = 1; v_PerPage = 10; m_Output = Map(); l_Costs = {11,13,15,17,20}; b_DebugMode = true; l_DebugMessages = List(); l_DebugMessages.add("eBay Order ID: " + p_eBayOrderRef);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Inventory
    • Language: *
  4. Zoho Creator: Find Duplicates by Customer Name for Large Datasetshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-find-duplicates-by-customer-name-for-large-datasets.html

    + v_Grammar + " are duplicates!"; // // return a distinct list l_Customers2.removeAll(l_Customers1); // // loop through and output to user for each v_DistinctCustomer in l_Customers2 { v_CountDiscrepancies = v_CountDiscrepancies + 1; c_Customer =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  5. Zoho CRM: Client Script Confirmation Box and Popup Mailerhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-prompt-and-popup-mailer.html

    error (don't display it, just show it in the logs) console.log(e); //ZDK.Client.showMessage("Client Script error"); } Output Source(s): Zoho CRM Community - Kaizen #71 - Client Script ZDKs for Detail (Canvas) Page

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  6. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

    1 day send an email and notification to sales person everyday for 3 days then escalate to Dan Inputs: The Lead Record ID Outputs: A task with a daily reminder until after 3 reminders Date Created: 2024-05-13 (Joel Lipman) - Initial release Date...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  7. ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

    To display related POs linked by a custom Sales Order lookup field on the Purchase Order line item. Inputs: salesorder Outputs: Related List Date Created: 2024-07-09 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Information:...

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

    by a button off the contact record to send a credit application form for signing via ZohoSign Inputs: Contact Record ID Outputs: Attachment to the CRM record a ZohoSign Document record in CRM Date Created: 2024-08-06 (Joel Lipman) - Initial release -...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  9. Zoho Deluge: Nested Catch Statementshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-nested-catch-statements.html

    a doomed conversion from string to integer; I've applied this to an actual invokeURL command rather than just an info output. try { r_GeneratePDF = invokeurl [ url: v_EndpointServer1 type: POST parameters: m_Html headers: m_Headers1 ]; } catch(e) { try...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  10. ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

    / REST API Purpose: Function used by a client script to retrieve the pipeline given a deal record id Inputs: Deal Record ID Outputs: the value of the pipeline Date Created: 2025-05-06 (Joel Lipman) - Initial release Date Modified: ??? - ???...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  11. PHP Script: Make your own Thumbnail Generator via APIhttps://www.joellipman.com/articles/cms/website-development/php/php-script-make-your-own-thumbnail-generator-via-api.html

    article is for me if I ever want to recreate an online tool capable of receiving an image URL and which both generates and outputs a thumbnail image and makes it downloadable via URL. Why? Performance. I have a client with about 10k images of products...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  12. Setup a copy of your Joomla websitehttps://www.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

    (ie. Fast & Reliable) Compress/backup LIVE files to ZIP file. Export LIVE database to SQL file. (Export > Custom > Save output to file) Except for configuration.php, delete all files in TEST folder. Drop all tables in TEST database. Copy all files from...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  13. Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/component/content/article/google-authentication-oauth-2-0-using-php-curl.html?catid=61&Itemid=165

    return $credentials; } Include the following at the end of all of this and to execute the functions but before any outputs (HTML or JS): $credentials = authenticate(); To view these or output to screen: print_r($credentials); Worthwhile Note(s) Allowing...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  14. Mediawiki Extension for Camtasia Studio SWF videoshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

    doing your video Go to File > Produce Video As... > Custom production settings > Next Select 'Flash (SWF/FLV) - Adobe Flash Output' > Next ExpressShow (complete optional settings) > Next Video Info (complete optional settings) > Make sure "Embed Video...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  15. SSIS Convert a string into a datehttps://www.joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    "Extract dates from string dates" (3614)" failed because error code 0xC0049064 occurred, and the error row disposition on "output column "DC_This_Date" (3833)" specifies failure on error. An error occurred on the specified object of the specified...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  16. Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/component/content/article/returning-oracle-stored-procedure-resultset-in-ssrs.html?catid=75&Itemid=165

    TO my_ssrs_user; Notes: No "SELECT... INTO..." on the second query which is the one that will return my columns. Two output fields are expected to be returned: "p_STUDENT_DETAILS" and "p_STUDENT_REF". 2. Add a datasource Nothing different to your...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  17. Search a database with SOUNDEXhttps://www.joellipman.com/articles/else/database/search-a-database-with-soundex.html

    characters in a variable (so I couldn't store it in a local variable). So the idea here is to run the below example which outputs a huge SQL query which you then copy & paste and run against your database. Step 1 of 2 The following stored procedure will...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  18. T-SQL DateTimestampshttps://www.joellipman.com/articles/else/database/t-sql/t-sql-datetimestamps.html

    06:00:00:000AM I originally got a list from databases.aspfaq.com but the convert numbers didn't correspond to the output formats. This is my list created within my environment and setup (see above).

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  19. DataTumble - Randomize Data Rowshttps://www.joellipman.com/articles/else/database/t-sql/datatumble-randomize-data-rows.html

    the column to be scrambled ** ** @WhereClause : Condition to get the set of Data to be scrambled. Can be null ** ** ** ** Outputs: ** ** The Data in @ColumnName column will be scrambled ** ** ** ** Return Values: ** ** None ** ** ** ** Before: ** ** ID...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  20. T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/else/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

    #2 So when the above has been addressed or we've tried casting as varchars all over the place, check the value that gets outputted is also a literal string. So here's some ok code but it will fail if my reference data has a non-numeric value in it: --...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
Results 61 - 80 of 89