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

  1. Zoho Deluge: Today, Tomorrow, Day After but Skip Sundayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-today,-tomorrow,-day-after-but-skip-sunday.html

    Wanting to create a schedule for availability over the next few days which needs to dynamically change. I am aware of the function .addBusinessDay() but that excludes Saturdays which my client still works on. How? We're going to get today's date, then...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  2. Zoho Creator/Deluge: UnPredictable exception, Invalid statement foundhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-deluge-unpredictable-exception,-invalid-statement-found.html

    Just a quick article if you get the above error and what to look for. Why? I was writing a function with perhaps too many for each loops within a for loop. How? The following is 1 fix for the error: Execution Failed UnPredictable exception, Invalid...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  3. Zoho CRM: Schedule a Call using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-schedule-a-call-with-deluge.html

    remind us that we need to phone this Lead. How? It sounds straightforward: schedule a call using the GUI then write a test function to check the JSON that is being returned for API names... If that were the case, it would have been a 5 minute job....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  4. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-text-sms-using-twilio-api-localsense.html

    execution date "On" the date and execution time "1 hour before". Condition 1: rule is applied to all calls Action is the function below with the parameter "p_CallID" being the Calls - Call ID value. // r_CallDetails =...

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

    This is an article to document how to use the searchRecords function in CRM and to sort the results response. Why? This is unclear and not always working as coded below since each system (CRM, Creator, Books) seems to interpret this sorting feature...

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

    objective of this task, which was to recover the relevant product based on any given Product SKU. Making the above into a function as well as returning the inventory item ID and the product ID: map API.fn_SearchShopifyBySKU( string p_SKU ) { // // app...

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

    ID parameter at the end of the URL) {"code":2,"message":"The request passed is not valid."} The .setParamName() function is setting the data type to probably file or attachment when it should be image.

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

    publishedAt updatedAt } updatedAt } cursor } pageInfo { hasNextPage } } } The Deluge Code So this is a Zoho Creator function that I'm going to call API.fn_ShopifyQuery_UpdateAllProducts() and it will be added to a nightly schedule. It's aim is to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  9. Zoho Deluge: Get All Orders from eBayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-all-orders-from-ebay.html

    the eBay active listings (see article link above), we're going to use the GetOrders call for order (sales) management. /* Function: fn_GetEbayOrders() Purpose: Queries eBay for all orders for a specified year Date Created: 2023-03-29 (Joel Lipman) -...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  10. Zoho Books: Get Invoice Payment Terms via APIhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-get-invoice-payment-terms-via-api.html

    "payment_terms_label": "Due end of next month" } ] } } Usage: This is just a snippet of usage and obviously not the whole function to generate an invoice. Please refer to the Zoho Books API documentation for what fields are required to complete a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  11. Zoho Creator: Find Duplicates by Customer Name for Large Datasetshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-find-duplicates-by-customer-name-for-large-datasets.html

    from the "all" list. That didn't happen so the above code works at time of print. Things can change though and if the function is changed to remove every instance of the "distinct" list, then I'll have to come up with a different solution. Maybe Zoho...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  12. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

    a billing/shipping address included in a request to create or update an estimate in ZohoBooks will fail... Why? I have a function to push a ZohoCRM quote to a ZohoBooks estimate and a client asked that the address on the CRM record 'pulls through'....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  13. Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSONhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-error-code-2945-extra_key_found_in_json.html

    forums and documentation did not. Why? I don't often do this to create a Creator record but I'm going to use the shortcode function zoho.creator.createRecord() and wanted to update the first name of a name field but I was getting the following error: {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  14. Zoho Books: System Values Mapshttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-system-values-maps.html

    made with a different variable org ID. /* ******************************************************************************* Function: Map fn_GetSystemValues() Trigger: Snippet to be used at beginning of code to get dynamic maps of system values Purpose:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  15. Zoho Analytics & Zoho People: Monitor DataSource Sync https://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-zoho-people-monitor-datasource-sync.html

    ZohoAnalytics.metadata.read. The code /* ******************************************************************************* Function: void Check_DataSources_Sync_to_ZohoAnalytics () Label: Check DataSources Sync to ZohoAnalytics Trigger: Scheduled daily at...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  16. ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

    the custom related list in ZohoBooks: /* ******************************************************************************* Function: Map Related_Purchase_Orders( Map salesorder , Map organization , Map user , Map page_context ) Label: Related Purchase...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  17. Zoho Creator: Input Color Pickerhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-input-color-picker.html

    rename this to 'Staff Color'] Add another single line field, I'm calling it "RGB Value" [Optional: not required for the functionality of this demo but used in later application when including CSS opacity] Step 1: Code to complete the radio options This...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  18. Zoho CRM Client Script: Map Quote to Invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-map-quote-to-invoice.html

    Click on the button Next the Script /* ******************************************************************************* Function: Invoice TBC Label: Invoice TBC Page Details Category Module Page Create Page (Standard) Module Invoices Layout Standard...

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

    your paths are correct - don't forget they're case sensitive and spelt exactly the same way) Fatal error: Call to a member function acl_get() on a non-object in /includes/functions_display.php on line 135 sometimes line 82 or a blank page. We found this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  20. Invalid arguments passed in router.php on line 325https://www.joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

    was that I was building my first Joomla 1.5 component and getting the below error if I put in a menu: Warning: implode() [function.implode]: Invalid arguments passed in /home/.../public_html/includes/router.php on line 325 Where "..." is the path on...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
Results 141 - 160 of 185