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

  1. Zoho Creator: Copy Subform to other Subformshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-copy-subform-to-other-subforms.html

    input.Thursdays.insert(c_Thursday); input.Fridays.insert(c_Friday); input.Saturdays.insert(c_Saturday); // // [OPTIONAL] Reset the decision box to false input.Copy_Monday_to_the_Other_Days = false; } The Result So now when I tick this decision box, I...

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

    m_ScheduleCall.put("Call_Status","Scheduled"); m_ScheduleCall.put("Call_Type","Outbound"); // // optional fields m_ScheduleCall.put("Call_Purpose","Prospecting"); m_ScheduleCall.put("Call_Agenda","A scheduled call to phone " + v_CustomerName + " at...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-real-time-invoices-receive-webhook.html

    Here's an overview of how we achieve this: Set up a Zoho CRM function to receive the webhook. Setup a webhook in Xero. [Optional for Method #2] Setup a PHP script on a server that will validate the Xero webhook. You're going to need to respond to Xero...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  4. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-inventory-upload-image-to-item-record.html

    to ZohoBooks: // // declare ID of item in Zoho Inventory v_InventoryId = 123456789012345678; // // your organization ID (optional) v_BooksOrgId = 20220621; // // download photo from eBay r_DownloadedPhoto = invokeurl [ url :v_EbayPictureUrl type :GET ];...

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

    so check that your connection has the scope to access both Organization details (ZohoCRM.org.READ is enough - perhaps optional) and access to Settings (ZohoCRM.settings.READ). I'm calling mine "mycrmconnection". r_OrgDetails = invokeUrl [ url:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  6. Zoho Projects: Get All Eventshttps://www.joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-get-all-events.html

    decided as we only want one v_ProjectName = "My Project Board"; v_ProjectID = "1234567000001234567"; // // get all users (optional here) v_EndpointUsers = v_BaseURL + "/restapi/portal/" + v_PortalID + "/projects/" + v_ProjectID + "/users/"; r_Users =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Projects
    • Language: *
  7. ZohoCRM: Make either Mobile or Email mandatoryhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-make-either-mobile-or-email-mandatory.html

    really quick article on a pretty cool requirement, making 2 fields mandatory but if one is completed then making the other optional. Why? My use-case is that the mobile or email field on a Zoho CRM contact record is used to authenticate the contact on a...

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

    { for each m_LineItem in m_RecordData.get("Quoted_Items") { if(!isNull(m_LineItem.get("id")) && !m_LineItem.get("Optional")) { // add here line items that will be added or updated m_NewLineItem = Map(); m_NewLineItem.put("id",m_LineItem.get("id"));...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  9. Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

    }).catch(function(error) { console.log("Error:"); console.log(error); }); }); ZOHO.embeddedApp.init(); [Optional] What follows is the code for the function fn_Accounts_CreditSafe... obviously I can't give you the real Zoho Deluge function here as it...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. Zoho People: Get Performance Records over APIhttps://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-get-performance-records-over-api.html

    update all the rows." Need to include the criteria along with the columns and the "addIfNotExist" attribute Additional / Optional stuff to do but please don't waste your time. Out of sheer boredom: fn_GetMetaData_FormsFields v_NewLine = hexToText("0A");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  11. Zoho Survey: Zoho CRM Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-survey-zoho-crm-webhook.html

    = zoho.crm.createRecord("Contacts", m_CreateContact); info "Creating CRM Contact: " + r_CreateContact; } /* OPTIONAL: Send yourself an email sendmail [ from :zoho.adminuserid to :"me@mycompany.com" subject :"TEST: Survey has been submitted" message...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  12. Change the default Joomla Error templatehttps://www.joellipman.com/articles/cms/joomla/change-the-default-joomla-error-template.html

    "The Page you are looking for..." to what you want. Change the link "www.joellipman.com" to the "www.yoursitename.com". [Optional] If you want the image that creates the shadow you can download it here. I put it in the folder \templates\system\images.

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  13. Improve Default Joomla Search https://www.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

    '.$sql_keyword.',\'\'))) / LENGTH('.$sql_keyword.'))) AS relevance '); « Show Me » [Same file again and optional if your search opts to search archived articles] \plugins\search\content\content.php: Insert this between the if ($sArchived && $limit > 0){...

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

    you have no jComments in the new system (why -- should you have new ones? This is a site migration not an upgrade). -- [Optional: Clear jComments and reset table index with DELETE and ALTER] -- NOTE: One-line inserts only apply where the column count is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  15. Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://www.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

    new admin ID is 111, previous admin ID is 222, and general information desk account is 333), remove other super admins (optional) I also noted the previous admin's ID and returned their super admin status. Sorted by group_id desc and changed 8 to 2....

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  16. MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/component/content/article/macos-transcribe-training-video-using-openai-whisper.html?catid=60&Itemid=165

    app Type brew install ffmpeg Extract audio: ffmpeg -i your_video.mp4 -vn -ar 16000 -ac 1 -b:a 64k output_audio.mp3 [Optional if using online version of OpenAI Whisper] Split audio into segments: ffmpeg -i output_audio.mp3 -f segment -segment_time 600 -c...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  17. Android: Keytool and Google Maps displaying greyhttps://www.joellipman.com/articles/else/app-dev/android-os/android-keytool-and-google-maps-displaying-grey.html

    to the Google APIs console (there's so many) when I should be using the App SHA1 (I have now added both to the console). [Optional] To use the keytool: If you know the command prompt, you know that you have to refer to each tool using their full path...

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

    the Date was blank and puts a NULL string. The second takes this string and converts it to a date: -- Assuming EndDate is optional (can be null) and in format DDMMYYYY: -- Derived column task 1: Replace 'Date' TRIM(Date) != "" ? TRIM(Date) : "00000000"...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  19. SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/component/content/article/ssrs-dropdown-to-allow-blank-values.html?catid=75&Itemid=165

    dropdown populated by a list of all available reports. Why? I want the report to be run with the 3rd and 4th parameter as OPTIONAL. When I leave the 3rd and 4th parameter untouched (=""), the report complains saying "Report #3 parameter cannot be...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  20. 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

    The Long Fix Now below are the notes I've had to try and fix this before (personally it was because Microsoft released an optional windows update that fixed my issue. check that this issue isn't being caused by any Windows 7 desktop gadgets. Quit/close...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
Results 21 - 40 of 44