Calculate[a]

Create additional calculated columns

Perform calculations to add attributes to each entry the list

list[].attribute1
list[].attribute1
list[].attribute2
list[].attribute2
list[].attribute3
list[].attribute3

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.

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