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

  1. Zoho Creator / Shopify: Get all Active Productshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-shopify-get-all-active-products.html

    of ID ascending (starting with ID=0) retrieving 250 per call and using since_id to not list the same one twice. It then outputs a JSON list as a response and the total record count: void API.fn_ShopifyQuery_GetActiveProducts() { m_Header = Map();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

    these in a cURL request (same thing really): string API.fn_ShopifyQuery_UploadPhoto(int p_Position, int p_ProductID) { v_Output = ""; m_Header = Map(); m_Header.put("Content-Type","application/json"); // // your shopify details v_ClientID = "";...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

    Here's a crude diagram of what I had: Previous Setup Diagram: Home PC has a graphics card with 1x HDMI, 1x DVI, and 1x VGA output ports: I connected the 2 acer monitors which both accepted DVI. Work PC has a graphics card with 1x Display Port output...

    • Type: Article
    • Author: Joel Lipman
    • Category: Articles
    • Language: *
  4. ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

    Map(); m_Prompt.put("param_name","banter"); m_Prompt.put("prompt_msg",v_Response); m_Response.put("prompt",m_Prompt); // // output return m_Response; click on "Save Script" Test using the sidebar on the right Click on "Done" when satisfied. Click on the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttps://www.joellipman.com/articles/crm/zoho/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

    downloading a JSON file. Looked a bit suspicious. The code below opens a new tab in their web-browser displaying a plain output message. How? So there are 2 caveats to this solution: 1 is that you will need ZohoCRM. I've tried using the "Incoming...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  6. Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

    Number", "Question Number" You can take out the order by clause. I just have it here to preserve my sanity when viewing the output. Note that "Page Number" is my custom sorting mechanism so you would have to refer to the output without this column...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  7. PHP: First name and Initial of Surnamehttps://www.joellipman.com/articles/web-development/php/php-first-name-and-initial-of-surname.html

    '.strtoupper($author_names[1][0]).'.'; }else{ $author_name_disp=ucfirst($author_name); } // output echo $author_name_disp; A lot of repetition so lets reduce that a touch: // default $author_name_disp=$author_name; // check and transform...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  8. Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html

    the stated conditions are met. This License explicitly affirms your unlimited permission to run the unmodified Program. The output from running a covered work is covered by this License only if the output, given its content, constitutes a covered work....

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  9. SSIS Skip Blank Rows in Flat File Sourcehttps://www.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

    The "component "MyDerivedColumns" (4228)" failed because error code 0xC0049063 occurred, and the error row disposition on "output column "DC_MyDate" (7349)" specifies failure on error. An error occurred on the specified object of the specified...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  10. Zoho Deluge - Some Useful Regular Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-some-useful-regular-expressions.html

    // yields World Hello Joe Remove block comments: v_MyRegEx = "(\/\*([^*]|(\*+[^*\/]))*\*+\/)"; v_MyString = "String to output: /* this is a comment */"; v_MyFormattedString = v_MyString.replaceAll(v_MyRegEx,""); // yields String to output: Zoho Deluge...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. Zoho Creator / eBay: Get all Active Productshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-all-active-products.html

    */ v_Page = ifnull(p_Page,1); v_PerPage = ifnull(p_PerPage,200); m_Output = Map(); r_Api = API_Integration[Connection_Name == "eBay API (Production)"]; if(r_Api.count() > 0) { v_AccessToken = thisapp.API.fn_eBayConnect_AccessToken(); v_TradingAPIVersion...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  12. ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

    if(!isnull(r_Response.toMap().get("details"))) { if(!isnull(r_Response.toMap().get("details").get("output"))) { v_AccessToken = r_Response.toMap().get("details").get("output"); } } m_Header = Map(); m_Header.put("Authorization","Bearer " +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. Zoho Creator: eBay: Get Item Transactionhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-item-transaction.html

    */ v_Found = 0; v_Updated = 0; v_Page = 1; v_PerPage = 10; m_Output = Map(); r_Api = API_Integration[Connection_Name == "eBay API (Production)"]; if(r_Api.count() > 0) { v_AccessToken = thisapp.API.fn_eBayConnect_AccessToken(); v_TradingAPIVersion =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

    if(!isnull(r_Response.toMap().get("details"))) { if(!isnull(r_Response.toMap().get("details").get("output"))) { v_AccessToken = r_Response.toMap().get("details").get("output"); } } info v_AccessToken; // // build header m_Headers = Map();...

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

    updload the photo r_UploadPhoto = invokeurl [ url :v_Url type :POST files:r_DownloadedPhoto connection:"joel_books" ]; // output response to console info "Response of attempt to upload to Zoho Inventory:"; info r_UploadPhoto; You should get a response...

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

    := A_ScreenWidth - v_GuiWidth SysGet, v_WorkArea, MonitorWorkArea v_GuiYpos := v_WorkAreaBottom - v_GuiHeight - 2 ; Output file names v_ProcessID := DllCall("GetCurrentProcessId") v_FileName_Errors := "Errors_" v_ProcessID v_FileName_Success :=...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  17. Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

    Pool) Rooftop Snow Theatre Tokyo Warehouse More Art Terms These are ones mentioned by YouTubers that had an effect on the output (ones I didn't make an image of didn't work for me but I want to remember them in case I learn how to use them): YouTube -...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  18. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

    } } } } else { // store in response text m_Response.put("text","I don't know. Consider doing a Google search."); } } // // output return m_Response; Yields something like the following: Text-Davinci-003: (preceded ChatGPT API) // // initialize...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  19. Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

    with just using CSS? It looks beautiful on ZohoCreator pages but then you hit the PDF button and it pretty much vomits your output back to the 90s. The code snippet below is just for a standard template with a modern design. How? Ok, admittedly, when...

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

    on an invoice type change Purpose: Prepares the invoice as a deposit invoice or final balance invoice Inputs: string value Outputs: - Date Created: 2025-03-31 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Information: Any information...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 21 - 40 of 89

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.