Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 I had to insert a Matrix rather than a Tablix: Insert a "Matrix" into the body of your report. Drag "ReportName" into the field that says "Columns". Right-click on the grey left margin and select "Insert Row" then "Outside Group - Below". Delete the row...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 » Default Values - "Get values 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...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

MessageBox or AlertDialog in Android Javahttps://www.joellipman.com/articles/google/androidos/messagebox-or-alertdialog-in-android-java.html

20 October 2014 an all-in-one where I Open an AlertDialog designed with a custom XML layout Set the hint text of a specific user input field (EditText) Store the input in a TextView (invisible or visible) held in the calling XML /* 201411041253 */ private String...

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• Language: *

Android: Replace return key with done, go, send...https://www.joellipman.com/articles/google/androidos/android-replace-return-key-with-done-go-send.html

03 November 2014 email address textPersonName // name of a person textPostalAddress // standard postal address textPassword // password type field textVisiblePassword // um... textPhonetic // text that will sound like number // changes keyboard to numeric numberDecimal...

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• Language: *

Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 Happens if you don't convert the field-value pair dataset to a string: m_RecordData = Map(); m_RecordData.put("Field_To_Update", "Value_To_Put"); m_Data = Map(); m_Data.put("data",m_RecordData.toJSONList()); r_RecordUpdate = invokeUrl [ url :v_EndPoint...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

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

27 September 2019 An article on setting a date field to either the first Monday of the next month or to the last Tuesday of the current/next month. What I mean by the last Tuesday is if the last Tuesday of the month is before the current date, then set it to the last...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 or on the click of a link on a page. Why? Because alert (alert task) can only be used on a load of a form, on a change of a field or on the validate process. And because info can only be displayed to an admin and even in some cases only as an additional...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 form to receive data Login to your Zoho Creator and setup a form, I've called mine "eBay Webhook Payloads" Add a Single-Line field called "Event Type" Add a Multi-line field called "Payload" Click Done Make a note of the name of this form (the form link...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

21 October 2021 Template ID The following snippet is a separate function to run (standalone) and will return to you the templates and the field references: r_Templates = invokeUrl [ url: "https://zohoapis.com/writer/api/v1/templates" type: GET connection:...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

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

07 December 2021 7am in Los Angeles; and tell headquarters or the system calendar that the appointment is at 10am. How? So adding a datetime field and calling this one the "Customers Appointment Time" is the wrong first step. Reason being is that datetime fields hold...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://www.joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

14 February 2022 have to do this, but I store all the keys in a Zoho Creator form (I call mine "API Integration") ready with the following fields: Connection Name (Single Line) Dev ID (Single Line) Client ID (Single Line) Shop ID (Single Line) Client Secret (Single...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

GoDaddy Apache cPanel: Install SSL Certificatehttps://www.joellipman.com/articles/linux/cpanel/godaddy-apache-cpanel-install-ssl-certificate.html

07 April 2022 extension CRT), copied the contents to clipboard then pasted under "Install an SSL Website" into the "Certificate" textarea field. Duplicated the tab and went to the SSL/TLS page in CPanel and clicked on "Generate, view, upload, or delete your private...

• Type: Article
• Author: Joel Lipman
• Category: cPanel
• Language: *

Zoho Analytics: Set Up a Widget Displaying Sales Personhttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-set-up-widget-displaying-sales-person.html

24 October 2022 the following: With these kind of columns available to you: Click on Widget in the top right Under "Data Column", select any field in your table/query which is not the one to display Under "Group By", select the field that has the value you want to...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 CSV files... The only correction I had here is to specify the date/time format: On the Review screen it tells you how many fields were mapped. Amazing but not as useful as it is interesting: Then you're into the penultimate step of the migration where...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Using Criteria with Module Record Counthttps://www.joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

14 November 2023 = ceil(v_MaxCount / v_PerPage); info v_Pages; Call with datetime criteria: NB: You can't compare a date time value to a field that is simply of datatype: date v_PerPage = 200; v_CountCriteria = "((Quote_Stage:equals:" + encodeUrl("Draft") +...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Projects: Get All Eventshttps://www.joellipman.com/articles/crm/zoho/zoho-projects-get-all-events.html

22 July 2024 a blank response... The reason it was blank was due to my parameters; the key item to remember is that status is a mandatory field and it can either be "closed" or "open". If you have used ZohoCRM then this is obvious; if you haven't then it may be...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Search and Replace in a MySQL Databasehttps://www.joellipman.com/articles/database/mysql/search-and-replace-in-a-mysql-database.html

17 March 2010 sat there with phpMyAdmin or a MySQL Administration Tool (like Navicat or SQLYog), and still there at night editing each field so that it displays correctly... well that's usually me. Found it a bit boring but here's a short bit of code to speed it up...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

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

22 September 2009 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 right side in "Module Parameters" "Show Quick Modules...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 and some don't description - not recommended! date - the one I use for most recent created - this is also a date formatted field modified - and this is a date formatted field hits - number of times that weblink has been visited state - this is the J16...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

SSRS External Images don't displayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 Debug Method Fallback to debug methods; create a textbox that will be visible on the executed report (obviously replace the field name with the name of your field containing the location of the image - ours is "PhotoURL"): =" The file " &...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *