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 63 results were found.

  1. Zoho Creator/Deluge: Calculating with Timezone Offsethttps://www.joellipman.com/articles/crm/zoho/zoho-creator-deluge-calculating-with-timezone-offset.html

    Agent_Date_Time_End: // defaults v_AppointmentDuration = 30; // // get customer's requested time v_CustomersRequestedTime = input.Customers_Requested_Time.toTime(); v_CustomerTimeZoneName = "(+01:00) Europe/Luxembourg"; v_CustomerOffset = "+01:00"; //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. Zoho Creator: Radio group into Calendar Carouselhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

    the following CSS: label.zc-Calendar_Day_Select-label{display:none !important;} Then get rid of the round circles for radio inputs / and ensured the cursor remained as a hand to indicate clickable: div.zc-Calendar_Day_Select .choice-table-cell span...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

    want to tweak the code. There are also cases we don't want to use a standalone function as we want the code to read from the input fields dynamically and in real-time. To this end, I create a field called "Audit_Change" and then I add to it our workflow...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. Zoho Creator: Input Color Pickerhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-input-color-picker.html

    An article on creating a color picker from a specific palette using an input field of a radio type. Why? At the time of print, this feature is not provided out-of-the-box and getting our users to learn about hexadecimal color references and Red Green...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. Zoho Creator: Change Radio into Tabshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

    to remove the label "Tabs": v_Css = ""; v_Css = v_Css + ".zc-Tabs-label{display:none !important;}"; v_Css = v_Css + ""; input.Note_CSS = v_Css; Yields Then aligning these radio options horizontally: v_Css = ""; v_Css = v_Css +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  6. Zoho Projects: Add a Time Log to an Issue using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

    time field if using): // // init (from dropdowns you have made applicable to your Zoho Projects system) v_PortalID = ifnull(input.ZohoProject_Portal,0); v_ProjectID = ifnull(input.ZohoProject_Project,0); v_IssueID = ifnull(input.ZohoProject_Issue,0); //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  7. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

    requirements (do they ever?). The script must be able to be copied into other SSIS packages. Need the option to merely tick input column names rather than hardcode these. "It " should be an acronym for IT, so "IT Department" and "Director of IT"....

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  8. Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

    .COM: URL Syntax #1 // works in eBay v_ImageSrc = "https://creator.zoho.com/file" + zoho.appuri + "Portal_Listing_Report/" + input.ID + "/Main_Photo/image-download/" + v_ListingPublishKey + "?filepath=/" + v_Filename; URL Syntax #2 // works in eBay...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. Zoho Creator: Copy Subform to other Subformshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-copy-subform-to-other-subforms.html

    when the decision box "Copy Monday to the Other Days" is clicked it runs the following deluge script: // only run if true if(input.Copy_Monday_to_the_Other_Days) { // init c_Tuesday = Collection(); c_Wednesday = Collection(); c_Thursday = Collection();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

    for a more in-depth description of each item. HTML DOM, JavaScript, COM, Methods, document, value, element, form, name, ID, Input, Tag, selectedIndex, checked, innerText, innerHTML Methods - The following Methods will be used throughout this tutorial....

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  11. Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

    your stored procedure in Oracle (and grant execute for your SSRS user) Add a data source to your SSRS report Add an SSRS input parameter Add a dataset Query type: Stored Procedure Refresh fields button Parameter name (oracle input sp variable) and...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  12. PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !https://www.joellipman.com/articles/web-development/php/php-issue-simplexml-load-string-parser-error-input-is-not-proper-utf-8-indicate-encoding.html

    The error I get is something similar to: PHP Warning: simplexml_load_string(): Entity: line #: parser error : Input is not proper UTF-8, indicate encoding ! Bytes: 0xA0 0x3C 0x2F 0x73 in /home/public_html/my_folder/my_xml_processing_script.php on line...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  13. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirectshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-two-submit-buttons-on-a-non-stateless-form.html

    > Click on "New Workflow" Choose your form Run when a record is "Created or Edited" When to trigger workflow is "User input of a field" Choose Field "Save & Close" Name the workflow "OnSubmit_SaveClose" Add your deluge code that should: Validate the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

    it OnSubmit > click on Create Workflow Select you want to run some Deluge Script and plug in the following code if(!isnull(input.Zoho_Inventory_ID)) { // // specify your own Inventory/Books organization ID v_BooksOrgID = 20221234567; // // determine URL...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. MessageBox or AlertDialog in Android Javahttps://www.joellipman.com/articles/google/androidos/messagebox-or-alertdialog-in-android-java.html

    int arg1) { // Some stuff to do when cancel got clicked } }) .show(); Additional: Pre-populating default value and returning input Lots of confusing answers out there on the web but here's an all-in-one where I Open an AlertDialog designed with a custom...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  16. Zoho Deluge - Store and repopulate a multi lookup list in Creatorhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-store-and-repopulate-a-multi-lookup-list-in-creator.html

    available) // ************************************************************* // store already selected entries // if(!isnull(input.myLookup)) { // remember remember the 5th of november l_RememberLookup = List(); if(input.myLookup.size()>0) { for each...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
  17. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

    the tick box is unticked Form Workflows > New Workflow Select your form Run when Created or Edited When to trigger: User input of a field Choose Field: ZohoBooks Sales Order Ref Name it whatever: eg. OnUserInput_ZBSoRef Put the following Deluge code:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. Zoho Deluge: Zoho Bookings Get Available Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-zoho-bookings-get-available-slots.html

    && !isNull(r_AvailableSlot)) { v_HourCheck = r_AvailableSlot.getPrefix(":").toLong(); if(v_HourCheck < 12) { input.Morning:ui.add(r_AvailableSlot); v_CountMorning = v_CountMorning + 1; v_CountTotal = v_CountTotal + 1; } else if(v_HourCheck >= 12 &&...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  19. Keyboard and mouse shortcuts in Google Chromehttps://www.joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

    associated with the URL. Type the part of a URL between 'www.' and '.com', then press Ctrl+Enter. Adds www. and .com to your input and open the resulting URL. Type a URL, then press Alt+Enter. Opens the URL in a new tab. F6 or Ctrl+L or Alt+D Highlights...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  20. Joes Password Analyzer (JPA)https://www.joellipman.com/component/content/article/joes-password-analyzer-jpa.html?catid=40

    quickly checks any password you might want to try using and suggests variations on this. Simply type a word or phrase in the input field and let it do the rest. Background Joe's Password Analyzer is a Joomla 2.5.x component which simply displays a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
Results 1 - 20 of 63

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.