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

  1. ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

    about an order and then creates item/contact/sales order/package slip/invoice (if not exist) Date Created: 2022-05-05 (Joel Lipman) - Initial release Date Modified: 2023-01-23 (Joel Lipman) - Revamp of code - Only generate invoice if payment received -...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. Terms & Conditionshttps://joellipman.com/static-items/terms-conditions.html

    REGISTRATION Joel Lipman .Com reserves the right to change the username you choose upon registration. This is to help other registered users to distinguish between official Joel Lipman .Com website administrators and other registered members. WEBSITE...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  3. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://joellipman.com/articles/crm/zoho/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

    describe this might be better explained if you consider the following snippet of code: // sample data v_Test = "00011,Joel Lipman,\"Flat 8, House Corner\",Brummieland"; // regex to replace a comma found between 2 double-quotes to a string of your choice...

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

    Contact Record ID Outputs: Attachment to the CRM record a ZohoSign Document record in CRM Date Created: 2024-08-06 (Joel Lipman) - Initial release - Tidied up, removed commented code - Added Email and Account mapping to ZohoSign Document record Date...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. T-SQL: Parse an XML valuehttps://joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

    a row. How? Assuming the following data exists in the column "Event_XML" value of the table "XML_EVENTS": 123456 Mr J JOEL LIPMAN MALE 1990-01-01 SUPER SUPPORT TEAM GENERAL DOGSBODY 2014-03-01 Y INSERT 2014-03-27 Extracting the Gender: We're going to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  6. Privacy Policyhttps://joellipman.com/static-items/privacy-policy.html

    This privacy policy sets out how Joel Lipman .Com uses and protects any information that you give Joel Lipman .Com when you use this website. Joel Lipman .Com is committed to ensuring that your privacy is protected. Should we ask you to provide certain...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: en-GB
  7. Zoho Webhooks & Shopify API: Keep Disappearinghttps://joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

    sent to ZohoCRM (Order Update) Inputs: String crmAPIRequest Outputs: String crmAPIResponse Date Created: 2022-01-17 (Joel Lipman) - Initial release - Forwards webhook to Zoho Creator Date Modified: 2024-04-22 (Joel Lipman) - Minimized amount of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. ZohoCRM GetRelatedRecords INVALID_DATAhttps://joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

    records which are clearly visible when using the CRM. The cause of the problem is the same as covered in my article Joel Lipman - ZohoCRM: zoho.crm.searchRecords only returns certain records. Consider the following code: /*...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. Disclaimerhttps://joellipman.com/static-items/disclaimer.html

    The information contained in this website is for general information purposes only. The information is provided by Joel Lipman .Com and while we endeavour to keep the information up to date and correct, we make no representations or warranties of any...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  10. T-SQL concatenate an incremental row numberhttps://joellipman.com/articles/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

    following two tables exist: TABLE: Employee -------------------------------------------------- ID FirstName Surname 1 Joel Lipman 2 Another Joe TABLE: Qualifications -------------------------------------------------- ID Employee Subject Grade 1 001...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  11. Zoho Deluge: Convert Map to HTML Table without a FOR loophttps://joellipman.com/articles/crm/zoho/zoho-deluge-convert-map-to-html-table-without-a-for-loop.html

    is a HTML table now with the headers and data but without using a for loop. What I have: {"First_Name":"Joel","Last_Name":"Lipman","id":"1"},{"First_Name":"Another","Last_Name":"Person","id":"2"} What I want: First NameLast NameID JoelLipman1...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  12. Zoho Creator: Receive eBay Order Notifications via Webhookhttps://joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

    Purpose: Retrieves the requesting application's notification preferences Date Created: 2021-09-20 (Joellipman.com - Joel Lipman) - Initial release More Info: - API Explorer Test Tool:...

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

    the same time retain the context of ZohoCRM Inputs: string userInput Outputs: map m_Response Date Created: 2023-02-08 (Joel Lipman) - Initial release - Queries OpenAI ChatGPT Date Modified: 2023-03-11 (Joel Lipman) - Stores conversation messages /...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. Zoho Analytics & Zoho People: Monitor DataSource Sync https://joellipman.com/articles/crm/zoho/zoho-analytics-zoho-people-monitor-datasource-sync.html

    if a sync started failing. Inputs: None Outputs: Emails system manager if any failures. Date Created: 2024-07-02 (JoelLipman.com - Joel Lipman) - Initial release Date Modified: ??? - ??? More Information:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. ZCRM Client Script: Correct Decimal Fields OnLoadhttps://joellipman.com/articles/crm/zoho/zcrm-client-script-correct-decimal-fields-onload.html

    without changing this. This script will round up decimal fields onload. Inputs: - Outputs: - Date Created: 2023-12-13 (Joel Lipman) - Initial release - Correctly rounds any decimal fields to their maximum decimal place. Date Modified: ??? - ???...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  16. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

    following a punctuation symbol, have the UPPERCASE applied: eg. "Andrew Lloyd-Webber", "Marketing Manager (Acting)", "Lipman***Test" or "R&D". As well as alphanumeric values such as "Flat 4B", "Suite 4899A", "123A Myhouse". Example #2: Using as a Custom...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  17. SSIS Multiple Lookups in onehttps://joellipman.com/articles/microsoft/ssis/ssis-multiple-lookups-in-one.html

    ------------------------------- ------------------------------- -------------------------- 0000000001 1234567 MR Joe Lipman M 726 5826 000 39 0000000002 0987654 MAJ Big Bird M 771 771 771 15 The one lookup task: Changing the lookup to "use results of an...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  18. Zoho Deluge: Setup an API Connection for InvokeURLhttps://joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

    Client Name: put something descriptive so it is easy to identify if the client has 3rd-parties adding clients. eg. "JoelLipman_BooksConnector". Homepage URL: put our corporate website URL, this is for developers who need to query what this app belongs...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  19. Zoho Creator/Deluge: Calculating with Timezone Offsethttps://joellipman.com/articles/crm/zoho/zoho-creator-deluge-calculating-with-timezone-offset.html

    = v_ResultInformation.concat(" "); input.Note_BookedTimeSelection = v_ResultInformation; Source(s): Joel Lipman: Zoho Deluge: Generate List of TimeZones Joel Lipman DataSources: Time zones supported by Zoho (MS Excel file) Wikipedia: Daylight saving...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  20. Zoho Deluge: Calculate start and end of Daylight Savings Timehttps://joellipman.com/articles/crm/zoho/zoho-deluge-calculate-start-and-end-of-daylight-savings-time.html

    correctly. I use these to store the values in a table that can be double-checked at a later date. Source(s): Joel Lipman: Zoho Deluge: Generate List of TimeZones Joel Lipman DataSources: Time zones supported by Zoho (MS Excel file) Wikipedia: Daylight...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 1 - 20 of 641

Please publish modules in offcanvas position.