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

  1. Zoho Deluge - First Monday of Month or Last Tuesday of Monthhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-first-monday-of-month-or-last-tuesday-of-month.html

    loop until we find a Monday. Same for the last Tuesday except that we will count backwards from the end of the month: if(input.Switch_Over_Day=="First Monday of Month") { v_NextMonthDate = zoho.currentdate.addMonth(1); v_NextMonthDateFirst =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
  2. Zoho CRM REST API: Stop Workflow from Triggeringhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-rest-api-stop-workflow-from-triggering.html

    = List(); l_Triggers.add("none"); m_Data.put("trigger",l_Triggers); v_Url = "https://www.zohoapis.eu/crm/v2.1/Quotes/" + input.CRM_Quote_ID; r_CreateCrmQuote = invokeurl [ url :v_Url type :PUT parameters:m_Data.toString() connection:"ascentbusiness" ];...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. Zoho Creator: Assign an integration field value with an integration valuehttps://www.joellipman.com/articles/crm/zoho/zoho-creator-assign-an-integration-field-value-with-an-integration-value.html

    I have an integration field on my form called "CRM Account" with field link name "Account"; Then I have a workflow on user input of the field to save this directly to the record; You would think the following would work: r_Details = myForm[ID ==...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. Zoho CRM & Creator: Download attachment and upload to Creator file fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-download-attachment-and-upload-to-creator-file-field.html

    = v_NoteAttachments + " " + v_DateAdded + " " + v_LinkToDownload + " "; } } v_NoteAttachments = v_NoteAttachments + " "; input.Note_Attachments = v_NoteAttachments; Here's the code at the end of the parent form to hide the columns I don't need the user...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. Zoho Inventory: Mark a package slip as delivered and shippedhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-mark-a-package-slip-as-delivered-and-shipped.html

    Org ID v_BooksOrgID = 123456789; // // check the form was ticked and there is a package ID specified if(input.Mark_as_Complete && input.Zoho_Package_ID != "") { v_PackageID = input.Zoho_Package_ID; r_PackageSlip =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  6. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttps://www.joellipman.com/articles/crm/zoho/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

    = false; v_EstimateID = "-"; v_OrgId = "123456789"; v_Output = "Unable to process request"; // // evaluate v_Intent = ifnull(input.p_Intent,"-"); v_QuoteRef = ifnull(input.p_QuoteRef,"-"); v_CustomerID = ifnull(input.p_CxID,"-"); // // Search ZohoBooks...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  7. Using a HTML form and PHP to upload a filehttps://www.joellipman.com/articles/web-development/php/using-a-html-form-and-php-to-upload-a-file.html

    Issue Basically you have a HTML form with an input field type of 'FILE' (ie. ) and want a PHP file to process this. This example applies to a Linux Apache MySQL PHP (LAMP) environment. The Solution 1. The first thing to do is check that your HTML form...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  8. Using MetaMod to hide buttons from logged in usershttps://www.joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

    in users only' then scroll down to the list of available modules and find the "ID" number for your "pubmenu" item and then input that number in the "Quick Module ID Include" field. 6. Copy metamod_pubmenu, edit and rename it to metamod_regmenu. Then, on...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  9. Add Image Mouseover effect in AutoHotkey GUIhttps://www.joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

    Picture, x573 y40 w93 h96 vSearchButton gSearch, %A_ScriptDir%\search_globe.jpg Gui, Add, Edit, x45 y40 w520 r1 vSearchTextInput Limit70, Search... Gui, Show OnMessage(0x200, "WM_MOUSEMOVE") Return ; FUNCTION TO HANDLE BOTH TOOLTIP AND MOUSEOVER EVENT...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  10. SSIS Convert a string into a datehttps://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

    Error: An error occurred while attempting to perform a type cast. [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Convert Date" (4228) failed with error code 0xC0209029 while processing input...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  11. Zoho Deluge: Loop through 30 Minute Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-loop-through-list.html

    zoho.currenttime && v_CheckTime1b >= v_OpeningTime.toTime() && v_CheckTime1b < v_ClosingTime.toTime()) { input.Time_field:ui.add(v_CheckTime1b.toString("h:mm") + v_CheckTime1b.toString("a").toLowerCase()); } if(v_CheckTime2b > zoho.currenttime &&...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  12. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://www.joellipman.com/articles/crm/zoho/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

    task on the expiry date/time to delete this entry for both house-keeping and security? with the following deluge if(!isnull(input.ID)) { delete from Download_File[ID == input.ID]; }

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. Zoho Creator: Disable/Hide the add and delete subform row buttonshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-disable-hide-the-add-and-delete-subform-row-options.html

    v_CssNotes = v_CssNotes + ""; // // add to the notes field (also overrides the displayed note of "Add your Note here...") input.CSS_Overrides = v_CssNotes; Additional If you don't want to apply this to the every subform on that form, you will need to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

    = Map(); m_Response.put("todo","prompt"); l_Messages = List(); // // capture latest message from user v_Message = ifnull(userInput,""); m_Thread = Map(); m_Thread.put("role","user"); m_Thread.put("content",v_Message); l_Messages.add(m_Thread); // // if...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. Zoho Deluge - Pad with leading Zeroshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-pad-with-leading-zeros.html

    find the following example: string padWithLeadingZeros(int finalStringLength, int startingNumber) { return leftpad(toString(input.startingNumber), input.finalStringLength).replaceAll(" ", "0"); } This looks like pretty old code and not wanting to cause...

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

    Label: Fn - Quotes - On Edit Trigger: Used in a workflow when a quote is modified Purpose: Actions when a quote is modified Inputs: int p_QuoteID - the ID of the CRM Quote Record Outputs: void Date Created: 2024-12-10 (Joel Lipman) - Initial release...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  17. Mediawiki Extension for Camtasia Studio SWF videoshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

    { global $wgParser; $wgParser->setHook( "bukbplayer", "renderFlvPlayer" ); } function renderFlvPlayer( $input, $argv ) { $result = $flvPlayerFile->render(); return $result; // send the final code to the wiki } Amend your skin files Amend your skins to...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  18. Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    CMS. Cross your fingers and use your DB management tool to run the SQL file (or copy the contents of the SQL file into the input field) Re-build/Auto-correct some Joomla inconsistencies Login to your Joomla Admin Panel using a System Administrator...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  19. No rows returned in Oracle causes SP to failhttps://www.joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

    We have a stored procedure which contains two select queries. The first query will retrieve a student ID number where the input parameter is the student's username. The second query will return data using the student ID number found in the first query....

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  20. Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

    field was created with the following code: Explanation type="text" - standard attribute that tells the field this is an input field for single line of text. name="name" - attribute that assigns a variable name to this field so we can reference it later....

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: en-GB
Results 21 - 40 of 64

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.