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

  1. ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-import-attachments.html

    Modified,FK,Zoho CRM ID,Original File Name and Path,New File Name and Path,Original Filename,New Filename,FileSize (KB),Reason`r`n" FileAppend, %v_CsvLine%, %v_RunFolder%\Errors.csv Loop % LV_GetCount() { v_FilesTotal := v_FilesTotal + 1 RowNumber :=...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. Zoho CRM & Zoho Creator: Query returns some fields missing other data on the recordhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-crm-zoho-creator-query-returns-some-fields-missing-other-data-on-the-record.html

    is that I was trying to build a related list in Zoho CRM with a view on to related records in Zoho Creator. For some reason, only some random fields were being returned, all pretty much useless to me. Well the "for some reason" turned out to be because...

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

    = "SPECIAL EDITION "; } // // other properties to add to the description v_ItemDescDisp = v_ItemDescDisp + "Awesome Reason To Buy This #1 "; v_ItemDescDisp = v_ItemDescDisp + "Awesome Reason To Buy This #2 "; // // condition grade v_ConditionChar =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  4. Zoho CRM: Updating a CRM record Custom Line Items using API v7https://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-updating-a-crm-record-using-api-v7.html

    m_NewLineItem.put("List_Price",m_LineItem.get("List_Price")); l_NewLineItems.add(m_NewLineItem); } } } // // if there is reason to update it then let's update CRM API v7 style if(l_NewLineItems.size() > 0) { // // build request to send to CRM v7 //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  5. Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

    INSERT INTO mydb_upgrade_j25.myprefix_jcomments_reports ( id, commentid, userid, name, ip, date, reason, status ) SELECT id, commentid, userid, name, ip, date, reason, status FROM mydb_livecopy_j15.myprefix_jcomments_reports; --...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  6. Migrating from Joomla 2.5.x to 3.4.xhttps://joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    INSERT INTO `v34_db`.`v34_jcomments_blacklist` ( `id`, `ip`, `userid`, `created`, `created_by`, `expire`, `reason`, `notes`, `editor` ) SELECT a.`id`, a.`ip`, a.`userid`, a.`created`, a.`created_by`, a.`expire`, a.`reason`, a.`notes`, a.`editor` FROM...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  7. Inserting incremental weeks in MySQLhttps://joellipman.com/articles/else/database/mysql/inserting-incremental-weeks-in-mysql.html

    (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different to normal people's week numbers is because these are academic week numbers. So I can't use the...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  8. GDPR Privacy Policyhttps://joellipman.com/component/content/article/gdpr-privacy-policy.html?catid=50&Itemid=165

    • Type: Article
    • Category: Static Items
    • Language: *
  9. AutoHotkey: Get Media Information and Displayhttps://joellipman.com/component/content/article/autohotkey-get-media-information-and-display.html?catid=48&Itemid=165

    that doesn't require any extra files and that could work on MS Windows 7 (32-bit) for this particular app. For this reason, we are going to use a function by Skan called Filexpro() which is copied in the below: Filexpro( sFile := "", Kind := "", P* ) {...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  10. Licence GNU/GPLhttps://joellipman.com/component/content/article/licence-gnugpl.html?catid=50&Itemid=165

    by this License, on a durable physical medium customarily used for software interchange, for a price no more than your reasonable cost of physically performing this conveying of source, or (2) access to copy the Corresponding Source from a network...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  11. MS-DOS: Copy folders without overwriting fileshttps://joellipman.com/component/content/article/ms-dos-copy-folders-without-overwriting-files.html?catid=51&Itemid=165

    drive to an external one. I wanted it to copy only the files that were new in the original folder and only copy those over (reason being, the archive is 4 terabytes and backing up only the changed files would speed things up). Applies to: Microsoft...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  12. Batch Process to rename multiple files using Windows DOShttps://joellipman.com/component/content/article/batch-process-to-rename-multiple-files-using-windows-dos.html?catid=51&Itemid=165

    to this by using the "CD" command (type "CD /?" for help) As I said, I'm going to use a short batch process (*.bat). The reason the instructions below use the command prompt are because the default setting for computers running MS Windows are set up to...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  13. Joe's Unduplicater (JUD)https://joellipman.com/component/content/article/joes-unduplicater.html?catid=53&Itemid=165

    Say you've got 100 media files, you sat there patiently waiting for 50 to convert and then cancelled the process for some reason. Your option is then to manually go through both folders and check which ones have already been converted and can now be...

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

    Could also be of some use if your portfolio is a bunch of online websites and you need screenshots of these. Whatever the reason, I needed a FREE option and everything available had a limit to its "FREE" services. There are websites that do this for me?...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  15. Joes Syntax Styler (JSS)https://joellipman.com/component/content/article/joes-syntax-styler-jss.html?catid=53&Itemid=165

    Recognizes SQL only Proposed Enhancements: Recognize PHP Recognize HTML Recognize AutoHotKey (AHK) Recognize CSS For this reason, please do not install this on a production website. Some of the parameters are experimental and not confirmed so future...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  16. Zoho Templates - Font size is inexplicably tinyhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-templates-font-size-is-inexplicably-tiny.html

    Wrapping all your HTML in : Ok it's used in bootstrap and few other frameworks so this should be obvious, but for some reason the header and footer of my code set with CSS {position:fixed} won't display on the first/cover page if I wrap the code in a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  17. Zoho Creator: info/alert/modal/popup notification for any userhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

    popup parameter, such as: openUrl("#Form:My_Confirmation_Popup?zc_Header=false","popup window","height=144,width=555"); The reason being, is that the top solution offers a very generic popup box that can be quickly modified with content/text and the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  18. Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://joellipman.com/articles/crm/zoho/zoho-people/zoho-people-reject-an-application-for-leave-in-deluge.html

    what that process was. Reading the brief, and having written many custom functions for other Zoho apps, it would stand to reason that the process would be: allow a user to apply for leave, then on save/submit, auto approve/reject the application based...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  19. Zoho CRM: Permission Denied for Quote Conversion Mappinghttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-permission-denied-for-quote-conversion-mapping.html

    invoice module (that's for their finance team using ZohoBooks), we disabled the CRM Invoice module. How? Therein lies the reason. For the quote conversion mapping, it needs the CRM Invoice module as well. Step by step fix: Login to ZohoCRM, go to Setup...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  20. Zoho Creator/Deluge: Calculating with Timezone Offsethttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-deluge-calculating-with-timezone-offset.html

    is at 10am. How? So adding a datetime field and calling this one the "Customers Appointment Time" is the wrong first step. Reason being is that datetime fields hold the time zone they are set in (ZohoCreator > Settings > Date and Time Settings); so as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
Results 1 - 20 of 35