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

  1. SSIS Multiple Lookups in onehttps://joellipman.com/articles/microsoft/ssis/ssis-multiple-lookups-in-one.html

    server. We had around 12 lookups to do, so you could do this: But we didn't want to do this. How? As a proof of concept, I created one lookup task that executes a SQL query which returns all the joined tables and displays the decode name. Let's pretend...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  2. Joes Search Module (JSM)https://joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

    search: Go to Components > Search > Options > set "Use Search Areas" to "Yes" Save & Close Future Developments This was created for a client and I do not know of any other use this module has. If there is a demand for it, I would add the category...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  3. Joes Word Cloud (JWC) Downloadhttps://joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

    Uploaded: Thu, 21st Oct 2010 1.1- Added Joomla Admin Panel option: Cache-mode - Date Uploaded: Mon, 20th Sep 2010 1.0.0- Created according to brief (automated, using most frequent words) - Added Joomla Admin Panel option: Scan Joomla! articles - Added...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  4. Joes Revolver Map (JRM) Downloadshttps://joellipman.com/component/content/article/joes-revolver-map-jrm-downloads.html?catid=92

    Date Uploaded: Fri, 30th Jul 2010 1.1- Separated all parameters to be configured in the Joomla admin panel - Language file created (English GB only) - Date Uploaded: Fri, 9th Jul 2010 1.0- Added GNU/GPL License information to xml/php - Behaves like...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  5. Protecting your Joomla Administrator Sectionhttps://joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

    # change this to the code to match the above PHP script RewriteRule .* - [L,F] How-to-use: Browse to the folder you created in step 1 and this will be your new administrator URL. Caveat: If you login to the administrator section on a shared computer,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  6. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

    } else{ $output = $response; } // close first request handler curl_close($ch1); // now let's get the ID of the file we just created // and submit the file metadata $this_response_arr = json_decode($response, true); if(isset($this_response_arr['id'])){...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  7. Pure JS - Display Time Elapsed & Remaininghttps://joellipman.com/articles/web-development/js/pure-js-display-time-elapsed-remaining.html

    display to the user how much time is left before another access token will be generated and how long ago was the last token created. How? So almost pure JS. I'm working out the seconds remaining and seconds elapsed in PHP first then passing these as two...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: *
  8. Zoho Deluge: Duplicate/Clone a Recordhttps://joellipman.com/articles/crm/zoho/zoho-deluge-duplicate-clone-a-record.html

    function duplicates a CRM invoice Parameters: p_InvoiceID (CRM ID of the invoice) Returns: Nothing Author: Joel Lipman Date Created: 2020-03-17 */ // get all field names for the Invoices module via API l_FieldApiNames = List(); r_Fields = invokeurl [...

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

    Setup a workflow that when SO Ref changes, the tick box is unticked Form Workflows > New Workflow Select your form Run when Created or Edited When to trigger: User input of a field Choose Field: ZohoBooks Sales Order Ref Name it whatever: eg....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. Zoho Deluge: Search Records with Special Characters (COQL)https://joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

    Deals where ((Amount=0) and (Stage != 'Cancelled')) order by id desc, Stage asc"; // returns 200 deals in most recently created order Regular expression reminder (do not use): v_SearchName = v_SearchName.replaceAll("([&\'])","\\$1",false); Source(s)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

    Click through on "Add New Action": Select "Deluge Script" Select an event: Run a function: And the next screen is why I created the function in advance: Select the application (should be the name of your Creator application) Select namespace (if...

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

    of a leave Inputs: string p_RequestID,string p_Dept,string p_LeaveFrom,string p_LeaveTill Outputs: map/collection Date Created: 2020-10-27 (Joel Lipman) - Initial release - Workflow to calculate 80% dept workforce - Returns response as popup - Cancels...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. Zoho Deluge: Sort a Map by a specific fieldhttps://joellipman.com/articles/crm/zoho/zoho-deluge-sort-a-map-by-a-specific-field.html

    demonstration only) Initialize a list to hold the keys which we will use to sort in ascending/descending order and a map created to hold all the records. Loop through the sample map to create the new map we can sort as well as to add keys to the list...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

    m_Create.put("Name","Joels Amazing Test"); r_Create = zoho.crm.createRecord("Tests", m_Create); // now take the ID that was created and use the following code to populate the multi-lookup field if(!isnull(r_Create.get("id"))) { m_Link = Map(); // using...

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

    background-color: #613DEA; } In Workflow > Form workflows > Click on "New Workflow" Choose your form Run when a record is "Created or Edited" When to trigger workflow is "User input of a field" Choose Field "Save & Close" Name the workflow...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  16. Xero API: Send Multiple Invoiceshttps://joellipman.com/articles/crm/xero/xero-send-multiple-invoices.html

    Xero only allows 5 concurrent connections at one time... And Zoho was trying to send about 7 at a time (as in schedule created 7 Zoho invoices but only 5 Xero invoices). Our solution: Send all Zoho invoices in API call to Xero... apparently it can...

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

    and trigger each field in the displayed order. Method #3: Use an eTag I use to use an eTag for a database-driven system I created to store the record details of properties. It was a quicker way of detecting a change on the record rather than comparing...

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

    I use: Create the sales order in ZohoBooks (either in Zoho Deluge or however you're doing it), then Retrieve the ID of the created Sales Order (captured in response) Update the Shipping Address on the Sales Order in Zoho Books using the API The...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  19. Zoho Creator / eBay: Get all Active Productshttps://joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-all-active-products.html

    int p_PerPage) { /* Function: fn_eBayQuery_GetActiveProducts() Purpose: Fetches current listings / active products Date Created: 2021-10-13 (Joellipman.com - Joel Lipman) - Initial release More Info: - API Explorer Test Tool:...

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

    { "image": { "position": 1, "width": 3024, "height": 3024, "alt": null, "id": 12345678901234, "product_id": 9876543210987, "created_at": "2021-10-17T21:45:56+01:00", "updated_at": "2021-10-17T21:45:56+01:00", "src":...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 81 - 100 of 131

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.