I everyone, i started with make.
Il want to check a row Participant, and make +1 to the cell when the answer is ok
I can’t do this, can you help me ?
Welcome to the Make community!
There is no parseInt function in Make. If you want to use JavaScript, see [Free App] My Toolbox of Useful Modules
Otherwise, you can select the built-in function parseNumber from the variables panel — “Parses a string with a number and returns the number.”
{{ parseNumber(number; decimal separator) }}
For more information, the function’s documentation can be found in the Help Centre. You should also complete the tutorials in the Make Academy.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
You cannot use the ‘+’ sign alone, you have to select the ‘+’ from the ‘Math functions’ operators or write it like this {{+}}
Thanks, it word a little better.
I do that and the number 1 still concact after the number instead of sum.
And on all the cells
May i do something wrong ?
Delete the “{{” “}}” before the function and after the number
Thanks for the help ! It work with the + 1 !
One last thing where i made a mistake, all the row take the +1.
I don’t know if it my filter or if i make something wrong
If I’m not mistaken you want to add + 1 to the corresponding row every time “result” is equal to VISUELLE, AUDITIVE and KINESTHÉSIQUE and to achieve that you need to add a filter to every route of your router to do that you need to click to the little circles that forms a line between the router module and the set variables module, there in condition you need to add the value (result) that comes from the webhook.
The Condition of the filter is the value type of the data to “filter” in this case is text select Text operators: Equal to
The last one is the value you want the result to have to pass the filter. In the route KINESTHÉSIQUE write KINESTHÉSIQUE in VISUELLE write VISUELLE and in the route AUDITIVE write AUDITIVE
Make sure the words are always the same because KINESTHÉSIQUE and KINESTHESIQUE count as different words because of the É
Save every filter and run your scenario to test it
Thanks a lot ! I make it, but it’s the same for me, every row is update to 1, even the firt line.
I suppose i make something wrong 
Can you show a full picture of your scenario and the 3 filters too?
Make sure you do not have spaces in your text
Hope this helps! Let me know if there are any further questions or issues. P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!
1 Like
It’s the same, i didn’t understand why there is 4 result uptade.
Sorry… I’ll try to make the tutorials 
Your Excel is returning 4 rows and it seems to be working right as it only passed through the VISUELLE filter
Open the Excel module to see the output
Does the webhook return only one result?
This is simple. The previous module outputs 4 bundles, which you did not aggregate.
Either limit to one result, or use an aggregator.
Combining Bundles Using Aggregators
Every result (item/record) from trigger/iterator/list/search/match modules will output a bundle. This can result in multiple bundles, which then trigger multiple operations in future modules (one operation per bundle). To “combine” multiple bundles into a single variable, you’ll need to use an aggregator of some sort.
Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the Text Aggregator which is very flexible and can apply to many use-cases like building of JSON, CSV, HTML.
You can find out more about the other types of aggregator modules here:
- Array aggregator
- Text aggregator
- Numeric aggregator
- Table aggregator
- JSON aggregator
- CSV aggregator
- Archive (ZIP) aggregator
- other app-specific aggregators
Question: Which is the best aggregator do you think you’ll need for your use-case?
Mapping a Specific Structure Into a Complex Field
If you have an array of collections, in programming terms, this is called an array of objects, or an array with non-primitive data types (“complex”).
The Array Aggregator module is very powerful because it allows you to build a new complex array of collections that matches a later module’s field to map multiple items (collections) to it. Such fields initially would allow you to manually add items, but you can toggle the “Map” switch to the “on” state and map a whole array into a single field.
This is done by selecting the “Target structure type” in an Array Aggregator module.
As you can see from the above example, the “Map” toggle on complex fields are used when you have an array variable (like from an array aggregator). Other combinations of modules may also allow you to generate an array that matches a future field’s array structure, like “Aggregate to JSON + Parse JSON”, or “Create JSON + Parse JSON”, but this is an advanced topic.
Question: Are you mapping your array into a field that accepts more than one item/collection?
Example
Here is an example of how your scenario could look like:
This is just an example. Your final solution may or may not look like this depending on your requirements and actual data.
For more information, see “Mapping with arrays” in the Help Centre. You should also do the Make Academy, which also covers the use of Iterators & Aggregators.
Hope this helps! Let me know if there are any further questions or issues. P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!
Thank you for all your answers !
I’ll try that and i’ll be back