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

  1. Zoho Creator: Change Radio into Tabshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-change-radio-into-tabs.html

    Tab_Section_7; // if(isNull(input.Tabs) || input.Tabs == "Quote") { show Tab_Section_1; } else if(input.Tabs == "Product Details") { show Tab_Section_2; } else if(input.Tabs == "Photos") { show Tab_Section_3; } else if(input.Tabs == "Shopify") { show...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  2. ZohoDeluge: Get All eBay Orders Given a From and Till Datehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zohodeluge-get-all-ebay-orders-given-a-from-and-till-date.html

    that this is for fixedpriceitems only. For auction ones, you would need to adjust the parsing code below to capture auction details. This includes a split for any multi-line item orders: // // declare variables to store order details in a JSON or...

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

    be sent to a bank and downloads it to the staff member's workstation. Why? Why is this a challenge? The file contains bank details and should not be stored anywhere. Generating a text or CSV file and then having it emailed to anyone is an easy task but...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  4. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/component/content/article/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html?catid=129&Itemid=165

    the top-right for "Settings" You should be in the "Organization Settings" Click on any page in the left sidebar (eg. Plan Details), your Org ID is in the URL as the last number after the slash (eg. "20012345678") Note this down for later use Create a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Desk
    • Language: *
  5. Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

    */ v_BooksOrgID = "12345678901"; v_BooksInvoiceID = 0; v_ZB_CustomerID = 0; // // get this order details from ZohoCreator c_ThisOrder = Order[ID == v_OrderID]; // // get this customer record from ZohoCreator c_ThisCustomer = Customer[ID ==...

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

    of this user (this CRM is set to GMT-07:00 with daylight savings in effect) v_ThisTimeZone = "Europe/London"; // // get details from lead record r_LeadDetails = zoho.crm.getRecordById("Leads",p_LeadID); // // get created time (no need to check if null?)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  7. ZohoCRM GetRelatedRecords INVALID_DATAhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-getrelatedrecords-invalid_data.html

    calls to go through a few thousand records and to update the related records. I was getting the error INVALID_DATA with the details being api_name:'data'... But this is shortcode, not an invokeURL. { "code":"INVALID_DATA", "details":{ "api_name":"data"...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  8. Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-using-remove-key-on-a-map.html

    use-case This is a snippet that gets the tags of a contact and copies it over to the deal record: l_Tags = List(); // r_DealDetails = zoho.crm.getRecordById("Deals",p_DealID); if(!isNull(r_DealDetails.get("Contact_Name"))) { r_ContactDetails = invokeurl...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  9. ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

    ??? - ??? ******************************************************************************* */ v_Pipeline = ""; r_RecordDetails = invokeurl [ url :"https://www.zohoapis.com/crm/v8/Deals/" + p_DealID + "?fields=Pipeline" type :GET connection:"zcrm" ];...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. Connect to Joomla database in standalone scripthttps://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

    these cannot be hardcoded. What? Any developer installing my component will do so on a website which uses different login details for their Joomla database. The example below demonstrates how to get these details and extract data from the database. How?...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  11. 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

    "" // wait for completion and if paragraph is ok Could you do the same with the attached please? Feel free to include details of what you know of [Video Topic]. Give the transcript to some popular LLMs: [Score: 7/10] I gave the transcript.txt file (all...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  12. 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

    on the calendar SELECT Room='TEST1', EventStart = '15:00:00', EventFinish='16:00:00', Status = '2', Tooltip='Some more details' UNION SELECT Room='TEST2', EventDate = '11:00:00', EventFinish='12:30:00', Status = '2', Tooltip='Some more details' ) SELECT...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  13. SSRS Hide results table if emptyhttps://www.joellipman.com/component/content/article/ssrs-hide-results-table-if-empty.html?catid=75&Itemid=165

    and no one has forever). Situation: I have a report which I've already completed and pretty chuffed with. It shows the details on a user-specified room taken from a room bookings system. Below the details, we've connected it to the assets database and...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  14. Restore MSSQL Error: Database is in usehttps://www.joellipman.com/articles/else/database/restore-mssql-error-database-is-in-use.html

    a restore from backup on a database but when you get the error: "... database is in use". -- SQL Server 2005 EXEC SP_WHO // details on who is logged in GO -- SQL Server 2008 EXEC SP_WHO2 // even more details GO -- Run as database owner to see ALL...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  15. SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/else/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

    some calculations for display [Month] = DATEPART(MONTH,d.[Date]), -- used to get the time of the event e.EventDate, --event details to display e.Note --CTEs defined above are used as the queries for the results FROM Dates d LEFT JOIN Events e ON...

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

    • Type: Article
    • Category: Static Items
    • Language: *
  17. Terms & Conditionshttps://www.joellipman.com/component/content/article/terms-conditions.html?catid=50&Itemid=165

    the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. There should be a copy of the GNU General Public License included in each download. If not, see www.gnu.org/licenses.

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  18. Privacy Policyhttps://www.joellipman.com/component/content/article/privacy-policy.html?catid=50&Itemid=165

    about third parties which we think you may find interesting if you tell us that you wish this to happen. You may request details of personal information which we hold about you under the Data Protection Act 1998. A small fee will be payable. If you...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: en-GB
  19. Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=53&Itemid=165

    --- Category Layout (text, text with images, include description). --- Display News Titles or Introtext? --- File details to display (based on User Level?) --- Textarea to edit the CSS - Added Admin Section: Statistics --- Report on most viewed ---...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  20. AwStats Data Parser (ADP)https://www.joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=53&Itemid=165

    identified by the labels mentioned below. What data does Joes Infographic for Joomla (JIJ) need? Summary Period Report (details on your awstats report) Monthly History (per month per year) Days of Month (per day this month) Days of Week (per day this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
Results 41 - 60 of 117