Forum | Appery.io

Hello

I want to use a survey in my app, and the results should be returned to the user right after completion. Everything is good so far, I can store the answers in numbers in a collection in the database. I'm having trouble calculating the results.

In my database the values in a row are something like:

username,2,4,5,3,5,4,2,4,5,1,2,3,4.

I want to do a calculation with some specific columns only (basically using sum, multiply and divide). The username I can get from a local storage, just don't know how to reference the numbers in a code. Can you help me with that?

Thanks!

You can do a GET on the records, you will get all the values and could then manipulate them with JavaScript.

Hi Max, thanks again for the fast response. So I basically create the service, on response mapping I map all the collumns to the place I desire, and then manipulate them on the "Add JavaScript" button, right?

What's the syntax used to refer to a variable coming from the database on the JS?

Thanks!

The component to which you mapped will hold the value from database. One option is to use Add JavaScript -- that will be invoked during mapping. Or, once all the mappings are done, you can retrieve the values from the components and then manipulate them.

Can you please provide a detailed example to this questions.

Thanks in advance.

I don't have example. This is your app logic written in JavaScript. I don't know what calculations you need to do.

Do you have sample code to demonstrate how one can show a sum of all the values in a column in an app.

I am a novice at this and could use some help. I am learning by example.

Thanks in advance.

Save the data into an array. Then iterate over the array and add all the numbers.

Yes thank you for that.

However, can you please provide me with a sample project. I am sure have done this a million times.

I can do data manipulation with SQL. I am just not familiar with REST.