Calculate[a]
Create additional calculated columns
|
|||||
|
|
|
||||
|
|
||||
|
|
||||
|
|
||||
The Calculate building block allows you to perform calculations or conversions on existing values. Thereby create new columns for values you are interested in
Use cases
- Calculate the total column by multiplying quantity and price
Configuration
Click on the bold text in the title of the building block to open the configuration dialog.
After adding the script to your flow, click on the keyboard icon in the input parameter section.
Only unbound input parameters are activated in the form dialog, so if you are using the script multiple times you may need to activate the table and expression parameters.
When creating new columns on the fly by defining them in your expression they will not show up in the Ultradox Template Editor. You'll have to enter them into your templates manually.
Please note that you will have to access the columns by using the row prefix. If you for example have a column called quantity you'll have to use row.quantity in your expression.
row.amount = row.amount / 100; row.total = row.amount * row.quantity
[a]It's not possible to output a list. It seems that even if I assign an array object to the dictionary, the array gets converted into a dictionary. Example:
Javascript: entry.etapeList = ['11', '11', '11'];
Resulting object:
[{
"étapes":"11n11n11",
"etapeList":{"0":"11","1":"11","2":"11"}
}]
Am I doing something wrong because I'm unable to get a list.
What I'm trying to do in my Google Doc is bullet point or a numbered list of items and I can't get it to no avail.
Here is what I've tried in my template:
Étapes
$[étapes]
$[etapeList;list()]
$[étapes.values()]
$[etapeList.values();list()]
$[etapeList]Iterator mismatch (was etapeList, now is null)
<ul>
</ul>
<ul>
</ul>
Questions and Feedback
If you have any comments on this page, feel free to add suggestions right to the Google document that we are using to create this site.
If you are not yet member of the Ultradox community on Google+, please join now to get updates from our end or to provide feedback, bug reports or discuss with other users.
Last Updated: 14.04.20