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

  1. Zoho Templates - Font size is inexplicably tinyhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-templates-font-size-is-inexplicably-tiny.html

    covers them both... Which is an unintended but desired effect. Class .page: I actually like using this class because it's pretty descriptive. Unfortunately setting the width/height in cm was causing havoc to my template. Specifying only a font-size,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. Zoho CRM: Standard Setup for Tax Rateshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-standard-tax-rate-setup.html

    This is an article for training purposes. I'm pretty sure there is official documentation on how to do this but I thought I'd write this article to make it simpler for new developers to follow and learn as a quick point of reference. Why? Some clients...

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

    wanted a quote template to be rendered for PDF or print format. I have another article for a different client who wants a pretty advanced HTML template (well it's a HTML table with rowspans and the borders need to merge cells). But here we're simply...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  4. ZohoCRM: Make either Mobile or Email mandatoryhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-make-either-mobile-or-email-mandatory.html

    A really quick article on a pretty cool requirement, making 2 fields mandatory but if one is completed then making the other optional. Why? My use-case is that the mobile or email field on a Zoho CRM contact record is used to authenticate the contact on...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  5. Before and After, Highs and Lowshttps://www.joellipman.com/component/content/article/before-and-after-highs-and-lows.html?catid=75&Itemid=165

    I'm looking for a SQL query that could do this all in one go and return all the results in one table. With PHP & MySQL it's pretty simple: use individual SQL queries to get the count of yesterday, yesterweek, yestermonth, yesteryear and do the layout in...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  6. PHP & MySQL Search Enginehttps://www.joellipman.com/articles/cms/website-development/php/php-a-mysql-search-engine.html

    array('#260357','#ffffff'), ); } function search_highlight_do($fragment, $color){ return "". "$fragment"; } function search_pretty_terms_highlighted($terms_html){ $colors = search_get_highlight_colors(); $temp = array(); foreach($terms_html as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  7. htaccess Rewrites SEF URL and submits to PHPhttps://www.joellipman.com/articles/cms/website-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

    Notes If you do apply the above to your site, bear in mind the following is also true: http://www.mysite.com/blog/pretty_much_anything_i_want_to_type_here.html --yields...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  8. COVID-19: Working from Homehttps://www.joellipman.com/component/content/article/covid-19-work-from-home.html?catid=45&Itemid=165

    adjective "relating to or designed for efficiency and comfort in the working environment." So it's pretty important not to be slouching over the coffee table for hours or days on end. I was waiting to move house during 2020 but then a virus capable of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Articles
    • Language: *
  9. Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=53&Itemid=165

    work if you have RocketTheme's RokBox Extension installed. It simply opens an external link in a "lightbox" which is a pretty cool effect, see the front page of www.joellipman.com and click on one of my "recent weblinks" for a demo. Semi-Transparency...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  10. Zoho Deluge - Some Useful Regular Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-some-useful-regular-expressions.html

    // yields my_real_textual_data Additional Since writing this article I found a Zoho page with some other pretty useful regular expressions at https://zoholic.blogspot.com/2015/04/some-usefull-regex-in-zoho.html: Convert a string of characters to a list:...

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

    subject: "Testing an attachment" message: "This is a test" attachments: view: myFormReport[ID == myRecordID] as PDF ]; // pretty cool: sends a report from Creator as a PDF attached to an email. When attaching a file in CRM unlike in Books, you need the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  12. Zoho Deluge - Pad with leading Zeroshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-pad-with-leading-zeros.html

    { return leftpad(toString(input.startingNumber), input.finalStringLength).replaceAll(" ", "0"); } This looks like pretty old code and not wanting to cause offence, it isn't the JavaScript style or chain I like which appends the functions instead and is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  13. Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-create-a-widget-which-uses-javascript.html

    the parameter: Additional Note(s): I have found that adapting Widgets created for Zoho Creator to work in Zoho CRM is pretty easy to do. The only differences are the step where you select the type of project in the CLI, in particular the widget JS...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  14. Zoho CRM & Zoho Creator: Query returns some fields missing other data on the recordhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-crm-zoho-creator-query-returns-some-fields-missing-other-data-on-the-record.html

    CRM with a view on to related records in Zoho Creator. For some reason, only some random fields were being returned, all pretty much useless to me. Well the "for some reason" turned out to be because my detail view on the report was displaying a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  15. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-text-sms-using-twilio-api-localsense.html

    the customer and we want to remind our customer that they have an appointment in 1 hour with us. How? The code is actually pretty straightforward but you will need to follow these steps to get the credentials: Login to your Twilio console On the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  16. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeroshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-regex-rounding-and-or-removing-trailing-zeros.html

    And they need the decimal because sometimes they might offer 12.5%. But when it displays in a template, it isn't that pretty to look at: Instead, could they have 10% to display instead of 10.00%, and display 12.5% instead of 12.50%. Well there might be...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  17. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile)https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-using-a-function-for-validation-rules.html

    So this is a pretty cool feature in Zoho CRM that I hadn't used much but definitely worth an article. The ability to block field picklist options from being selected based on the profile of a user. Why? There were several alternatives we considered...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  18. Zoho Creator: Radio group into Calendar Carouselhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-radio-group-into-calendar-carousel.html

    span label[elname='radioEl_zc-Calendar_Day_Select_9']{font-size:65px} Awesome! Looking good! the Deluge Not just a pretty face, let's make this functional. First of all, make sure you set up a form with the fields I mentioned earlier in the Creator...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  19. Zoho CRM: Updating a CRM record Custom Line Items using API v7https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-updating-a-crm-record-using-api-v7.html

    [ url :v_Endpoint type :PUT parameters:m_Data.toString() connection:"zcrm" ]; info r_QuoteDetails; } Creating a record Pretty much the same as above but instead of the method/type PUT you will use POST with an endpoint of...

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

    rewriting a subform (line items of an invoice) and calls a REST API fuction to return the custom fields of the line items. Pretty much a function which took me a day to write. Why? As mentioned, it took me a while to write and I would like to use it as...

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