Latest Contributions by Alex_Dale

‎04-08-2020

This did not work for me. I searched for the survey through ArcGIS online and found the hosted feature layer. When I added it to the map. All the data was there. Is there a way to protect the results of a public survey so only We can view them?

‎04-07-2020

Is there a way to have the date wheel scroll beyond 1945 and stop at 2020? Any input is appreciated.

‎01-16-2020

My other surveys work in airplane mode and store the survey in the outbox. I cannot move past the req'd location question.

‎01-16-2020

Hello, I have an issue with one of my surveys. When in airplane mode the geopoint feature does not work and users are not able to submit to outbox. Here is the url: https://arcg.is/1rCu09 . I've also attached the form. Any insight is appreciated.

‎01-15-2020

Hello, we wanted to update our survey to disable submitted surveys so they wouldn't be stored on the device. We previously had that enabled for our trial runs, but now switched it to disabled and published. After testing, folks still have sent surveys on their phones and new surveys still remain. Is there a way to get this feature disabled without having hundreds of people download the new survey?

‎01-05-2020

Thank you Jim, The new syntax somewhat worked. Now, however, the first IF function overrides the rest of the nested IF functions: if($="1to2yrs"and $="Yes",1,2) or if($="1to2yrs"and $="Yes",1,2) or if($="1to2yrs"and $="Yes", 1,2) or if($="1to2yrs"and $="Yes",1,2) or if($="other"and $="Yes",1,2) or if($="other"and $="Yes",1,2) or if($="other"and $="Yes", 1,2) or if($="other"and $="Yes",1,2) or if($="Yes"and $="Yes",1,2) or if($="Yes"and $="Yes",1,2)or if($="Yes"and $="Yes",1,2)or if($="Yes"and $="Yes",1,2) Any thoughts? Alex Dale Data Manager Partners In Care, Oahu’s Continuum of Care 200 North Vineyard Boulevard, Suite 210 Honolulu, HI 96817 Phone: (808) 543-2242 Email: adale@auw.org www.partnersincareoahu.org TOGETHER, WE CAN END HOMELESSNESS Partners in Care’s mission is to eliminate homelessness through open and inclusive participation and the coordination of integrated responses.

‎01-02-2020

I am having trouble nesting multiple if AND statements in an XLSform for Survey123. I am getting the follwing error: cannot handle function 'if' requires 3 arguments. Only 1 provided. Here is my formula: if(AND(${homelessness}="1to2yrs", ${mhDis}="Yes",1,if(AND(${homelessness}="1to2yrs", ${PhyDevOther}="Yes",1,if(AND(${homelessness}="1to2yrs", ${AlcDrugs}="Yes",1,if(AND(${homelessness}="1to2yrs", ${HIVAIDS}="Yes",1,if(AND(${homelessness}="other", ${mhDis}="Yes",1,if(AND(${homelessness}="other", ${PhyDevOther}="Yes",1,if(AND(${homelessness}="other", ${AlcDrugs}="Yes",1,if(AND(${homelessness}="other", ${HIVAIDS}="Yes",1,if(AND(${homeless_times}="4", ${mhDis}="Yes",1,if(AND(${homeless_times}="4", ${PhyDevOther}="Yes",1,if(AND(${homeless_times}="4", ${AlcDrugs}="Yes",1,if(AND(${homeless_times}="4", ${HIVAIDS}="Yes",1)))))))))))))))))))))))) Any help is greatly appreciated.

Online Status	Offline
Date Last Visited	‎01-09-2023 03:12 PM

My Ideas

Latest Contributions by Alex_Dale

Re: Is it possible to secure answers to public surveys

Survey 123 date/year before 1945

Re: Geopoint not working in Airplane mode

Geopoint not working in Airplane mode

Overwrite Survey123 settings on mobile devices.

Re: nesting if AND formula in XLSform.

nesting if AND formula in XLSform.