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

  1. Zoho Deluge - InvokeConnector and useful snippetshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-invokeconnector-and-useful-snippets.html

    { l_Users = r_Response.get("response").get("users"); for each v_User in l_Users { info v_User.get("full_name") + " :: " + v_User.get("id"); } } } Update 2020: Note this can also be achieved with the following shortcode: l_Users =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. Zoho Deluge: Get Image Uploaded in Creator Formhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-image-uploaded-in-creator-form.html

    Method #2: Using Deluge Assuming that I have a form called "MyImages" and an image upload field that has the field link name "MyImage". There is an additional single-line text field called "Name". I have added an entry with name "Logo" and I have...

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

    "message": "Error occurred", "uri": "/api/forms/json/P_ApplyLeave/updateRecord", "errors": { "code": 7013, "message": "Field name 'ApprovalStatus' is invalid " }, "status": 1 } } [Warning: Another red herring ahead] We tried various other options such...

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

    CRM modules called a "LinkingModule" (as opposed to standard modules and custom modules). Quick way to determine the API name of the linking module: Go to setup > Developer Space > functions. Create a standalone function called "Test". Type in line 1:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. ZohoCRM: Deluge: Map a custom field from user profilehttps://www.joellipman.com/articles/crm/zoho/zohocrm-deluge-map-a-custom-field-from-user-profile.html

    owner of a record. Why? A client had added a custom lookup field to the users settings called "Division" (similar to team name) and wanted any Opportunity record to have a field showing the user's Division. This would help in reporting later down the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  6. Zoho Creator: Change Radio into Tabshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

    add a Notes field to the Creator form, I'm calling mine Note_CSS, then I have added a radio group called Tabs [NB: If you rename it from "Tabs" to something else, all CSS references need to be changed as well to the new name and follow the syntax...

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

    but then they changed 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. Zoho CRM: searchRecords with sorted resultshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-searchrecords-with-sorted-results.html

    then separate each with parenthesis joined by "and" or "or". Nulls are not returned. Set the "ModuleToSearch" to the API Name of the module you want to search. Method #1: zoho.crm.searchRecords() Contrary to the documentation saying there are only the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://www.joellipman.com/articles/crm/zoho/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

    = {"cf_payment_method","cf_payment_date","cf_last_4_digits"}; if(!l_DontCopyFields.contains(m_CustomField.get("api_name"))) { l_NewCustomFields.add(m_CustomField); } } // add custom field payment mode m_MiniCustomField = Map();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. Zoho CRM: Manage a subform using Client Scripthttps://www.joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

    // get opportunity lookup (related deal) of this record let r_DealLookup = ZDK.Page.getField('Opportunity_Name').getValue(); let v_DealID = r_DealLookup.id; let r_DealDetails = ZDK.Apps.CRM.Deals.fetchById(v_DealID); // get Deal/Opportunity fields we...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. Zoho Deluge: Proper Case for Nameshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-proper-case-for-names.html

    This is an open article without any completion in mind; to set the proper case of a name, as in capitalize the first letter, lower case the rest but then with exceptions. Why? Some of the Zoho Apps are incredibly case-sensitive and consider some records...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  12. ZohoCreator: Basic Widget with Zoho Datahttps://www.joellipman.com/articles/crm/zoho/zohocreator-basic-widget-with-zoho-data.html

    third-party CDN / API gets upgraded. Add these to the widget as you see fit but I'm including jQuery and Bootstrap: Company Name - Quote Builder Hi You have 0 Pending Quotes You have 0 Previous Quotes Get a New Quote! © 1999 Joel Lipman Ltd. All Rights...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. Zoho Webhooks & Shopify API: Keep Disappearinghttps://www.joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

    Update"); m_CreateRecord.put("JSON_Payload",m_Payload.toString()); r_CreateRecord = zoho.creator.createRecord("myOwnerName","myAppName","myFormName",m_CreateRecord,m_Blank,"myCreatorConnection"); // // build the hash based on the payload body v_Data =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. MySQL Group_concat equivalent in T-SQL and Oraclehttps://www.joellipman.com/articles/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

    RowID column_to_return_as_string --------- -------------------------- 1 Me 2 Myself 3 I -- to be returned as RowID my_field_name --------- -------------------------- 1 Me,Myself,I Note that the following queries include the nested version because I find...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  15. GDPR Privacy Policyhttps://www.joellipman.com/static-items/gdpr-privacy-policy.html

    without express written consent. You may not use any meta tags or any other "hidden text" utilizing JoelLipman.com's name or trademarks without the express written consent of JoelLipman.com. Any unauthorized use terminates the permission or license...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  16. Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

    I'm rewriting their instructions here so that I can I do this on other websites: Important Note: On Linux (Apache), all file names and folder names are case-sensitive, so phpbb3 is NOT the same as phpBB3. Bear this in mind during the installation...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  17. Mediawiki Extension for Camtasia Studio SWF videoshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

    > Next Video Info (complete optional settings) > Make sure "Embed Video into HTML" is checked > Next Specify production name and click on 'FINISH' This will produce a HTML, SWF, XML and JS file in the output directory. We only want the SWF and JS file....

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  18. SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

    a field in one of our Oracle tables and returns nothing. It accepts 3 parameters: The StudentID (reference) varchar2, Username (who's running the report) varchar2 and a JobID (request reference) number. The Report We start off with our detailed report...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  19. How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

    the Reporting Server ExecutionLog? Using the ReportServer Execution Logs, we can determine if this is correct SELECT TOP 1 c.Name, e.TimeStart, e.TimeDataRetrieval + e.TimeProcessing + e.TimeRendering AS TotalTime FROM [ExecutionLog] e INNER JOIN...

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

    to return a single value, which is all I need in this case. In my example, I need to submit an Active Directory (AD) username and receive a student ID number instead, all with the aim to improve performance on some SSRS queries which accept either an ID...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
Results 101 - 120 of 269

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.