Tools
Variables
15 min
initialize variable creates a variable choose the transform & format software and click on the “initialize variable” action follow the next steps to learn how to define this activity name click on the empty field and the tooltip will pop up select from the tooltip the name of the new item you create you can use static value – number / string when using strings, you need to surround them with single quotes (‘) property value from a previous activity (using the tooltip that opens when clicking on the field) type choose from the drop down list the type of variable you want to define value the value is optional you can set it in a variable that you initialize as an initial value, but you can choose not to fill the field of the variable and populate it later in the workflow option 1 without initial value when a variable is not initialized with an initial value, the system automatically assigns a default value based on the variable type for a string variable , the system assigns an empty string ("") for a number variable , the system assigns the value 0 for a boolean variable , the system assigns the value false for a array variable , the system assigns an empty list/array (\[]) for an object variable , the system assigns an empty object ({}) option 2 with initial value click on the empty field to and the tooltip will popup showing all the options you can use to fill the value you can populate the value in one of the following options static value – number / string when using strings, you need to surround them with single quotes (‘) property value from a previous activity (using the tooltip that opens when clicking on the field) expression – using functions and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) set variable updates the value stored in the variable with a new value choose the transform & format software and click on the “set variable” action follow the next steps to learn how to use this activity name choose from the drop down the name of the variable you want to set value click on the empty field to be shown the tooltip with all the options you can use to fill the value you can populate the value in one of the following options static value – number / string when using strings, you need to surround them with single quotes (‘) property value from a previous activity (using the tooltip that opens when clicking on the field) expression – using functions and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) append to array variable appending to an array variable allows you to dynamically add new values to the end of the array without changing the size or structure of the array choose the transform & format software and click on the “append to array variable” action follow the next steps to learn how to use this activity name choose from the drop down the name of the variable you want to append to value click on the empty field to be shown the tooltip with all the values you can use to fill the value field you can populate the value in one of the following options static value – number / string when using strings, you need to surround them with single quotes (‘) property value from a previous activity (using the tooltip that opens when clicking on the field) expression – using functions and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) add nested array false (default) adds the value as a normal item example \[1, 2] + 3 → \[1, 2, 3] true wraps the value in brackets \[], creating a "list inside a list " example \[1, 2] + 3 → \[1, 2, \[3]] recommendation keep it on false unless you specifically need a complex structure (like coordinates) append to string variable appending to an string variable allows you to dynamically add new values to the end of the string without changing the size or structure of the string choose the transform & format software and click on the “append to string variable” action follow the next steps to learn how to use this activity name choose from the drop down the name of the variable you want to append to value click on the empty field to be shown the tooltip with all the values you can use to fill the value field you can populate the value in one of the following options static value – number / string when using strings, you need to surround them with single quotes (‘) property value from a previous activity (using the tooltip that opens when clicking on the field) expression – using functions and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) increment variable increment variable refers to the operation of increasing the value of a variable by a specific amount choose the transform & format software and click on the “increment variable” action follow the next steps to learn how to use this activity name choose from the drop down the name of the variable you want to set increment value click on the empty field to fill the increment number decrement variable decrement variable refers to the operation of decreasing the value of a variable by a specific amount or step choose the transform & format software and click on the “decrement variable” action follow the next steps to learn how to use this activity name choose from the drop down the name of the variable you want to set decrement value click on the empty field to fill the decrement number map array the map array activity allows you to transform a data list that contains multiple pieces of data into a new data list based on the properties and values you choose for example, let’s consider the following data list \[ "status" "working on it", "date4" "2023 08 19", "text" "052123456", "text2" "info1\@engini io", "checkbox" "v", "checkbox 1" "v", "board id" "5017384721", "group id" "topics", "item id" "5017384726", "name" "meital borenstein" }, "status" "done", "date4" "2023 08 20", "text" "052123456", "text2" "info2\@engini io", "checkbox" "", "checkbox 1" "v", "board id" "5017384721", "group id" "topics", "item id" "5017384728", "name" "nimrod tzeler" }, "status" "working on it", "date4" "2023 08 17", "text" "052123456", "text2" "info3\@engini io", "checkbox" "v", "checkbox 1" "", "board id" "5017384721", "group id" "topics", "item id" "5017384729", "name" "itay guttman" }, "status" "stuck", "date4" "2023 10 10", "text" "052123456", "text2" "info\@engini io", "checkbox" "", "checkbox 1" "v", "board id" "052123456", "group id" "topics", "item id" "5352748005", "name" "michael golnik" }, "status" "working on it", "date4" "2023 10 01", "text" "052123456", "text2" "info4\@engini io", "checkbox" "v", "checkbox 1" "v", "board id" "5017384721", "group id" "topics", "item id" "5352749950", "name" "avishai dotan" } ] using the activity, we will create an array containing the names and emails of employees to do this, select the appropriate properties and values for this example, choose the following properties applying the map array, you will get the following array \[ { "name" "meital borenstein", "email" "info1\@engini io" }, { "name" "nimrod tzeler", "email" "info2\@engini io" }, { "name" "itay guttman", "email" "info3\@engini io" }, { "name" "michael golnik", "email" "info\@engini io" }, { "name" "avishai dotan", "email" "info4\@engini io" } ] this array contains the names and emails of the employees extracted from the original data list