Survey123 Connect - calculate total records in feature layer and return a value

BriannaWiddick

I am creating workshop registration survey using Survey123 Connect.  What would be ideal is if the survey is able to tell the survey taker how many spots are left in the workshop.  Is there a way in Connect that we can have the survey calculate the amount of records that have been submitted and return a value? for example it could say "there are 23 seats available" when they go to register for the workshop in the survey.  I am not finding anything that could do this calculation within the survey.  Perhaps this is not a capability of Connect and I need to think of another solution.  

IsmaelChivite

Hi. To return the total record count in a layer you would need to use a custom JS function.  Below is an example.  The problem is that custom JS functions do not work if you publish your survey publicly.  It seems like you would not want people to have to login to register for an event. Sharing the code just in case, although it looks like a long shot.

 

 

function getCount(featureLayer,token){
   
	var xmlhttp = new XMLHttpRequest();
	var url = featureLayer + "/query?f=json&where=1=1&returnCountOnly=true";

	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 {
      	 return JSON.stringify(responseJSON.count);
       }
    }
}

 

 Bel