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

  1. Report Builder 2.0 - Hide Series1https://www.joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

    data fields: Count the total number of incidents logged (Y-axis - data fields) Invidividual the incident(s) are assigned to (Labels - series fields) Months the incident(s) were closed (X-axis - category fields) My SQL Query is: SELECT...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  2. Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

    HHT_TOLEFT = $0800 ;#End Region ;#Region List View sub item portion Const LVIR_BOUNDS = 0 Const LVIR_ICON = 1 Const LVIR_LABEL = 2 ;#End Region ;#Region Cursor Type Const IDC_ARROW = 32512 Const IDC_IBEAM = 32513 Const IDC_WAIT = 32514 Const IDC_CROSS =...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  3. Excel PivotTable Filter List Orderinghttps://www.joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

    comes before February but not alphabetically, so let's do this as an example: Move the field from "Report Filter" to "Row Labels" (put it at the top as parent) Right-click on the pivotTable on one of the values of the row label you just moved Select...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  4. Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

    Catalog WHERE Type = 2 ORDER BY Name If you want to use these datasets, parameter options should be that the Name is the "Label" and ItemID is the "Value", just in case you didn't pick up on this. If no type is specified (type=2) then datasources and...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  5. SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

    from a query" = Select the dataset of dropdown options, pay attention to the value in "Value field" (as I kept putting the label rather than the value field) to make this all work. Notes: My convert part of my SQL query is because I had to match the...

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

    specific case the color grey. value="Name:" - give this field a default value. In this specific case, we are giving it the label value to indicate to the user to enter their Name (as in forename or surname). onFocus() - What to do when the user moves...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: en-GB
  7. Parse a HTML Table into a ListViewhttps://www.joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

    } LV_ModifyCol() Method #2 This method only uses two columns with the label being a concatenation of the value of the first column and the column heading. StringReplace,ReturnedHTMLTableRows,ReturnedHTMLTable,,|,A...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: en-GB
  8. Things to Check if Joomla Password Reminder email not being senthttps://www.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

    message even exists: Login to your Joomla Admin Panel Navigate to Extensions > Language Manager Click on the “Overrides” label Click on “New” (but don’t create a new one – we’re just checking something) In the right pane, type...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  9. Android: Keytool and Google Maps displaying greyhttps://www.joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

    Files\Java Determine your JDK folder dir jdk* and append the \bin. Note this for later. Right-click on the "Computer" icon/label (desktop / start menu) Select Properties Click on Change settings or Advanced system settings Select the Advanced tab Click...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  10. Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

    Bug: Correction if only one exclusion category selected - Date Uploaded: Thu, 27th Mar 2014 3.2.1 JoomlaGate- Enhancement: Label parameters in XML and language file review - Date Uploaded: Tue, 18th Mar 2014 3.2- Fixed Bug: Redeclare function issue when...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  11. Import Excel CSV file as JavaScript arrayhttps://www.joellipman.com/articles/microsoft/excel/import-excel-csv-file-as-javascript-array.html

    I have: A CSV file exported from Excel along with double-quotes label1,label2 item1a,item2a item1c,"item2c,c" item1b,item2b What I want: To read the file (stored on the server) and convert to a JavaScript array of objects var my_object_array = [ {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  12. Convert Past Date to Time Ago in PHPhttps://www.joellipman.com/articles/web-development/php/convert-past-date-to-time-ago-in-php.html

    etc..."). function getTimeAgo($p_Date) { // get seconds ago $v_Seconds = strtotime('now') - strtotime($p_Date); // set unit labels $a_UnitLabels = array('year','month','week','day','hour','minute','second'); // set unit values $a_UnitValues = array(...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  13. Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://www.joellipman.com/articles/crm/zoho/zoho-crm-update-a-custom-field-in-line-items-product-details.html

    Again at the time of this article, this is only modifiable when using REST API v2.1. We are going to update the field with label "Group Name" but API name "Grouping" in a list item column. The standard code you used to use even for REST API v2.0 would...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. Zoho CRM: Change System Field Lengthhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-change-system-field-length.html

    I have used and that worked when converting a lead to a deal. Note that this hack doesn't work on the system field label name (I tried) just on the length field. Use the translations file to change system field labels The fix put simply is a CSS hack....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. Zoho Books: System Values Mapshttps://www.joellipman.com/articles/crm/zoho/zoho-books-system-values-maps.html

    for each m_PaymentTerm in l_PaymentTerms { m_PaymentTerms.put(m_PaymentTerm.get("payment_terms_label"),m_PaymentTerm.get("payment_terms")); } info m_PaymentTerms; // // --------------------------------- // get sales persons m_SalesPersons = Map(); /*...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  16. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

    Function: void fn_Tickets_OnCreateEdit(int p_Ticket) Label: Fn - Tickets - On Create or Edit Trigger: Off a workflow when a ticket is created or modified Purpose: Pushes the tickets attachments to Zoho Analytics Inputs: - Outputs: - Scope(s): Date...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  17. Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

    top; } /* main content */ #my-content table:first-child td{ vertical-align:top; } #my-content table:first-child label{ text-transform: uppercase; color: #777; display:inline-block; width:100px; } #my-content table:first-child span{ font-weight:400;...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

    Function: void fn_Leads_FollowUpNonConverted(Int p_LeadID) Label: Fn - Leads - Follow Up Non Converted Lead Trigger: Triggered 24 hours after a lead is created. Purpose: Follow up when a lead is created and not converted within 1 day send an email and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  19. Zoho Analytics & Zoho People: Monitor DataSource Sync https://www.joellipman.com/articles/crm/zoho/zoho-analytics-zoho-people-monitor-datasource-sync.html

    Function: void Check_DataSources_Sync_to_ZohoAnalytics () Label: Check DataSources Sync to ZohoAnalytics Trigger: Scheduled daily at 1am starting from tomorrow (3-Jul-2024) Purpose: To warn system managers if a sync started failing. Inputs: None...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  20. ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttps://www.joellipman.com/articles/crm/zoho/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

    Function: Map Related_Purchase_Orders( Map salesorder , Map organization , Map user , Map page_context ) Label: Related Purchase Orders Trigger: Displays on Sales Order record Purpose: To display related POs linked by a custom Sales Order lookup field...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 21 - 40 of 43

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.