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

  1. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

    v_DataCSV = "1,Joel Lipman,Kings Castle,England\n"; v_DataCSV = v_DataCSV + "11,General Dogsbody,\"Flat 8, House Corner, My Street\",Brummieland\n"; v_DataCSV = v_DataCSV + "64,Elephant Man,\"123 New Street,\nNew York City\",USA\n"; f_CSVfile =...

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

    // // initialize v_BooksOrgID = 123456789; v_BooksCustomerID = 0; m_CreateEstimate = Map(); l_CrmBillingAddress = {"Billing_Street","Billing_Street_2","Billing_City","Billing_State","Billing_Code","Billing_Country"}; l_CrmShippingAddress =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  3. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.https://www.joellipman.com/articles/crm/zoho/zoho-books/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

    "discount": 0, "quantity": 1, "description": "A test product description" } ], "shipping_address": { "address": "Test Street", "street2": "Test Street 2", "city": "Test City", "state": "Test State", "zip": "Test Postal Code", "country": "Test Country" }...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  4. ZohoCRM: Template: not being able to edit a text boxhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-template-not-being-able-to-edit-a-text-box.html

    address and couldn't change the template. So they had something like: ${Organization.Organization Name} ${Organization.Street} ${Organization.City} ${Organization.Country} ${Organization.Postal Code} 11 My Street, My City, My State, My Zip, My Country...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  5. ZohoCRM & Xero: Function to pull most recent invoiceshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-invoices.html

    v_XeroAddressZip = m_XeroAddress.get("PostalCode"); v_XeroAddressAttn = m_XeroAddress.get("AttentionTo"); } } // l_AddressStreet = List({v_XeroAddressLine1}); if(!isBlank(v_XeroAddressLine2)) { l_AddressStreet.add(v_XeroAddressLine2); }...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  6. ZohoCRM & Xero: Function to pull most recent quoteshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-quotes.html

    v_XeroAddressZip = m_XeroAddress.get("PostalCode"); v_XeroAddressAttn = m_XeroAddress.get("AttentionTo"); } } // l_AddressStreet = List({v_XeroAddressLine1}); if(!isBlank(v_XeroAddressLine2)) { l_AddressStreet.add(v_XeroAddressLine2); }...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  7. Zoho CRM: Permission Denied for Quote Conversion Mappinghttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-permission-denied-for-quote-conversion-mapping.html

    a super admin in CRM, I am denied permission to access the Quote Conversion Mapping page... Why? I wanted to map a billing street 2 and shipping street 2 from the Account module to the Quote module, then on convert, to map these to the Sales Order in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  8. Zoho Books: Display Sales Order Shipping Address on Package Sliphttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-display-sales-order-shipping-address-on-package-slip.html

    my Sales Order: BILLING ADDRESS SHIPPING ADDRESS ------------------- ------------------- Test Company Joels PO Box 1 Test Street 1 Different Street Test City Another City Test State Test Zip Another State Another PostCode Test Country A different...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  9. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

    v_CustomerTimeZone = ""; // // build up address from Lead to geocode l_LeadAddress = List(); if(!isnull(r_LeadDetails.get("Street"))) { l_LeadAddress.add(r_LeadDetails.get("Street")); } if(!isnull(r_LeadDetails.get("City"))) {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

    the header This repeats the header on every page. The key here is the HTML attribute zcpage-headerhtml: My Company Ltd Test Street, Test County TEST1 ZIP1 +44 (0)1234 567890 sales@mycompany.com QUOTE The Quick Answer: the footer This repeats the footer...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  11. Zoho CRM Client Script: Map Quote to Invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-map-quote-to-invoice.html

    ZDK.Page.getField('Billing_Code').setValue(o_QuoteDetails._Billing_Code); ZDK.Page.getField('Billing_Street').setValue(o_QuoteDetails._Billing_Street); ZDK.Page.getField('Shipping_City').setValue(o_QuoteDetails._Shipping_City);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  12. Forum Ruleshttps://www.joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165

    not allowed to create more than one thread per topic. No Posting Personal Info - You may not post your last name, or your street address on TEU. This is because this information then becomes accessible to anyone. No Threatening to Leave the Board - Due...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  13. Zoho Creator: Add a subform while creating a recordhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-add-a-subform-while-creating-a-record.html

    v_ContactSname = r_ContactDetails.get("Last_Name"); v_AddressLine1 = r_ContactDetails.get("Street"); v_AddressCity = r_ContactDetails.get("City"); v_AddressState = r_ContactDetails.get("State"); v_AddressZip = r_ContactDetails.get("Zip");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  14. Google Event Ilustrations aka Flairshttps://www.joellipman.com/component/content/article/google-event-ilustrations-aka-flairs.html?catid=61&Itemid=165

    plan week, plan quarter, plan day, plan vacation, week planning, vacation planning pride: dyke march, christopher street day, gay parade, gay pride, gayglers, gaygler, lesbian march, lesbian parade, lesbian pride, euro pride, europride, world pride,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: *
  15. Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/component/content/article/joel-s-guide-to-midjourney-prompts.html?catid=115&Itemid=165

    Documentary Photography Event Photography Fashion Photography Pet Photography Portrait Photography Sports Photography Street Photography Travel Photography Wedding Photography Manmade Objects Architecture Fine Art Photography Food Photography Product...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
Results 1 - 15 of 15