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

  1. Zoho Deluge: Search Records with Special Characters (COQL)https://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-search-records-with-special-characters-coql.html

    your records you may want to find: Company Name: Father & Sons (Incorporated) Contact Name: O'Reilly How? Well I've tried various replace methods with regular expressions but the only method reliable enough I have found to work each time is using the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  2. Zoho Creator: Copy Subform to other Subformshttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-copy-subform-to-other-subforms.html

    Source(s): Zoho Creator/Deluge: Insert rows in Subform Quick refresher: // declaring the row = .(); // assigning values for various subform fields in the row . = ; . = ; // declaring another row (declare as many rows as required) = .(); // assigning...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  3. Format Numbers in AutoHotkey with Commashttps://joellipman.com/component/content/article/format-numbers-in-autohotkey-with-commas.html?catid=48&Itemid=165

    a quick note as I use this function in various scripts. This adds the 1000th separator comma: FormatAddCommas(val) { Result:=val StringLen, OutputVar, Result NumLoop := (OutputVar // 3) DNum = 3 Loop, % (NumLoop+1) { StringRight,Digit,Result,%DNum%...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  4. Zoho Deluge - Get English Ordinalhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-english-ordinal.html

    == "23") { English_Ordinal = "rd "; } // display info My_Date.toString("d") + English_Ordinal; How? I'm exploring various methods, so here's a couple using the built-in functions of Zoho deluge. Method #1: Using a list/array, I'm going to check the date...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  5. Zoho Deluge - Store and repopulate a multi lookup list in Creatorhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-store-and-repopulate-a-multi-lookup-list-in-creator.html

    for selection. Why? This was for a multi lookup with staff as the list entries. The lookup needed to filter against various forms such as Staff Rotas, Leave Requests, Qualifications and some others. How? The aim/objective is the following: Store what...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  6. Zoho Creator: Expecting ZC_SUBFORM_250 expression found COLLECTIONhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-expecting-zc-subform-250-expression-found-collection.html

    // declare a variable to hold the collection of rows = Collection(); // declaring the row = .(); // assigning values for various subform fields in the row . = ; . = ; // insert the row into the collection .insert( ); // insert the collection into the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  7. Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://joellipman.com/articles/crm/zoho/zoho-people/zoho-people-reject-an-application-for-leave-in-deluge.html

    7013, "message": "Field name 'ApprovalStatus' is invalid " }, "status": 1 } } [Warning: Another red herring ahead] We tried various other options such as adding a tickbox that would be used in an approval workflow but ran into issues when trying to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  8. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

    nested arrays (not sure if they were PHP) and it works. Why? This took me several days and in the end only going through various forums and documentation, I found a solution which worked for me. Note that usually I could customize the receiving PHP...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  9. Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

    vice-versa. This can get more complex when there are a lot of fields in the mix. How? I'm using this article to go through various methods I tried to prevent this from happening: First - Off: The one workflow to rule them all In the first instance, we...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  10. Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

    does accept a Base64Encoded version of the image and the below is how I achieved this. How? First-off, let me list the various formats that Zoho Creator says that public link exists. Let's say I have a field called Main_Photo and this is in a form...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  11. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

    is that we have a client who has to go to the CRM record, click on Mail Merge, which opens Writer, then has to click on various settings and run the Mail Merge; then has to click on "execute function after merge" and select the function to run (this...

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

    This is an article to remind me how to calculate various times for an appointment booking system based on the timezones of each party. Why? The use-case scenario is that our Creator server uses the US datacenter but has it's server timezone set to...

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

    some snippets of code in case you need them. How? I will use this to amend and refine but here's the snippets for the various DSTs around the world. US (Except Arizona, Hawaii and US Territories?): DST Start Starts Second Sunday in March at 2:00 DST End...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  14. ZohoDeluge: Inserting a new line character in a CSVhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zohodeluge-inserting-a-new-line-character-in-a-csv.html

    it as "\n"... What I have Me,Myself,I\na,b,c What I want Me,Myself,I a,b,c How? So in this article I just want to list some various methods of inserting a new line character. Works on most systems: l_CsvFileRows = List();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  15. ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://joellipman.com/articles/crm/zoho/zoho-inventory/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

    order, invoice, payment records... Why? I'm storing this here as a reference and taking the bits that I need for the various clients that request an eBay integration. This is a comprehensive snippet which does the whole lot. How? Using the method of...

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

    file to the attachment... Some customers say this is unworkable and takes far too long, especially the part of adding the various field placeholders onto the template document; every time. What if I told you we can code a single button on the record...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  17. ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttps://joellipman.com/articles/crm/zoho/zoho-books/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

    staff having to enter the adjustment each time. The create invoice process would be treated the same. The below are all the various methods I tried to resolve this but the truth is that I do not have a clue how ZohoBooks comes up with its rounding...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  18. RokDownloads Manager does not list fileshttps://joellipman.com/articles/cms/joomla/rokdownloads-manager-does-not-list-files.html

    open this with Internet Explorer with a cleared-cache. A little annoying in view how much I hate Internet Explorer and it's various versions which only work with particular systems... Do not uninstall/install other modules/components as I believe this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  19. Improve Default Joomla Search https://joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

    of this article is to enhance the Joomla search into par with Google and Wikipedia (or near enough). How? I'd like to use various techniques, and the first part of this article (Stage 1) is the only part you need to modify as this will improve your...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  20. ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5https://joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

    and no longer blocks spam comments. How? So I have come up with what I consider a pretty stable solution. I adapted it from various legacy solutions when using Google's ReCaptcha. Note: There is a Joomla plugin for AYAH and this works for the user...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
Results 1 - 20 of 32