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 178 results were found.

  1. Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  2. Zoho Deluge: Get All Orders from eBayhttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  3. Zoho Books: Get Invoice Payment Terms via APIhttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  4. Zoho Creator: Find Duplicates by Customer Name for Large Datasetshttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  5. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  6. Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSONhttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  7. Zoho Books: System Values Mapshttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  8. Zoho Analytics & Zoho People: Monitor DataSource Sync https://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  9. ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  10. Zoho Creator: Input Color Pickerhttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  11. Add default to a picture buttonhttps://www.joellipman.com/articles/automation/autohotkey/add-default-to-a-picture-button.html

    Add the submit button with a hidden attribute: Gui, Add, Button, x600 y70 w90 h90 +Default +gSearch +Hide, Search The function to receive the data can be: Search: Gui, Submit, NoHide MsgBox, Searching for "%SearchTextInput%" Return

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  12. 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: *
  13. Format Numbers in AutoHotkey with Commashttps://www.joellipman.com/articles/automation/autohotkey/format-numbers-in-autohotkey-with-commas.html

    a quick note as I use this function in various scripts. This adds the 1000th separator comma: FormatAddCommas(val) { Result:=val StringLen, OutputVar, Result NumLoop := (OutputVar // 3) DNum = 3 Loop, % (NumLoop+1) { StringRight,Digit,Result,%DNum%...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  14. Convert seconds to total time in PHPhttps://www.joellipman.com/articles/web-development/php/convert-seconds-to-total-time-in-php.html

    convert seconds into total hours, minutes and seconds (taking into account regional settings and without using a date function). How? $total_time =intval(intval($total_seconds)/ 3600).":";...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  15. Warning call_user_func: First argument is expected to be a valid callbackhttps://www.joellipman.com/articles/cms/joomla/warning-call-user-func-first-argument-is-expected-to-be-a-valid-callback.html

    What? If you get something like the following error: Warning: call_user_func() [function.call-user-func]: First argument is expected to be a valid callback in /home/.../templates/rt_affinity/rt_sectionrows.php on line 311 How? Copy & backup the file...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  16. Excel: Extract hyperlink from linkhttps://www.joellipman.com/articles/microsoft/excel/excel-extract-hyperlink-from-link.html

    a new workbook. Get into VBA (Press Alt+F11) Insert a new module (Insert > Module) Copy and Paste the Excel user defined function below Sub ExtractHL() Dim HL As Hyperlink For Each HL In ActiveSheet.Hyperlinks HL.Range.Offset(0, 1).Value = HL.Address...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  17. Zoho Deluge - Get Full Day Namehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-full-day-name.html

    is a very quick note with the code to retrieve the full day name from a date (eg. "Monday"). Why? If I use the toString() function to get the day, it only returns the first 3 letters of the day (eg. "Mon"). My_Date = today; Day_Name =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. Zoho Deluge - Regex to Strip all non-numeric charactershttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-regex-to-strip-all-non-numeric-characters.html

    v_PaymentTerms = "Credit Note - 30 Days"; // we want the 30 from the above string How? I'm aware of the getAlphaNumeric() function in Zoho and I can remove the letters with removeAllAlpha(): v_PaymentTermsAlphaNum = v_PaymentTerms.getAlphaNumeric(); //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 161 - 178 of 178

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.