Forum | Appery.io

Using some some of the cases in already on the forum, I was able to figure this out to some extent but I am getting an end result of NaN. I am not sure why it is not a number though. To me it should be.

Here I map the weights to a number array.

Here is how that LSV is set up.

Then in the success of the mapping, I run this javascript. Notice that I have an array commented out. If I use that array instead of the one that is saved as a LSV, the average works as expected.

This is the result of the above code. I get NaN but I don't know why.

Do you have any ideas as to why my database numbers that are stored as the number type are remaining numbers in the array?

Hello Ellen,

Please look at this example how to save an array of values into the Storage variable: https://docs.appery.io/docs/appbuilde...

So I tried putting this code in the JS area where I map the array (first picture in original post):
var myIDs = [];
$.each( data.results, function( key, value ) {
myIDs.push(value._id);
});
Apperyio.storage.myIDs.set(myIDs);

Then when I tested, I checked the console and there wasn't a value saved in the array at all.

Please check the same JS code, but change predata.results/pre to predata/pre

Eliminating the ".results" part of the code didn't change anything. It still comes back as an empty array instead of a number array.

If I shared my app with support, would that help?

Could you check a service response with a code below?
prealert(JSON.stringify(data));/pre Is it empty or not? Could you send us a screenshot with it's values?

I tried putting that code before the code I tried a few days ago (in the js mapping) but it didn't fire. I then tried putting it after and it still didn't fire. I commented out the old code and tried it...didn't fire. I put it on success of that service and it fired but it was just [].

Yes, it has to be used in the success event. If you get [] - in that case - the service response is empty.

Ok so the reason that it was empty was because I had the wrong column type. I fixed the column type back to number and tried running the recommend code and got
"User transformation function exception. Reason: Can't find variable: data"
When I run my regular query and do a data.length, I get back the proper number and it saves the values in local storage as it should. It just doesn't recognize them as numbers or something along those lines.

In summary, I can get the numbers in a lsv, but when they come out, there are no longer identified as numbers.