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

  1. Zoho Cliq: Integrate OpenAI ChatGPT with Conversation Threadshttps://www.joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-chatgpt-with-conversation-threads.html

    = List(); if(!isnull(r_ChatDetails.get("data"))) { for each r_MessageData in r_ChatDetails.get("data") { v_Role = "user"; if(!isnull(r_MessageData.get("message_source"))) { v_UserType = r_MessageData.get("message_source").get("type"); v_Role =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  2. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

    The Code to read, parse, create a holding record and generate a link for the customer portal user to click on: // accessing zoho.eu (not zoho.com) so adapt the 2 values v_CreatorBaseUrl = "https://creator.zoho.eu"; v_ZohoApisDC =...

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

    the CRM record into a PDF using a customer's template. // // initialize (this is code added to a button so should alert user if no email was specified) v_OutputMessage = ""; v_TemplateID = "123456789012345678"; // // get the quote details given a record...

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

    for Attachment ID and just "image001.jpg" for File Name. Attachment Owner Id: This is a "zcrm_" prefixed ID of the user who owns the attachment. Modified By Id: This is a "zcrm_" prefixed ID of the user who modified the attachment. Created By Id: This...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  5. PHP Script: Make your own Thumbnail Generator via APIhttps://www.joellipman.com/articles/cms/website-development/php/php-script-make-your-own-thumbnail-generator-via-api.html

    have a client with about 10k images of products that they want to appear in a dropdown menu of a JavaScript widget. When the user first loads up the webpage containing the widget, 10k images are downloaded. I have put in a lazy loading process where it...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  6. Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/component/content/article/google-authentication-oauth-2-0-using-php-curl.html?catid=61&Itemid=165

    and to either create a token file, or use the existing one as long as it hasn't expired. Update 2019 This script requires a user to authenticate the google account. I have a newer article called Google Drive API v3 - OAuth2 using Service Account in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  7. List all cron jobs for all usershttps://www.joellipman.com/component/content/article/list-all-cron-jobs-for-all-users.html?catid=63&Itemid=165

    # Add all of the jobs from the system-wide cron directory. cat "${CRONDIR}"/* | clean_cron_lines >>"${temp}" # */ # Add each user's crontab (if it exists). Insert the user's name between the # five time fields and the command. while read user ; do...

    • Type: Article
    • Author: Joel Lipman
    • Category: Linux
    • Language: *
  8. DataScramble - Randomizing data rowshttps://www.joellipman.com/articles/else/database/t-sql/datascramble-randomizing-data-rows.html

    DateOfBirth ----------- -------------------- ------------- 1 John Smith 1990-03-21 2 Fred Bloggs 1988-11-02 3 Another User 1985-07-11 4 Yet Another User 1977-06-25 After: StudentID StudentName DateOfBirth ----------- -------------------- ------------- 1...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  9. Country Lookup by IP address CSVhttps://www.joellipman.com/articles/else/database/mysql/country-lookup-by-ip-address.html

    the second time. Modify the PHP file to use database login credentials, $db_host = "localhost"; // Database host name $db_user = "my_database_user"; // User for database authentication $db_pass = "my_database_password"; // Password for database...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  10. A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/cms/website-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

    /asn=d:\applications\siapp\vision\dev\adm\svrside_batch.asn stutalk usr_code=«your_user_code» smg_code=CAPCHG xpt_code=7day tracemess=3 limit=600 dot The EOT Monitor should have a shortcut similar to the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
  11. MediaWiki: MySQL to extract path to imageshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-mysql-to-extract-path-to-images.html

    all images that had also been either added/modified since. How? Using MySQL, the following query lists the image name, size, user who uploaded, timestamp and the path. Remember that the paths are determined using the MD5 Hash of the filename: select...

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

    Internet (accesses http://news.google.com/) Checks you are a local administrator on your computer (should just need normal user credentials but if you get prompted to run the program as a different user and can't run the program this may be why) Checks...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  13. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

    fields/columns viewable is the file upload or attachment field In Zoho Creator, in the "Edit" mode, go to "Settings" Under "Users and Control" click on "Publish" On the same row as your report, click on "Get embed Code" (ensure this report is published)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  14. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

    and attachments. How? As per our use-case above, we are going to create a button off the contact record which when the user clicks on it will generate a PDF of the merged template and attach it to the CRM contact record under "Attachments". As a quick...

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

    lead owner ID and lead ID record v_LeadOwnerID = 5432109876543210987; v_LeadID = 4321098765432109876; v_CustomerName = "Test User"; // // build map to schedule a call m_ScheduleCall = Map(); m_ScheduleCall.put("$se_module","Leads");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  16. ZohoCRM: ZDK Client Script to retrieve Contact Emailhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-zdk-client-script-to-retrieve-contact-email.html

    // return false to prevent saving of record return false; Caveat(s) This only happens if the record is being edited (as in user clicked on "Edit") rather than the inline edits that can be done (eg. user clicked on field in view mode and edited just one...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  17. Zoho Analytics: Determine profits from invoices and purchase ordershttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

    that are required for the above but you may want to use the out-of-the-box modules instead: Sometimes, a salesperson or user might be generating an invoice on behalf of the account manager (person who manages the customer's account), so let's get the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  18. ZohoBooks: Stripe Terminal Integrationhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-stripe-terminal-integration.html

    Function: Map Take_Payment( Map invoice, Map organization, Map user) Label: Take Payment Trigger: On button click Purpose: Preps stripe terminal to take payment for balance of invoice. Inputs: invoice Outputs: - Date Created: 2023-02-24 - Initial...

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

    code to query the shipment status based on a tracking number. Becoming a DHL Developer Browse to https://developer.dhl.com/user/register to Signup Complete the form with your details > Confirm via Email Create an app as described under Get Access...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  20. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/component/content/article/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html?catid=129&Itemid=165

    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 Users... didn't really test on permissions and sharing the report, I was logged in as the super admin on both ZohoDesk and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Desk
    • Language: *
Results 61 - 80 of 188