topic Re: JS script for dummy! in ArcGIS Survey123 Questions

JS script for dummy!

ChrisMaclaurin — Thu, 03 Dec 2020 15:37:57 GMT

Is there a simple JS script example (without feature by location) which queries a feature layer and returns all the attributes / records of a layer? and even better what would be the syntax for finding a Max value of an attribute in the host layer? Any help wold be blissfully received.

Re: JS script for dummy!

IsmaelChivite — Fri, 04 Dec 2020 18:57:15 GMT

Hi. Try this. The function below returns the max value found in the layer and attribute you specify.

If your layer is private, you will need to pass a token from your XLSForm, which you can get with pulldata("@property","token")

Re: JS script for dummy!

ChrisMaclaurin — Sun, 06 Dec 2020 14:57:09 GMT

You are a true scholar and gent.. thank you Ismael 🙂 This works a treat. I have also applied to this now to my desired hosted layer and pulls back the correct (max) value. I found it difficult to find such an example so your help is much appreciated here and I hope others too will find this just as useful. Now my crisis is over I will hopefully also use your example to build on my learning of JS script and applications in survey forms. Thank you once again. Best Regards Chris 😀

Re: JS script for dummy!

JavierCMartínezPrieto — Wed, 26 Jan 2022 17:32:06 GMT

Good afternoon,
could you tell me how to enter the token, I have created the field right now I get this error:

that's how I have it in the xls:

and when I manage to remove it I get an error 400, invalid error.

Could you put the example of how to enter the token and how it has to be written in the XLS.

thank you in advance and greetings

Re: JS script for dummy!

JavierCMartínezPrieto — Wed, 26 Jan 2022 17:40:02 GMT

this error 400:

Re: JS script for dummy!

ChrisMaclaurin — Wed, 26 Jan 2022 20:25:38 GMT

If my memory servies me right it might (but haven't read up on the specific error) be an issue with the length of the token. try setting the bind::esri:fieldLength to something large like 4000. I have also have the $token row bind::esri:fieldType set to null.

Could be a possible fix, not 100% sure though?

Re: JS script for dummy!

JavierCMartínezPrieto — Thu, 27 Jan 2022 07:04:35 GMT

thank you very much!!!!!!!

now I just need to filter the maximum values through a question.

Re: JS script for dummy!

JavierCMartínezPrieto — Thu, 27 Jan 2022 13:44:20 GMT

good, I can't filter the value through a specific field.

this is my script:

function getMax(IdCoche,token) {

var fl ='https://services3.arcgis.com/dha0QtUTrPxlyZDZ/arcgis/rest/services/service_0d42ead0e50e46b48f8e1eb32e39aff1/FeatureServer/0';

var field = 'KmFin';

var params = "/query?";

params = params + "where=IdCoche='" + IdCoche + "'&outFields=KmFin"

params = params + "&orderByFields=KmFin ASC&resultRecordCount=KmFin&f=json"

params = '/query?where=1=1&outStatistics=[{"statisticType":"MAX","onStatisticField":"' + field + '","outStatisticFieldName":"MAX"}]&f=json';

var URL = fl + params;

var xmlhttp = new XMLHttpRequest();

if (token){

URL = URL + "&token=" + token;

}

xmlhttp.open("GET",URL,false);

xmlhttp.send();

if (xmlhttp.status!==200){

return xmlhttp.status;

} else {

var responseJSON=JSON.parse(xmlhttp.responseText)

if (responseJSON.error){

return JSON.stringify(responseJSON.error);

}

else {

if (responseJSON.features[0]){

return JSON.stringify(responseJSON.features[0].attributes.MAX);

}

else{

return "No Features Found";

}

all help is appreciated

greetings

Re: JS script for dummy!

ChrisMaclaurin — Fri, 28 Jan 2022 08:28:51 GMT

Hi JMP,

Not sure if this will fix yours but my function doesn't work when token isn't the first argument?

I.e function getMax(token, IdCoche)

Another problem could be you may need to define the argument 'IdCoche' in the function

Var SecondField = "IdCoche"

Not sure though... I haven't scripted for a while and I'm finding I am even forgetting the correct terminology 😞

Good luck

Chris

Re: JS script for dummy!

JavierCMartínezPrieto — Fri, 28 Jan 2022 09:36:23 GMT

hi Chris

thanks for the help, currently this is the script I have:

function getMax(IdCoche,token) {

var fl ='https://services3.arcgis.com/dha0QtUTrPxlyZDZ/arcgis/rest/services/service_0d42ead0e50e46b48f8e1eb32e39aff1/FeatureServer/0';

var field = 'KmFin';

var params = "/query?";

var params = "/query?where=IdCoche='" + IdCoche + "'&f=json";

params = params + 'outStatistics=[{"statisticType":"MAX","onStatisticField":"' + field + '","outStatisticFieldName":"MAX"}]';

var URL = fl + params;

var xmlhttp = new XMLHttpRequest();

if (token){

URL = URL + "&token=" + token;

}

xmlhttp.open("GET",URL,false);

xmlhttp.send();

if (xmlhttp.status!==200){

return xmlhttp.status;

} else {

var responseJSON=JSON.parse(xmlhttp.responseText)

if (responseJSON.error){

return JSON.stringify(responseJSON.error);

}

else {

if (responseJSON.features[0]){

return JSON.stringify(responseJSON.features[0].attributes.MAX);

}

else{

return "No Features Found";

}

I keep getting the maximum value of the field I specify in var field, but it doesn't filter me, by the IdCar.

the token issue is quite confusing because for it to work you have to enter it in fx in survey, but these are temporary so they can stop working. i think that section is not very well implemented in survey123 connect.

Regards

Re: JS script for dummy!

ChrisMaclaurin — Fri, 28 Jan 2022 17:00:07 GMT

Hi JMP,

I don't know IdCar? Is it a field name? I can't see it in your function.

I have never really used the fx area in scripts. It doesn't seem to work for me, yet the form & script are returning me the values I desire in the form I am using so the token does appear to be working ok, but yet it returns me an error in the fx area.

Chris

Re: JS script for dummy!

JavierCMartínezPrieto — Mon, 31 Jan 2022 14:30:31 GMT

Hello chris
if the IdCar is the name of another field that is in the layer, it is the field I want to use to filter the values, but it keeps returning the maximum value of the KmFin field. it should be in the where class where I have to enter the filter field, but I can't get it to do anything....

I don't get an error in the fx once I paste the token, which provokes a question: Every time I start the survey, do I have to paste the token in the fx for the script to work, or does the program itself update the token once it has been entered?

Greetings javier

Re: JS script for dummy!

ChrisMaclaurin — Mon, 31 Jan 2022 20:47:50 GMT

Hi Javier,

The statisticType":"MAX will return the highest value on the named field (KmFin). There is no filtering in the function.

There may be another way but I would filter on a second field by bringing it into your function on the xls form e.g pulldata("@javascript", "functions.js", "NameOfFunction", ${token}, ${SecondField})

This would be brought into the function as an argument eg. function NameOfFunction (token, SecondField) {

Then you would need to know how to filter using JavaScript in the function.

The token does not need to be manually entered, it passes through automatically

Chris