Default Value
type | value | Example |
---|---|---|
Text |
Specify a static string |
<text type='Text' value='Hello World'/> |
Form Data |
Fetches a value from a Zoho Creator application's form, based on the said aggregate. |
<text type='Form Data' value='appLinkName.componentLinkname.fieldLinkName.aggregate'/># |
Note:
Aggregate | Description | Syntax |
---|---|---|
sum |
Computes the sum of all the values in a specified form field. |
<text type='Form Data' value=' appLinkName.formlinkname.fieldlinkname. sum '/> |
minimum |
Computes the minimum of all values in a specified form field. |
<text type='Form Data' value='appLinkName.formlinkname.fieldlinkname. minimum '/> |
maximum | Computes the maximum of all values in a specified form field. | <text type='Form Data' value='appLinkName.formlinkname.fieldlinkname. maximum '/> |
median | Computes the median of all values in a specified form field. | <text type='Form Data' value='appLinkName.formlinkname.fieldlinkname. median '/> |
average | Computes the average of all values in a specified form field. | <text type='Form Data' value='appLinkName.formlinkname.fieldlinkname. average '/> |
count | Computes the count of all the records in a specified form. | <text type='Form Data' value='appLinkName.formlinkname. ID.count '/> |
distinctCount | Computes the distinct number of occurances of a value in a specified form field. | <text type='Form Data' value='appLinkName.formlinkname.fieldlinkname .dictinctCount '/> |
Syntax | <text value='thisapp.Products.Unit_Price.sum' numberScale='K'/> |
---|---|
Output |
|
Note:
Syntax | <text value='thisapp.Products.Unit_Price.sum' decimalPlaces='2'/> |
---|---|
Output |
|
Note:
Syntax | <text value='thisapp.Products.Unit_Price.sum' thousandSeparator=','/> |
---|---|
Output |
|
Note:
Syntax | <text value='thisapp.Products.Unit_Price.sum' decimalSeparator='.'/> |
---|---|
Output |
|
Note:
Syntax | <text type='Text' value='Hello World' fontFamily='Georgia'/> |
---|---|
Output |
|
Note:
Syntax |
<text type='Text' value='Hello World' size='8'/>
|
---|---|
Output |
|
Note:
Syntax | <text type='Text' value='Hello World' bold='true'/> |
---|---|
Output |
|
Note:
Syntax | <text type='Text' value='Hello World' italic='true'/> |
---|---|
Output |
|
Note:
Syntax | <text type='Text' value='Hello World' color='#FF00FF'/> |
---|---|
Output |
|
Note:
Syntax | <text value='Hello World' bgColor='#047B33'/> |
---|---|
Output |
|
Note:
Syntax | <text value='Hello World' padding='20px'/> |
---|---|
Output |
|
Note:
Syntax | <text value='Hello World' paddingTop='50px'/> |
---|---|
Output |
|
Note:
Syntax | <text value='Hello World' paddingRight='20px'/> |
---|---|
Output |
|
Note:
Syntax | <text value='Hello World' margin='50px'/> |
---|---|
Output |
|
Note:
Syntax | <text value='Hello World' margin='20px'/> |
---|---|
Output |
|
Note:
Example
Syntax | <text value='Hello World' margin='50px'/> |
---|---|
Output |
|
Note:
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.