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

  1. Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

    into a table with labels and columns that can help me group them (and identify which responses belong to which survey attempts). Then I'll write the SQL to sum up the responses per page per survey attempt. Finally, I'll see if analytics can be used to...

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

    */ // freezes the GUI? ZDK.UI.freeze(true); // attempt try { // taken from stackoverflow: https://stackoverflow.com/questions/17369098/simplest-way-of-getting-the-number-of-decimals-in-a-number-in-javascript var fn_CountDecimals = function(value) { if...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. Connection Strings for SQL Serverhttps://www.joellipman.com/component/content/article/connection-strings-for-sql-server.html?catid=78&Itemid=165

    command timeout=20; This option is available from Connector/NET version 5.1.4. Specifying connection attempt timeout Use this one to specify the length in seconds to wait for a server connection before terminating the attempt and receive an error....

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

    • Type: Article
    • Category: Static Items
    • Language: *
  5. Licence GNU/GPLhttps://www.joellipman.com/component/content/article/licence-gnugpl.html?catid=50&Itemid=165

    way. 8. Termination. You may not propagate or modify a covered work except as expressly provided under this License. Any attempt otherwise to propagate or modify it is void, and will automatically terminate your rights under this License (including any...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  6. Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-generate-5-letter-booking-retrieval-code.html

    // loop through times you will chance it for each v_TimeTried in l_TimesTried { // init b_BadWordFound = false; // get attempt v_Output = thisapp.generateRetrievalCode(); // see if can use contains but check for word for each v_BadWord in l_BadWords {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  7. Zoho Creator: Retrieve record with case-insensitive queryhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-retrieve-record-with-case-insensitive.html

    search to see if the product exists is case-sensitive, but when trying to insert the product, it is case-insensitive. How? Attempt 1 to lowercase both sides of the operation in the record retrieval also fails:... l_ProductDetails =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  8. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

    check your CRM record it will have these under "attachments" Setup a Zoho Oauth Connection So that we can use invokeUrl and attempt the REST via API (see what I did there?), we need a Zoho Oauth2 connection in Zoho Books. In Zoho Creator, go to Setup (3...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  9. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-inventory-upload-image-to-item-record.html

    [ url :v_Url type :POST files:r_DownloadedPhoto connection:"joel_books" ]; // output response to console info "Response of attempt to upload to Zoho Inventory:"; info r_UploadPhoto; You should get a response similar to the following:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. ZohoCRM: ZDK Client Script to retrieve Contact Emailhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-zdk-client-script-to-retrieve-contact-email.html

    I can't get a formula field to retrieve a field from another CRM record. // freezes the GUI? ZDK.UI.freeze(true); // attempt try { // get the ID from the lookup field called "Vendor Contact" var v_VendorContactID =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  11. 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

    layout if you want. Under Event Details, set Type=Page Event; Event=onLoad Click on "Next" Give it the following code: // attempt try { // get the ID of this record var v_ThisRecordID = $Page.record_id; // get the full name of this contact (not sure why...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  12. Zoho CRM: Remove Duplicate Product Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-remove-duplicate-product-records.html

    this is using COQL to sort the records and tries to keep the first version of the record (sorted by ID ascending) and will attempt to delete the other records which match on product name. I would recommend commenting out the delete commands and leaving...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  13. ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

    Any information that may help ******************************************************************************* */ // attempt try { // get the type of invoice selected var v_InvoiceType = ZDK.Page.getField('Invoice_Type').getValue(); // check source quote...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  14. Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

    output = r_SubData?.details?.output; // If the output is JSON text, parse it into a real object let parsedOutput; try { // Attempt to parse the output as JSON parsedOutput = JSON.parse(output); } catch (e) { // If parse fails, just fall back to plain...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  15. Things to Check if Joomla Password Reminder email not being senthttps://www.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

    works. Check your cookie policy: Open a browser which allows cookies, and one that does not. Visit your site with both and attempt the password change.

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  16. SSRS External Images don't displayhttps://www.joellipman.com/component/content/article/ssrs-external-images-dont-display.html?catid=75&Itemid=165

    within SSRS When previewing the report in BIDS, the photo appears fine. If we deploy the report to our Reporting Server and attempt to view it using a Web-Browser, the image does not display: Get report to see images hosted on an external URL Check if...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  17. Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/else/database/t-sql/convert-to-proper-case-in-t-sql.html

    T-SQL and we're going to use a function so no dynamic SQL (execute, evaluate). Method #1: First version This was my first attempt based on snippets around the web. This one has two sections, the first part capitalizes any letter after a non-alpha...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  18. Basic Oracle Function Structurehttps://www.joellipman.com/articles/else/database/oracle-pl-sql/basic-oracle-function-structure.html

    I need to refer to how to create a function in Oracle PL/SQL and sites on the net just attempt to overcomplicate everything and have forgotten how it is to be new to Oracle. I need a function in it's simplest form and if I want to torture my successors,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
Results 1 - 18 of 18