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

  1. Zoho Survey: Zoho CRM Webhookhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-survey-zoho-crm-webhook.html

    email Date Modified: 2025-10-06 (Joel Lipman) - Clients wants a public URL for Survey: Need this webhook to create contact/account on-the-fly if needed. More Information: Within Zoho Surveys, configure the webhook to return the Response ID, Email, and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. GDPR Privacy Policyhttps://joellipman.com/component/content/article/gdpr-privacy-policy.html?catid=50&Itemid=165

    • Type: Article
    • Category: Static Items
    • Language: *
  3. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirectshttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-two-submit-buttons-on-a-non-stateless-form.html

    existing record if(!isnull(input.ID)) { //... code to update existing record r_Details = myForm[ID == input.ID]; r_Details.Account = input.Account.toLong(); } else { //... code to create new record r_NewRecord = insert into [ = = = ]; } Done:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  4. ZohoBooks: Stripe Terminal Integrationhttps://joellipman.com/articles/crm/zoho/zoho-books/zohobooks-stripe-terminal-integration.html

    } } // // create payment record if(v_ZB_InvoiceID != 0) { // // get ZohoBooks nominal account for Stripe v_NominalAccountID = ""; r_ChartOfAccounts = invokeurl [ url :"https://www.zohoapis.com/books/v3/chartofaccounts?organization_id=" + v_BooksOrgID...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  5. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://joellipman.com/articles/crm/zoho/zoho-books/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

    } // // ---------------------- DETERMINE ZOHOBOOKS CUSTOMER ID ---------------------- if(!isnull(r_QuoteDetails.get("Account_Name"))) { v_AccountID = r_QuoteDetails.get("Account_Name").get("id"); r_SearchResults =...

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

    or use the existing one as long as it hasn't expired. Update 2019 This script requires a user to authenticate the google account. I have a newer article called Google Drive API v3 - OAuth2 using Service Account in PHP/JWT documenting a script which...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  7. Problem creating SSRS report subscriptionshttps://joellipman.com/component/content/article/problem-creating-ssrs-report-subscriptions.html?catid=75&Itemid=165

    Select "Data Sources" in the left menu Specify a "custom data source" and test the connection. Ensure unattended system account scheduled to run and email the report can access the datasource (ask a DBA if you're unsure). Shared DataSource Upload the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  8. Hide a Drive per User in Windows 7https://joellipman.com/component/content/article/hide-a-drive-per-user-in-windows-7.html?catid=80&Itemid=165

    to the user you are running Regedit as! (So if logged in as Admin, this hides it from the Admin, but not from the Guest account) To only restrict Guest or a Specific User: So undo the above if you didn't want this applied to the current logged-in user...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  9. Zoho CRM/Creator - Common Errors & Gotchashttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-creator-common-errors-gotchas.html

    in the URL and then updating your app with the same value, such as: // for Books OAuth 2.0 Connection - Custom Service - on account server EU https://dre.zoho.eu/delugeauth/callback // for Books OAuth 2.0 Connection - Custom Service - on account server...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

    edit the code for the "Message Handler" Get an OpenAI API Key Login to OpenAI Browse to https://platform.openai.com/account/api-keys Click on "Create a new key" Copy & paste into a text editor for use in the code below Edit the Message Handler code...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  11. Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    field) Re-build/Auto-correct some Joomla inconsistencies Login to your Joomla Admin Panel using a System Administrator account ("Super User"?) Go to Categories > click on the "REBUILD" icon (top right) Go to Menus > click on the "REBUILD" icon (top...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  12. Split a row into multiple rows based on a column valuehttps://joellipman.com/articles/else/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

    002 1.00 2000-02-19 002 1.00 2000-02-20 003 1.00 1999-02-25 003 1.00 1999-02-26 -- note the dates increment and do not account for days off (eg. Saturday / Sunday) How? Adapted from a forum topic: SQLTeam Forums First of all, we want the rows to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  13. Amazon Kindle: Send PDFs to your Kindlehttps://joellipman.com/component/content/article/amazon-kindle-send-pdfs-to-your-kindle.html?catid=121&Itemid=165

    applies to your region. Sign in with your Amazon username and password. After you have logged in, look for the menu option Account and Lists which should show somewhere along the top right of the home screen. Under Account and Lists, look for Your...

    • Type: Article
    • Author: Joel Lipman
    • Category: Kindle
    • Language: *
  14. Zoho CRM: Schedule a Task: Timesheet Reminderhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-schedule-a-task-timesheet-reminder.html

    code that creates a task in CRM based on the time logged against an Event/Meeting. Why? As developers, we're keep account of our time and we are currently logging time in our CRM. We're meant to do 40 hours, not just for Management, but for deducting...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  15. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://joellipman.com/component/content/article/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html?catid=138&Itemid=165

    Zoho’s developer console to get your Client ID and Client Secret. (Login as the client super admin or ascentcloud admin account) Log in to https://accounts.zoho.com/developerconsole Click on Add Client ID Select "Self Client" Provide the details and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Sign
    • Language: *
  16. Zoho Books: System Values Mapshttps://joellipman.com/articles/crm/zoho/zoho-books/zoho-books-system-values-maps.html

    of code to get dynamic maps of system values Purpose: Taxes, Currencies, Payment Terms, Sales Persons, and Nominal Accounts Inputs: - Outputs: - Date Created: 2021-09-24 (oel Lipman) - Initial release Date Modified: 2024-05-21 (Joel Lipman) - Change of...

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

    user with the necessary scopes to this CRM instance, untick use credentials of logged-in user, and authorized as the system account (a separate Zoho user we have named SYSTEM ADMIN); this reduces the amount of blame on the system manager believed to be...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  18. Setup a copy of your Joomla websitehttps://joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

    I used based on the services available to my client: Copy all files of your main website to another folder. Setup an FTP account to the new folder created in the previous step. Copy the database of your main site to another database. Setup a database...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  19. Registered Users Cannot Login - Super Users Canhttps://joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

    be able to login, despite their status in the admin panel saying "enabled" and "activated" (not blocked). If I used a test account, none of the Joomla groups, not even "Administrators" could login. However set the same test account to a "Super User" and...

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

    the function is being applied to a NULL date timestamp. Dealing with Date NULLs: Fix: Put conditional statements to account for NULLs. -- Standard TRIM(This_Date) == "" ? NULL(DT_DATE) : (DT_DATE)This_Date -- if data source column is of datatype string...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
Results 21 - 40 of 88