https://community.esri.com/t5/arcgis-survey123-questions/autocomplete-search-with-external-csv-and/m-p/1050648#M34113 <P>Hello,</P><P>&nbsp;</P><P>I am building a Survey123 app using the autocomplete search option in the appearance field.&nbsp; That works great, but I have some questions regarding how to set up calculations to work well with this set-up as well as how to potentially use an external csv file as the source of the autocomplete search.</P><P>Ideally, I would like to be able to have a csv file with a list of addresses that would also include names, phone numbers, email addresses, etc.&nbsp; If the user has never used the form previously, I would like to have their address and other info added to the external csv once the data is submitted.&nbsp; Is this possible?</P><P>On a different autocomplete search function, regarding the calculations, because the autocomplete search works with the select_one question type, the ability allow users to select more than one requires repeats.&nbsp; The issue there is that if I need to create a total cost for all of the selections made, I am struggling to get that to work.&nbsp; When I use a calculation function of adding all of the fields with values (there is a separate field for each analyte where the value is 0 unless that analyte is selected, then the appropriate fee is used), it only includes the fee that was selected last, it isn't cumulative.&nbsp; Is there a way to do that?&nbsp; If so, how do I set of the calculation functions to do that?&nbsp;&nbsp;</P><P>The xlsform I am working on is attached below.</P><P>Thanks in advance for any assistance.</P><P>Lisa D.</P> Fri, 23 Apr 2021 13:52:00 GMT LisaDygert 2021-04-23T13:52:00Z https://community.esri.com/t5/arcgis-survey123-questions/autocomplete-search-with-external-csv-and/m-p/1050648#M34113 <P>Hello,</P><P>&nbsp;</P><P>I am building a Survey123 app using the autocomplete search option in the appearance field.&nbsp; That works great, but I have some questions regarding how to set up calculations to work well with this set-up as well as how to potentially use an external csv file as the source of the autocomplete search.</P><P>Ideally, I would like to be able to have a csv file with a list of addresses that would also include names, phone numbers, email addresses, etc.&nbsp; If the user has never used the form previously, I would like to have their address and other info added to the external csv once the data is submitted.&nbsp; Is this possible?</P><P>On a different autocomplete search function, regarding the calculations, because the autocomplete search works with the select_one question type, the ability allow users to select more than one requires repeats.&nbsp; The issue there is that if I need to create a total cost for all of the selections made, I am struggling to get that to work.&nbsp; When I use a calculation function of adding all of the fields with values (there is a separate field for each analyte where the value is 0 unless that analyte is selected, then the appropriate fee is used), it only includes the fee that was selected last, it isn't cumulative.&nbsp; Is there a way to do that?&nbsp; If so, how do I set of the calculation functions to do that?&nbsp;&nbsp;</P><P>The xlsform I am working on is attached below.</P><P>Thanks in advance for any assistance.</P><P>Lisa D.</P> Fri, 23 Apr 2021 13:52:00 GMT https://community.esri.com/t5/arcgis-survey123-questions/autocomplete-search-with-external-csv-and/m-p/1050648#M34113 LisaDygert 2021-04-23T13:52:00Z