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

  1. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttps://joellipman.com/articles/crm/zoho/zoho-books/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

    = "Thank you for accepting your quote! We'll be in touch soon to finalize the next steps and get everything ready."; } else if(v_Intent == "Decline") { b_ValidResponse = true; // // Mark the estimate as declined r_Decline = invokeurl [ url...

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

    v_OrgId, r_UpdateBooksInvoice.get("invoice").get("invoice_id"), m_ZB_Update, "zbooks"); } } else if(!isNull(r_UpdateBooksInvoice.get("message"))) { v_OutputResponse = "FAILED: " + r_UpdateBooksInvoice.get("message"); } It's a cop-out I know, but it...

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

    "Response from function was unparseable"; parsedOutput = " Error: " + errorOutput + " "; document.writeln(parsedOutput); } else { // If parsedOutput is an object, you can now use normal dot notation: if (parsedOutput && typeof parsedOutput === "object")...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  4. Google Authentication - OAuth 2.0 using PHP/cURLhttps://joellipman.com/component/content/article/google-authentication-oauth-2-0-using-php-curl.html?catid=61&Itemid=165

    which accesses a Google Drive using a Service Account (unattended). Why? This is a big cop-out as I simply took someone else's functions and upgraded them to use the mentioned token based authentication. I find myself going through the motion and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  5. Search a database for a string (MySQL, T-SQL)https://joellipman.com/articles/else/database/search-a-database-for-a-string-mysql-t-sql.html

    to search an entire database for a particular string of word(s). I've posted my own as well as some others I've lifted from elsewhere, as they worked with my environment, to put them in one place on a website I've bookmarked (my personal site :c) My own...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  6. T-SQL Conversion failed when converting the varchar to data type inthttps://joellipman.com/articles/else/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

    CASE WHEN emp.ContributionValue=1 THEN 5010 WHEN emp.ContributionValue=2 THEN 5011 WHEN emp.ContributionValue=3 THEN 5012 ELSE 9999 END FROM [dbo].[DMExtractEmployeeTable] emp INNER JOIN [dbo].[DMExtractReferenceTable] ref ON RIGHT(emp.[PayCode],3) =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  7. SQL Queries for Statisticshttps://joellipman.com/articles/else/database/mysql/sql-queries-for-statistics.html

    'Macintosh') THEN 'Mac' WHEN INSTR(a.VisitorUAgent, 'X11') THEN 'Linux' WHEN INSTR(a.VisitorUAgent, 'Linux') THEN 'Linux' ELSE 'Other' END VisitorOS, COUNT(a.VisitorUAgent) 'Total' FROM custombu_stats_visits a WHERE YEAR(a.DateTimeStamp)='2010' GROUP BY...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  8. MySQL parameters in Excel 2007 PivotTableshttps://joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    'Monday' WHEN 1 THEN 'Tuesday' WHEN 2 THEN 'Wednesday' WHEN 3 THEN 'Thursday' WHEN 4 THEN 'Friday' WHEN 5 THEN 'Saturday' ELSE 'Sunday' END AS ActivityDay, DATE(s.DateTimeCreated) AS ActivityDate, MIN(s.DateTimeCreated) AS DataFrom,...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  9. Zoho CRM: Update Opportunity Type as New or Existing Businesshttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-update-opportunity-type-as-new-or-existing-business.html

    Business"); r_UpdateOpp = zoho.crm.updateRecord("Deals",v_ThisDealID,m_UpateOpp); info r_UpdateOpp; } else { info "This is the first complete sales order so the opportunity type here is still 'New Business'."; } } else { info "This Sales Order is not...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. AutoHotkey Ternary Operatorhttps://joellipman.com/component/content/article/autohotkey-ternary-operator.html?catid=48&Itemid=165

    on how to use ternary operators in AutoHotkey. A ternary operator for those who are unfamiliar with this is an "If...Then...Else..." statement written in a small amount of code, usually on one line, and exists in most programming languages. For Example,...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  11. Mootools - How to contain a menu sidebar between header and footerhttps://joellipman.com/articles/cms/website-development/mootools/mootools-how-to-contain-a-menu-sidebar-between-header-and-footer.html

    > match_lowest_y) { $('jdo_actions').style.position = 'absolute'; $('jdo_actions').style.top = match_lowest_y + 'px'; } else { $('jdo_actions').style.position = 'fixed'; $('jdo_actions').style.top = '5px'; } } else { $('jdo_actions').style.position =...

    • Type: Article
    • Author: Joel Lipman
    • Category: MooTools Framework
    • Language: en-GB
  12. Php convert filesizes to bytes kb mb gbhttps://joellipman.com/articles/cms/website-development/php/php-convert-filesizes-to-bytes-kb-mb-gb.html

    function formatSizeUnits($bytes) { if ($bytes >= 1073741824) { $bytes = number_format($bytes / 1073741824, 2) . ' GB'; } elseif ($bytes >= 1048576) { $bytes = number_format($bytes / 1048576, 2) . ' MB'; } elseif ($bytes >= 1024) { $bytes =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  13. Zoho Cliq: Integrate OpenAI ChatGPT with Conversation Threadshttps://joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-chatgpt-with-conversation-threads.html

    // add the answer text to the response map m_Response.put("text",m_Choice.get("message").get("content")); //break; } } } } else if(r_ChatGPTResponse.get("responseCode") == 429) { // store in response text m_Response = {"text":"I dont have any knowledge...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  14. Write a Calendar in Autohotkeyhttps://joellipman.com/component/content/article/write-a-calendar-in-autohotkey.html?catid=48&Itemid=165

    if (Check1=0) AND (((Check2=0)and(Check3=0)) OR (Check20)) DaysInMonth=31,29,31,30,31,30,31,31,30,31,30,31 else DaysInMonth=31,28,31,30,31,30,31,31,30,31,30,31 ThisMonthNum:=A_MM * 1 ; because we want 01 to equal 1 ThisDateNum:=A_DD * 1 ; because we...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  15. AutoHotkey Format Date and Format Secondshttps://joellipman.com/component/content/article/autohotkey-format-date-and-format-seconds.html?catid=48&Itemid=165

    ThisDays:=ThisDays - (ThisYears*365) Grammar:=(ThisDays=1) ? "" : "s" strVal=%strVal% %ThisDays% day%Grammar%, } else { Grammar:=(ThisDays=1) ? "" : "s" strVal=%ThisDays% day%Grammar%, } } If ThisHours>0 { Grammar:=(ThisHours=1) ? "" : "s"...

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

    files unused since n. /MINLAD:n :: MINimum Last Access Date - exclude files used since n. (If n...

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

    it and it works perfectly for me. And I guess I'll just keep testing but there is the issue that you can't do anything else while it's sitting there taking pictures; unless you have more than one screen. It's automation. The situation is that the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  18. Quadcopter App with Flight Restrictions (JQA)https://joellipman.com/component/content/article/quadcopter-app.html?catid=53&Itemid=165

    to use JoelLipman.com data Note: You should delete/uninstall this app or clear its data before giving your device to someone else as it can login to your online account automatically. Sharing: • Do not share security or personal details. • By default,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  19. Joes Google Map for Joomla (JGM)https://joellipman.com/component/content/article/joes-google-map-for-joomla-jgm.html?catid=53&Itemid=165

    extension I made for the Joomla Content Management System versions 2.5 or later. Why? Could have probably used someone else's. I think there's loads out there but thought making my own to do exactly what I want was quicker. Script Function This displays...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  20. Zoho Deluge - Get distance between two coordinateshttps://joellipman.com/articles/crm/zoho/zoho-deluge/get-distance-between-two-points-in-zoho.html

    v_MathPi = 3.1415926535897932384626433832795028841971693993751; if ((p_Lat1 == p_Lat2) && (p_Lng1 == p_Lng2)) { return 0; } else { v_RadLat1 = v_MathPi * p_Lat1 / 180; v_RadLat2 = v_MathPi * p_Lat2 / 180; v_Theta = p_Lng1 - p_Lng2; v_RadTheta = v_MathPi...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
Results 41 - 60 of 122