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

  1. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

    to a base64 or an SVG. ZohoCRM signatures seem to be unable to handle a lot of code or long URLs such as a base64 source URL for an image. The Plan Get company phone and website from Organization Details in ZohoCRM. Upload and get publicly-accessible...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. SSIS Convert a string into a datehttps://joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    There may be error messages posted before this with more information about the failure. -- often when processing a datasource, the function is being applied to a NULL date timestamp. Dealing with Date NULLs: Fix: Put conditional statements to account...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  3. SSIS Multiple Lookups in onehttps://joellipman.com/component/content/article/ssis-multiple-lookups-in-one.html?catid=74&Itemid=165

    name/description (eg. "M" to "Male", "Prof" to "Professor"). Why? Our extract phase in the SSIS package takes data from a source database and puts it in staging in the exact form it came through. Our transform package will convert the data and output it...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  4. The ReportServer Databasehttps://joellipman.com/articles/else/database/the-reportserver-database.html

    int NOT NULL Milliseconds spent processing the report. TimeRendering int NOT NULL Milliseconds spent rendering the report. Source int NOT NULL Source of the report exection (1=Live, 2=Cache, 3=Snapshot, 4=History) Status nvarchar(32) NOT NULL either...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  5. Zoho Cliq: Integrate OpenAI ChatGPT with Conversation Threadshttps://joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-chatgpt-with-conversation-threads.html

    { 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 = if(v_UserType=="bot", "assistant", "user"); }...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  6. Win32 Constantshttps://joellipman.com/component/content/article/win32-constants.html?catid=48&Itemid=165

    for copying this from another source but with lots of OpenSource developers disappearing and reappearing, the content is what I don't want to lose. ;// ;// Win32 Constants ;// ;#region Peek Message Flags Const PM_NOREMOVE = 0 Const PM_REMOVE = 1 Const...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  7. Joes Network Transmission Detector (JTD)https://joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=53&Itemid=165

    better measure of what data is being received/sent from your workstation. Download Available for download for FREE as OpenSource. Portable so no installation/setup (can run off USB). Source files included for you to check. No signups, etc required, have...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  8. Zoho Creator: Create a Widget which uses JavaScripthttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-create-a-widget-which-uses-javascript.html

    - includes Zoho One) macOS Catalina v10.15.7 Safari v14.0 MS Visual Studio Code v1.48.2 Prerequisites Download nodejs source code from https://nodejs.org/en/download/. Don't worry about knowing anything about nodejs, as long as you know JavaScript and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  9. Zoho Creator: Add a subform while creating a recordhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-add-a-subform-while-creating-a-record.html

    and my subform is called "Line_Items": // initialize variables //... this is a demo so... do your own... // // get source data r_QuoteDetails = zoho.crm.getRecordById("Quotes", 123456789012345678); // // transform variables for main record...

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

    to remind me and to keep reminding me of how to do this. Why? My use-case is that I have 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?...

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

    Deluge code against it to ensure that the data in Shopify is the same as in Zoho. In this case, Shopify is considered the source of truth and Zoho is the data to be overwritten, ensuring that Product IDs, Variant IDs, Inventory IDs, Current Selling...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  12. ZohoAnalytics: Pivot Campaigns vs Contactshttps://joellipman.com/articles/crm/zoho/zoho-analytics/zohoanalytics-pivot-campaigns-vs-contacts.html

    the client wanted a report on customers on each row and then the campaigns as columns. What we want: Contact Name Lead Source Campaign 1 Campaign 2 Campaign 3 ---------------- --------------- -------------- -------------- -------------- Joel Google Ads...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  13. Zoho Books: Generate Bank Text File for Downloadhttps://joellipman.com/articles/crm/zoho/zoho-books/zoho-books-generate-bank-text-file-for-download.html

    their workstation Here's what's happening in the background: File is generated FIle is attached to the last record of the source data File identifying number is returned from being attached File is opened in a new tab/window to trigger downloading. File...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  14. Zoho Webhooks & Shopify API: Keep Disappearinghttps://joellipman.com/articles/else/e-commerce/shopify/zoho-webhooks-shopify-api-automatically-restore.html

    m_WebhookLog.put("Body",m_Payload.get("body")); m_WebhookLog.put("Event_Type","Inventory Update"); m_WebhookLog.put("Source","Shopify"); m_WebhookLog.put("Data_Format","JSON"); r_WebhookLog = zoho.crm.createRecord("Webhook_Payloads",m_WebhookLog); */...

    • Type: Article
    • Author: Joel Lipman
    • Category: Shopify
    • Language: *
  15. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

    have named SYSTEM ADMIN); this reduces the amount of blame on the system manager believed to be assigning these manually. Source(s): Zoho Community - Zoho CRM - Zoho CRM Developer - Kaizen #36 - Tasks #API Some noteworthy notes from this source in case...

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

    A quick article on how to setup an automation that checks if a datasource synchronization between Zoho People and Zoho Analytics failed. This can be adapted to any data source for Zoho Analytics. Why? We're assisting a client implement Zoho People as...

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

    choose a workspace with the relevant data (in this case Zoho Books Analytics workspace) In the left sidebar, select "Data Sources" then click on the "Add Data Sources" button Select "Zoho Analytics Workspace" as the data source type. Select the relevant...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  18. Sort order a dropdown list in MS InfoPath without programminghttps://joellipman.com/component/content/article/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html?catid=73&Itemid=165

    it and select "Drop-down List Box Properties" Under "List box entries" select Look up values from an external data source Next to "Data source" click on Add Select "Create a new connection to" and then Receive Data Select SharePoint library or list Copy...

    • Type: Article
    • Author: Joel Lipman
    • Category: Infopath
    • Language: *
  19. How to change local folder for TFShttps://joellipman.com/component/content/article/how-to-change-local-folder-for-tfs.html?catid=79&Itemid=165

    avail. How? The way to change this was: Connect to your Team Foundation Server (for me this was already done) Go to File > Source Control > Workspaces Edit... the workspace which is causing the problem Change the local folder All the files on TFS should...

    • Type: Article
    • Author: Joel Lipman
    • Category: Team Foundation Server
    • Language: *
  20. Run commands for Windowshttps://joellipman.com/component/content/article/run-commands-for-windows.html?catid=80&Itemid=165

    Wizard netsetup.cpl Notepad notepad Nview Desktop Manager (if installed) nvtuicpl.cpl Object Packager packager ODBC Data Source Administrator odbccp32.cpl On Screen Keyboard osk Opens AC3 Filter (if installed) ac3filter.cpl Outlook Express msimn Paint...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
Results 21 - 40 of 192