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

  1. Zoho Creator: Create a Widget which uses JavaScripthttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-create-a-widget-which-uses-javascript.html

    so that I can easily create a stylesheet and javascript file specific to this app: Adding third-party frameworks: I’m going to use my favorite third-party extensions (Bootstrap & jQuery) which I’m referring to over the web (Content Delivery Network –...

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

    in this example, I will leave this as "void") for Arguments Specify a parameter name of your choosing, in our example I am going to prefix it with "l_" (for list) and the plural of what kind of records I am sending as parameters (in this case "Quotes")....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  3. Zoho Creator: Receive eBay Order Notifications via Webhookhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-receive-ebay-order-notifications-via-webhook.html

    /* // Email yourself as a test but remember to remove this before going Live. sendmail [ from :zoho.adminuserid to :"info@joellipman.com" subject :"TEST ebay Webhook Notification" message :m_Payload ] */ return r_CreateRecord; Save the function While...

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

    such as position: absolute. Because I'm doing this inline and via code, Zoho automatically removes these. So instead, I am going to use negative/positive margins to move the tabs group up/down along with the form wrapper (so all the form is below the...

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

    when editing the template, they couldn't put the cursor in there or even delete the box the address was in. How? So you're going to say this is a strange issue and an even stranger fix, but I've tested this solution by getting a colleague to refresh the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  6. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-inventory-upload-image-to-item-record.html

    uses the same database tables as Zoho Inventory, and there's more documentation on the API for Zoho Books, we're going to apply this solution to Zoho Books. How? We're not going to go into detail on how to parse an eBay response here (see my other...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  7. ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-import-attachments.html

    while as our own documentation is scatty and the online forums weren't too helpful either. How? In the example below, we are going to document how to import files associated to CRM Contact records. There's first the preparation of an "Attachments.csv"...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  8. Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

    number of pages as well as the number of products per page: The GraphQL The key value to retrieve is "cursor"; we're also going to use "hasNextPage" to determine if we need to keep looping: { productVariants(first: 10, query:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  9. Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-using-remove-key-on-a-map.html

    map with the ID removed back into a list. The map itself was null. How? We are using an API action called "Add_Tags". I'm going to get the tags of the contact record using an invokeurl because shortcode only gives me name and ID; but I want the color...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  10. ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

    values to the new line items. How? This is about an hour's work doing it on a CRM workflow (save of record) but here we're going to do it in client script: Additionally, the line items will be sourced from the quote that was converted to the invoice....

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

    do the below in because I went through rocketheme's instructions once and it didn't work. I then carried out all the changes going up and down the document, double-checking I had done everything their instructions said. For demonstration purposes: I am...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  12. Migrating from Joomla 2.5.x to 3.4.xhttps://joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    (eg. 3rd-party QuickStarts): [Personal Option] Modify admin ID to NOT use a text editor (ie. "Text-editor=None") If you are going to delete an object (eg. contacts), make a note on its contents or embedded code specific to the template. Copy over Users:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  13. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/component/content/article/google-drive-oauth-using-service-account-in-php.html?catid=61&Itemid=165

    Applies to: Google Drive REST API v3 Google OAuth 2.0 v4 Google Cloud Platform IAM Google Suite PHP v5.6.35 How? I'm going to go through each section of the code to go through the logic and highlight any changes you may need to make. 1. First: the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  14. Alternate row background colour in Reporting Serviceshttps://joellipman.com/component/content/article/alternate-row-background-colour-in-reporting-services.html?catid=75&Itemid=165

    in the "Fill > BackgroundColor" properties row... Done! Borders: I'm putting this here because often enough, if I'm going to make the report pretty with alternating rows, I'm probably going to look at the cell borders as well. I want a bigger border at...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  15. Room Availability Calendar in Business Intelligence Development Studiohttps://joellipman.com/component/content/article/room-availability-calendar-in-business-intelligence-development-studio.html?catid=75&Itemid=165

    -1, e.EventFinish) --Set the maximum times the Dates cte can recurse OPTION (MAXRECURSION 100) 1. Create a new report: We're going to run the wizard here but without it just add a matrix with [time] in the "column" and [room] in the "row" and...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  16. SSRS Querying on either of 2 Parametershttps://joellipman.com/component/content/article/ssrs-querying-on-either-of-2-parameters.html?catid=75&Itemid=165

    "Available Values" as suggested by Stack Overflow to gets its value based on the first parameter but ended up with an error going on about "forward dependencies". This is obviously going to error, so continuing on their solution, setting the "Available...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  17. SQL Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/else/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

    you ok this you should be on the following screen: Select the Report Type: For this calendar we want matrix because we're going to group based on the rows: Design the Matrix: Ok so we want weekday in the columns (to have mon-sun along the top), "Order"...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  18. Convert to Proper Case in T-SQLhttps://joellipman.com/articles/else/database/t-sql/convert-to-proper-case-in-t-sql.html

    for SSIS. How? You can search my site for how to do this in VB or C#. This version is entirely using T-SQL and we're going to use a function so no dynamic SQL (execute, evaluate). Method #1: First version This was my first attempt based on snippets...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  19. Export/Import Database using MySQL Workbenchhttps://joellipman.com/articles/else/database/mysql/export-import-database-using-mysql-workbench.html

    even a web-based app such as PhpMyAdmin would fare better. How? So this is the HOME tab when you open MySQL Workbench. We're going to go on the basis that you already setup a connection to your database under the SQL Development section. Export/Import...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  20. Add attribute xsl:nil=true on empty elements using XSLThttps://joellipman.com/articles/cms/website-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

    An article on how to declare an XML element as NULL using the attribute "xsi:nil". I'm going to use a very short example by providing a blank date of birth value: -- What I have: // -- What I want: Why? Outputting from SITS:Vision to our staging...

    • Type: Article
    • Author: Joel Lipman
    • Category: XML Stylesheet Language Transformations
    • Language: *
Results 21 - 40 of 158