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

  1. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

    [ url :v_Endpoint type :GET connection:"joels_connector" ]; if(!isnull(r_Response.get("fields"))) { // loop through every field to find the customer's timezone one for each r_Field in r_Response.get("fields") { if(r_Field.get("api_name") ==...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. Zoho Deluge: a HTML Entity Decoderhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-a-html-entity-decoder.html

    simply wrote a function in Zoho Creator for each instance that I knew a HTML entity would be submitted. So it doesn't decode every HTML in existence, only the ones I know will happen. Here's the Zoho Deluge code I use (note that I've put this in a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  3. Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

    or Edited" Execute the workflow when "When any field is updated" Filter the triggers when Status is "Paid" Just once or every time is "Everytime" Actions is a custom function called "fn_invoice_updatepaymentmethod" But this wouldn't work despite being...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  4. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://www.joellipman.com/articles/crm/zoho/zoho-recruit/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

    - 1; // // note that ordering here seemed to do nothing... it's in an order, not sure what order. Let's loop through every page anyway. l_Candidates =...

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

    Even in test mode or simply starting a Cliq conversation will now yield something like the following: Additional For every chat message, the OpenAI ChatGPT forgets what the context of the conversation was about: Well we can populate the list of messages...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  6. ZohoCRM: Get Organization Business Hours using Deluge/APIhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-get-organization-business-hours-via-deluge-api.html

    "days": "Saturday", "business_timing": [ "09:00", "15:00" ] } ], "daily_timing": null, "week_starts_on": "Monday", "same_as_everyday": false, "id": "123456789000000123456789", "type": "custom" } } Tidied Up Want that in a practical format for use in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  7. Zoho Deluge: Determine if Daylight Savings are in effecthttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-determine-if-daylight-savings-are-in-effect.html

    timezones between customer, agent, HQ, server; we would create a separate table to manage this data. I can't do this for every client, so here's a quick snippet to just check if Daylight Savings are in effect for the United Kingdom. How? Based on the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  8. Zoho CRM: Client Script Confirmation Box and Popup Mailerhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-prompt-and-popup-mailer.html

    repeating a script from the Zoho Kaizen series allowing a confirmation box (something lacking in Zoho Creator - but that every app outside of Zoho has) as well as a popup to email from CRM with a rich-text interface. Why? The use-case here is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  9. ZohoCreator: Using .toFile and Uploading to a Creator fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

    record and associated file. We have no intention of creating a new record per file... Saying that, the file name will change every time it is updated as you will see. Also note, I have a form called "Document", a report called "All Documents", and the...

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

    brief is: "Follow up when a lead is created and not converted within 1 day send an email and notification to sales person everyday for 3 days then escalate to a specified user". Why? Sorry Zoho! I tried using the interface to set up a workflow or any...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  11. Zoho Books / Inventory: Get Item Rate from a Price Book/Listhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-inventory-get-item-rate-from-a-price-book-list.html

    now. The code snippet to get the item record from the price book Note that I'm using a connection called "zbooks" and it has every permission under the sun (the naughty ZohoBooks.fullaccess.all) but according to documentation (to be taken with a grain...

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

    correct any inconsistencies themselves. How? We're going to add a scheduled workflow on a daily basis at 1am in the morning every day. This will be added to the client's Zoho People instance which will check the datasource metadata via the Analytics...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  13. ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

    than treat the number as a string and truncate it that way. Given the possible options of numbers given, it has to work with every number so here's both in Zoho Deluge Tryout: v_Rate = 12345.545; info "Rate: " + v_Rate; // built-in rounding v_Rounded =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  14. Add the website name to the page title in Joomla!https://www.joellipman.com/articles/cms/joomla/add-the-website-name-to-the-page-title.html

    to display both the actual page title and other stuff. As I like doing this for this particular website (my personal one) in every version of Joomla it's been upgraded to, I've noticed some differences that I've noted down below. Specific Joomla...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  15. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/component/content/article/google-drive-oauth-using-service-account-in-php.html?catid=61&Itemid=165

    to check your base64 encoded strings at JWT.io then it's hard because the timestamps, included in the encoding, change every second. You can get it verifying the signature successfully if you go get your public key, paste both keys into jwt.io (these...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  16. Mediawiki Extension for Camtasia Studio SWF videoshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

    to the wiki } Amend your skin files Amend your skins to include the reference to this script in between the head tags of every page, so Amend your LocalSettings.php file Add the following the the LocalSettings.php file in your mediawiki root folder:...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  17. SSIS Skip Blank Rows in Flat File Sourcehttps://www.joellipman.com/component/content/article/ssis-skip-blank-rows-in-flat-file-source.html?catid=74&Itemid=165

    the failure. Why? So the solution must be obvious to you by now. At least that's what Microsoft people think to themselves every time they see the error they programmed in. Apparently this problem also happens when you have a Data File of varying column...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  18. Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/component/content/article/room-availability-calendar-in-business-intelligence-development-studio.html?catid=75&Itemid=165

    Times([Time]) AS ( --Select First hour in range SELECT CONVERT(DATETIME,@StartTime) AS [Time] UNION ALL --Add a record for every half-hour in the range (change based on slot times) SELECT DATEADD(MI, 30, [Time]) FROM Times WHERE Time...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  19. Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/component/content/article/windows-7-system-clock-is-constantly-going-out-of-sync.html?catid=80&Itemid=165

    side for SpecialPollInterval The default time period is 7 days calculated in seconds. If you wanted to change this to update every day, you would use 86400, or 60 seconds * 60 minutes * 24 hours * 1 day. I wouldn’t recommend setting this to anything...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  20. Remove write-protect from USB pen in Windowshttps://www.joellipman.com/component/content/article/remove-write-protect-from-pen-in-windows.html?catid=80&Itemid=165

    to upgrade my 16Gb USB Integral Pen from Play.Com to a 32Gb equivalent. I use my USB pen as the "My Documents" folder on every computer I use. It was fine with my 16Gb one but my 32Gb ones have all failed at some point. I went for a cheap one on...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
Results 41 - 60 of 80