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

  1. Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-refresh-access-token.html

    A sorta quick article to note how I can generate refresh tokens and access tokens using Zoho Deluge code (so within Zoho Creator, CRM or Books) without XML calls. Why? I find myself using this more and more now that API v1 is on the way out and Zoho...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  2. Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/component/content/article/stop-excel-row-height-self-adjust-on-refresh.html?catid=110&Itemid=165

    data in an Excel Spreadsheet. The Problem We can select all cells and set row height to be 30 for example, but everytime we refresh the data in the Excel spreadsheet, all the rows get re-adjusted to fit the data and lose that consistency. A Workaround:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  3. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://www.joellipman.com/component/content/article/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html?catid=138&Itemid=165

    to the Deal record. How? The following is the process from registering the app to call on the full API (grant code > refresh token > access token) and then the code to attach the document to the CRM record. STEP 1: REGISTER A NEW CLIENT First, you need...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Sign
    • Language: *
  4. ZohoBooks: Broken UK Banking Feedhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-broken-uk-banking-feed.html

    simply stopped working. How? First let's go through a resolution and get the official response on what impact this has on refreshing the token. Then I'll put all my notes I made along the way. When a Zoho Books bank feed stops syncing in the United...

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

    functions] for this process). So first off, here's a reminder on the function that generates an access token from a refresh token: string API.fn_eBayConnect_AccessToken() { b_SandboxMode = false; v_Output = ""; if(b_SandboxMode) { r_Api =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  6. Zoho Deluge: Setup an API Connection for InvokeURLhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-setup-an-api-connection-for-invokeurl.html

    This is slightly different to my article Zoho Deluge: Get Refresh/Access Token API v2 (Zoho to Zoho service) and different to my Zoho CRM: APIv2 using PHP & cURL (3rd-Party to Zoho), in that this details how to setup a connection to use in an invoke URL...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  7. Setup a copy of your Joomla websitehttps://www.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

    that you've developed. (referred to with the customers as TEST). BACKUP - an exact copy of LIVE (preferably from a daily refresh - and inaccessible to non-administrator users) DEV1 - a copy of LIVE and for developers to play with. DEV2 - a copy of LIVE...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  8. Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/component/content/article/returning-oracle-stored-procedure-resultset-in-ssrs.html?catid=75&Itemid=165

    SSRS user) Add a data source to your SSRS report Add an SSRS input parameter Add a dataset Query type: Stored Procedure Refresh fields button Parameter name (oracle input sp variable) and Parameter value (ssrs input parameter) Fields (field name=ssrs...

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

    that offer FREE thumbnail screenshots are getting stricter with their terms of use. You should only enable thumbnail refreshes at the time of install. Also note, this module will NOT generate thumbnails if you select "Public" as the authorized service...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  10. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

    ID (Single Line) Redirect URI (Single Line) Scope(s) (Multi Line) Access Token (Multi Line) Access Token Expiry (Date-Time) Refresh Token (Multi Line) Refresh Token Expiry (Date-Time) AuthToken (Multi Line) AuthToken Expiry (Date-Time) You should end up...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  11. Include a carriage return in a column headinghttps://www.joellipman.com/component/content/article/include-a-carriage-return-in-a-column-heading.html?catid=78&Itemid=165

    the cells in Excel containing the header under "Alignment" to "Wrap Text". The difference the above does, is that when you refresh the data, it will retain the carriage return in the column headings. Additional: Only appears obvious in SQL Server...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  12. Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/else/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

    me thinking I was trying to hack into their servers because of the number of queries Joomla does and the number of times I refresh the page and upload files. Why they think that developers should not be able to send a 1000 queries a minute or why a...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  13. Excel PivotTable Filter List Orderinghttps://www.joellipman.com/component/content/article/excel-pivottable-filter-list-ordering.html?catid=110&Itemid=165

    the field list of the report (so you see the fields panel) Untick the filter that is not in alphabetical order Click on the Refresh button Re-Tick the filter to add it back to the report Move this added field to the Report Filter section (click on it...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  14. Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=53&Itemid=165

    changes to the program, you'll need to re-run the Help. The Help will tell you what to correct but it doesn't currently refresh its data until you request the Help page again. It only self-analyzes when the Help page loads, it isn't a persistent check....

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  15. Zoho CRM: APIv2 using PHP & cURLhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-apiv2-using-php-curl.html

    how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet of code below is using the functions to read data from Zoho CRM and to write data back to...

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

    here I am using MS Visual Studio Code for Mac and I get the following: If I change the HTML and save the file, I can refresh the browser page and immediately see the changes: Adding custom CSS and JS files: If using MS Visual Studio Code, I’m adding the...

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

    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 page and check it out as well as the client to go in and confirm the change was successful...: For this strange fix, I'm...

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

    different progress animation which is possibly all your data being mapped, associated, and imported... I personally had to refresh the screen a few times after about 10k records as the browser webpage seemed to hang or get stuck. It just resumes where...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  19. ZohoAnalytics: Pivot Campaigns vs Contactshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zohoanalytics-pivot-campaigns-vs-contacts.html

    t1."Campaign Name" IN ( "Campaign 1","Campaign 2","Campaign 3" ) ) t2 The bigger query: Now create another query (better to refresh the page so that the new table and columns will be available to us): SELECT c."Full Name", c."Lead Source", cp."Campaign...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  20. Zoho Deluge: Connect to Shopifyhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-connect-to-shopify.html

    because I spent 2 hours going down the rabbit hole of trying to use OAuth2 and following the usual steps: Grant Code, Refresh Token, Access Token. I also went down the rabbit hole of installing app-bridge and configuring a JWT which was an absolute...

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