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

  1. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttp://mail.joellipman.com/articles/crm/zoho/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

    article is just in case it comes up again (has twice now) where a client wants a report on candidates and associated job openings in Zoho Recruit. Why? We're creating a custom module where our client wants to query Zoho Recruit via the API but couldn't...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. Zoho Inventory: Enable Tracking using the APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-inventory-enable-tracking-using-the-api.html

    info "ITEM CREATE RESPONSE FOR " + v_ItemID; info r_CreateItem.get("message"); Error(s) Encountered items with opening stock cannot be deleted, set the opening stock to zero: Guess who's going to have their opening stock set to zero, save the record,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. Zoho Deluge: Loop through 30 Minute Slotshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-loop-through-list.html

    The picklist field is called "Time_Field". The following reads from a form (creator data table) where thisServiceRecord.Opening_Time is returning an hour value (eg. "08:00") and thisServiceRecord.Closing_Time returns an hour value (eg. "20:00"). This...

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

    for each v_Day in l_DaysCorrectOrder { m_ShiftBuildUp.put(v_Day, m_ShiftRow); } // // ok let's get the opening times if(m_OrgDetails.get("custom_timing") != null) { l_CustomTimings = m_OrgDetails.get("custom_timing"); for each r_Timing in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. MS Excel - Open CSV with Long Numbershttp://mail.joellipman.com/articles/microsoft/excel/ms-excel-open-csv-with-long-numbers.html

    This is a quick reminder for myself on opening a CSV in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway). My Data: Account ID,Name,Phone,Record ID...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  6. Windows 7 Aero Featureshttp://mail.joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

    are these Aero effects? Aero Peek: Aero Peek What this is it gives you a preview of windows in a thumbnail without actually opening them by simply hovering over the icon in the taskbar. Click on one of them and you will be taken to that window, this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  7. Joes FREE Website Thumbnailer (JWT)http://mail.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

    the past and I have found it easier to answer comments on the website (rather than managing moderators, posts/topics, and opening any other can of worms, etc). Either use the website to contact me or email me at info@joellipman.com. I will do my best to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  8. Returning Oracle Stored Procedure Resultset in SSRShttp://mail.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

    INTO p_STUDENT_REF FROM student_accounts WHERE student_accounts.student_username = p_STUDENT_ADNAME; -- opening cursor for the select query that I want to display in SSRS OPEN l_CURSOR FOR SELECT INITCAP(b.p_title) || ' ' || INITCAP(b.p_forenames) || '...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  9. No rows returned in Oracle causes SP to failhttp://mail.joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

    again: ORA-00936: missing expression 00936. 00000 - "missing expression" The solution was to enclose the subquery with an opening and closing parenthesis. -- Erroring: SELECT NVL( SELECT student_accounts.student_username FROM student_accounts WHERE...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  10. Sync Outlook 2007 Shared Calendar with SharePoint 2007http://mail.joellipman.com/articles/microsoft/sharepoint/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html

    steps show you how SharePoint will open a shared calendar if you don't already have it in your Outlook 2007. Similar to you opening a shared calendar, the sharepoint calendar will sit separate to the others. Once it's in your Outlook, you can copy over...

    • Type: Article
    • Author: Joel Lipman
    • Category: SharePoint
    • Language: *
  11. Proposed Budget i3 PC under £200http://mail.joellipman.com/hardware/proposed-budget-i3-pc-under-200.html

    workstation upgrade running Windows 7 So another year gone and our workstations running Windows 7 are somewhat lagging when opening too many apps. The recent release of Windows 8 has led to a review of our developer's equipment and the verdict is that...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  12. Administrator Program Shortcut without Prompthttp://mail.joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

    (Pinned): %APPDATA%\Microsoft\Internet Explorer\Quick Launch\User Pinned\TaskBar. You can determine what %APPDATA% is by opening a command prompt and typing: echo %appdata%

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  13. Regular Expression Basic Usage Exampleshttp://mail.joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

    not match the following strings: abcdef abc The backreference counts subexpressions from left to right starting with the opening parenthesis of each preceding subexpression. The backreference lets you search for a repeated string without knowing the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  14. T-SQL: Parse an XML valuehttp://mail.joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

    TEAM GENERAL DOGSBODY 2014-03-01 Y INSERT 2014-03-27 Extracting the Gender: We're going to extract the value in between the opening and closing XML tags: -- Using .query() SELECT CAST(CAST(Event_XML AS XML).query('data(/STAFF/GENDER)') AS VARCHAR(10))...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  15. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

    but always on Desktop 1. In addition, there are some developments on AutoHotkey forums where people are having difficulties opening an app on their second monitor. So I thought I'd jot down some notes here on how I've achieved this across multiple...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  16. Zoho Creator: Create a Widget which uses JavaScripthttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

    Safari browser, there will be a log in the terminal: Editing the Widget So let’s modify the widget.html file in this app by opening a finder/file explorer window and browsing to the app folder: Then open the file “widget.html” in your favorite code...

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

    be better, for example, for confirmation dialogs (embedded form). Source(s): Zoho Creator v4 - Functionality based URLs - Opening a form with a record pre-loaded. Zoho Creator v5 - Print and export using URL - Export a record template as PDF Zoho...

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

    you're lucky enough to build an application for a client based in a country that changes its clocks twice a year, then I'm opening this article without a 100% certain solution as I need to wait about 4 months until I can confirm this works. Why? I've...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 1 - 18 of 18

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.