Assuming value is required, the following 191 results were found.
-
var fn_CountDecimals = function(value) { if (Math.floor(value) !== value) return value.toString().split(".")[1].length || 0; return 0; } // get the value from the field "Weight (kg)" (decimal field only allowed 2 decimals) var v_ProductWeight =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
v_Pages = 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: *
-
Calendar Day Select (link name: Calendar_Day_Select || type Radio) Form CSS (link name: Form_Css || type Add Notes) Selected Value for debugging (link name: Selected_Value || type Single line) Starting Date (link name: Starting_Date || type Date)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
failures. How? The key trick to use here the ability for Zoho Analytics to display different images based on a criteria or a value within a data table. As documented in an earlier article, put the URL of the image, then change it's format to show the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to Transact-SQL (T-SQL) What? This is a quick article on how to split a single row into multipe rows based on the value of a column in the same table. Why? I have a table that has all the days of sickness of employees. This table contains, which...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
{... } VS if(isBlank(v_Test)) {... } isBlank() can be used to check if the string only contains blanks or if a value is null... How? Consider the following test function: void fn_Test() { info "---------------------- Value of TEST is a BLANK String";...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
) AS d1 ORDER BY d1.Name ASC Additional Modifications: For all Parameters: » General - Untick "allow blank value" and "allow null value" (so these checkboxes are empty). » Available Values - "Get values from a query" = Select the dataset of the dropdown...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
r_Response = invokeurl [ url :v_DataEndpoint type :PUT parameters:m_CreateRecord headers:m_Header ]; Problem: Value is empty and 'get' function cannot be applied Following a post similar to the above example by InvokeURL and then getting a JSON response...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
m_Params = Map(); m_Params.put("responseFormat","json"); // note how criteria column is denoted by double-quotes and a value is by single-quotes. m_Params.put("criteria","\"SO ID\"='" + v_SalesOrderID + "'"); m_Config = Map(); // sometimes parameters...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are in the old column and which ones are new... Why? Consider the...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
manages their domain, then they can give the following instructions to these instead. ZohoCRM: Get Details as Zoho User The values are the same for the CRM app for all organizations, but in case these change since time-of-print of this article, this is...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
A quick article to document a Zoho Deluge function converting a hexadecimal color reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some point as an input but at the time of print, this hasn't...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
why don't you do the following: Bring up the "Tablix Properties" of the dataset Look for the section "No Rows" Put in a value for "NoRowsMessage". This solution hides the entire Tablix which kinda defeats the purpose of having anything there. I want my...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
etc) then you should do this at the database level, and then get the report to complete the check: The Plan User enters value in parameters and clicks on "View Report" Report passes parameter to dataset which gets formatted by the database Report...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
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 folders will also show....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Add a dataset Query type: Stored Procedure Refresh fields button Parameter name (oracle input sp variable) and Parameter value (ssrs input parameter) Fields (field name=ssrs reference, field source=oracle sp field name) 1. Create a stored procedure...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
number datepart) DATEADD(datepart, number, date) DATESUB(datepart, number, date) Other If-then-else IF( expression,value_if_true,value_if_false ) IIF( expression,value_if_true,value_if_false ) If Null IFNULL(column_name,value_if_null)...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
+ "/" + SUBSTRING((DT_STR,8,1252)StartDate,5,4)) Error: Description: "Invalid character value for cast specification". Exceptions for text file where I needed two derived column tasks, the first checks if the Date was blank and puts a NULL string. The...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read on. How? So where does the 'B110' string come from, well from one of our tables which...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
with the name of your database table AND `introtext` with the name of your column): SELECT SUM(`total_count`) as `total`, `value` FROM ( SELECT count(*) AS `total_count`, REPLACE(REPLACE(REPLACE(x.`value`,'?',''),'.',''),'!','') as `value` FROM ( SELECT...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF