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

  1. Zoho CRM: Standard Setup for Tax Rateshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-standard-tax-rate-setup.html

    modules (quotes, sales orders, invoices, purchase orders), you need to modify each product record (can be done with "Mass Update") to give them the applicable tax rates: Browse to a CRM product record (you can do mass edit on a listview of products but...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. Zoho CRM: Upload a Product Photo using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-upload-a-product-photo-using-deluge.html

    a photo in Zoho Creator but the source doesn't really matter as the part I struggled on was uploading it to CRM. I want to update the photo in the CRM record. How? So we have to do the usual which is download the photo using invokeUrl then we set the...

    • 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

    Integrated Graphics or Intel Integrated Graphics option which is disabled > Right-click on it, enable it and select "Update Driver" Either via the device manager or just from pure frustration, you should get a prompt to download the Intel Graphics...

    • Type: Article
    • Author: Joel Lipman
    • Category: Articles
    • Language: *
  4. GoDaddy Apache cPanel: Install SSL Certificatehttps://www.joellipman.com/articles/linux/cpanel/godaddy-apache-cpanel-install-ssl-certificate.html

    supposed to happen but 2 days later it still wasn't working. I followed the process above and it took immediate effect... Update 2024 So I've run into the issue that when downloading the certificate from GoDaddy and followed the steps above but it kept...

    • Type: Article
    • Author: Joel Lipman
    • Category: cPanel
    • Language: *
  5. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM templatehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-send-an-email-with-a-crm-quote-using-a-given-crm-template.html

    ]; } else { v_OutputMessage = "No email was specified on this record. Cannot send this quote."; } return v_OutputMessage; Update: What is the URL to download the PDF in Zoho Books? Found this today so thought I'd add it to this article: Invoice:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  6. Zoho CRM: Manage a subform using Client Scripthttps://www.joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

    the Opportunity record. If these are blank then enter the rates manually below: Rate Year 1.0, Rate Year 1.5,..."); } // update the fields (that were blank on the existing record - but now pulled from Opp or from set values)...

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

    users] 2023-03-20 Like my previous article, this needs to be fed contextual data to continue a conversation Done 2023-03-11 Update November 2024 Code to get this working with GPT 4o Mini: // requires a paid account: https://platform.openai.com/api-keys...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. ZohoDeluge: Check Shipment Status via DHL APIhttps://www.joellipman.com/articles/crm/zoho/zohodeluge-check-shipment-status-via-dhl-api.html

    case Zoho Inventory. So for this, I've set up a nightly schedule which checks on all the shipments from a certain date and updates the shipment status for items that have been delivered: Login to ZohoInventory > Setup (Cog Icon) > Automation > Schedules...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. Zoho Inventory: Enable Tracking using the APIhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-enable-tracking-using-the-api.html

    { m_Accounts.put(r_Account.get("account_name"),r_Account.get("account_id")); } } // // build the update or create request m_CreateBooksItem = Map(); m_CreateBooksItem.put("name",v_ItemTitle); m_CreateBooksItem.put("sku",v_ItemSKU);...

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

    l_InvoiceLineItems.add(m_NewLineItem); } m_InvoiceDetails.put("line_items",l_InvoiceLineItems); // // create or update if(v_BooksInvoiceID != 0) { r_InvoiceSO =...

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

    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: { "code": 2945, "description":...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  12. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

    the attachment ID and only push it to Analytics if Analytics doesn't have that attachment ID in its table already... or updates it if it does. You might want to add to the code to only push valid image file types as files. The report will work for Zoho...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. Search and Replace in a MySQL Databasehttps://www.joellipman.com/articles/database/mysql/search-and-replace-in-a-mysql-database.html

    correctly... well that's usually me. Found it a bit boring but here's a short bit of code to speed it up which I now use: update table_name set field_name=REPLACE(field_name,'string_to_find','string_to_replace'); Source:...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  14. The Sandpithttps://www.joellipman.com/graphic-design/the-sandpit.html

    an effect called "time-lapse tilt shift photography" where everything is made to look smaller than it actually is. As an update Mar 2011, I just watched Gulliver's Travels (2010) and it looks like the same effect for the intro credits :c) This is "a day...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  15. SELECT COUNT(DISTINCT name) FROM tablehttps://www.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

    1 and 2 return the correct number. I'm still unsure as to why WHERE...GROUP BY... doesn't return the same totals and will update this article when I figure it out.

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  16. Trim values along with the tabhttps://www.joellipman.com/articles/database/mysql/trim-values-along-with-the-tab.html

    then converting to MySQL commands. Unfortunately, the MS Excel software adds tab characters to delimit the columns... How? UPDATE `mytable` SET `myColumn` = TRIM(CHAR(9) FROM TRIM(`myColumn`)); Source: Stack Overflow - How to Remove Tabs

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

    day (eg. "Mon"). My_Date = today; Day_Name = My_Date.toString("E"); // returns "Mon" How? Well a few methods. Method #0: Update 2020 Tested in CRM and Creator and this is working: My_Date = today; Day_Name = My_Date.toString("EEEE"); // returns "Monday"...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. Joomla: Remove IDs from URLs for out-of-the-box SEFhttps://www.joellipman.com/articles/cms/joomla/joomla-remove-ids-from-urls.html

    an SEF extension that does this for you or spend time tweaking your .htaccess file. Or you can take advantage of a Joomla update and do this without any coding... Pre-amble To allow the Joomla CMS to manage your SEFs you need to setup your htaccess...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
Results 101 - 118 of 118

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.