topic Re: Can I prevent a value from being submitted multiple times in a repeat question? in ArcGIS Survey123 Questions

Can I prevent a value from being submitted multiple times in a repeat question?

LaurenMcGarvey — Fri, 14 Jun 2019 18:30:56 GMT

I have a repeat question in my survey as shown below.

The repeat question is to document the plant species and cover class in a quadrat. There are over 200 values for plant species and many species may be found in a quadrat. Is there a way to prevent a plant species from accidentally submitted multiple times in the repeat question?

Re: Can I prevent a value from being submitted multiple times in a repeat question?

JamesTedrick — Fri, 14 Jun 2019 20:12:09 GMT

Hi Lauren,

It is possible to create a check function using an in-beta function, custom JavaScript functions. See the attached sample.

Re: Can I prevent a value from being submitted multiple times in a repeat question?

DougBrowning — Fri, 14 Jun 2019 20:28:12 GMT

I posted a way that is clunky but works here

https://community.esri.com/thread/229555-how-to-not-use-a-list-item-more-than-once

Re: Can I prevent a value from being submitted multiple times in a repeat question?

LaurenMcGarvey — Mon, 17 Jun 2019 19:16:12 GMT

Thanks for sharing, James. I am not familiar with JavaScript functions, could you please provide a little more detail?

Re: Can I prevent a value from being submitted multiple times in a repeat question?

JamesTedrick — Tue, 18 Jun 2019 22:32:09 GMT

Hi Lauren,

In the survey is a custom function that compares the number of answers with the number of distinct answers and returns true if they are the same and false if they are not. I based it on https://codeburst.io/javascript-array-distinct-5edc93501dc4

Re: Can I prevent a value from being submitted multiple times in a repeat question?

LaurenMcGarvey — Mon, 08 Jul 2019 20:59:35 GMT

Hi James,

Thanks for your response. I added the note to my survey and added the extensions folder with the javascript file to my survey content folder. However, now the note about duplicate values is always appearing. Do you have any suggestions?

Re: Can I prevent a value from being submitted multiple times in a repeat question?

Anonymous User — Wed, 10 Jul 2019 16:56:51 GMT

Hi Lauren,

The pulldata expression needs to be in its own hidden calculation, and then reference that question name in your relevant expression for the note.

It will not work the way you have currently tried to use it in the note.

Phil.

Re: Can I prevent a value from being submitted multiple times in a repeat question?

LaurenMcGarvey — Thu, 11 Jul 2019 14:46:42 GMT

Thanks, Philip. Did I do this correctly? The duplicate value warning is still showing up all the time.

Re: Can I prevent a value from being submitted multiple times in a repeat question?

Anonymous User — Thu, 18 Jul 2019 01:19:06 GMT

Hi Lauren,

No, this is not correct. You need to remove the not and separate that to a different question from the pulldata.

Can you attach your xslx file so I can take a closer look and work out the best way to achieve what you are after.

Phil.

Re: Can I prevent a value from being submitted multiple times in a repeat question?

LaurenMcGarvey — Thu, 18 Jul 2019 13:46:19 GMT

I have attached my xslx file. Thanks!

Re: Can I prevent a value from being submitted multiple times in a repeat question?

DougBrowning — Thu, 18 Jul 2019 13:54:11 GMT

I think your issue is the Other. That will repeat a bunch of times.

I do this exact thing with species actually. We use Unknown Codes but same concept. You will have to build in an exception for the Other.

I did not test it but I added my line into your form. You could change my exceptions from UNK to Other.

Re: Can I prevent a value from being submitted multiple times in a repeat question?

LaurenMcGarvey — Thu, 18 Jul 2019 14:21:12 GMT

This worked great! Thanks for sharing!

Re: Can I prevent a value from being submitted multiple times in a repeat question?

DougBrowning — Thu, 18 Jul 2019 14:33:43 GMT

Sorry I forgot to change all the field names from SpeciesList to species but I guess you got it. Note this does assume your codes are 4-5 characters long. That is why I take off 3 chars then check the string (this is because it will try to check the species you just added). The check for "" was so that users could go backwards without having to delete the current repeat due to the required.

Re: Can I prevent a value from being submitted multiple times in a repeat question?

SPNIOrganization — Sun, 19 Jan 2020 17:01:42 GMT

Hi Lauren,

Can you please post the final xls form and js file that worked for you?

I'm trying to do exactly what you did, with no success.

thanks,

Dikla.

Re: Can I prevent a value from being submitted multiple times in a repeat question?

JosephBusalacchi — Mon, 01 Jun 2020 14:30:04 GMT

Phil,

I am having the exact same issue working on a very similar survey. I am trying to provide a warning if the data collector tries to add the same species twice in one plot. I have added the distinct_check java script and the message is always on. Could you possibly explain to me how to organize this code correctly in the Survey123 Connect spreadsheet to only show the message when there is a repeat?

Re: Can I prevent a value from being submitted multiple times in a repeat question?

Anonymous User — Mon, 01 Jun 2020 23:29:45 GMT

Hi Joseph,

If you can please share your xlsx form and also the JS file, and any other files in the media or extensions/scripts folder, then we can try and reproduce your issue and give suggestion on how to configure.

Phil.

Re: Can I prevent a value from being submitted multiple times in a repeat question?

JosephBusalacchi — Tue, 02 Jun 2020 15:48:29 GMT

Phil,

Attached are the files. There are several things that I would like to accomplish and they may all be related:

limit duplicate species ${plant_key} in the same plot, either by not allowing or flashing warning
keep a running total of all plants collected for each transect, by species ${s_name} and publish those results in the multiline note element on the belt transect group
limit the user from collecting more than 100% cover ${percent_cov}

Thank you for taking a look at this, please let me know if you need more information,

Joey

Re: Can I prevent a value from being submitted multiple times in a repeat question?

JosephBusalacchi — Thu, 04 Jun 2020 11:56:32 GMT

Hello Phil, I was wondering if you had a chance to look through what I sent you the other day. Again, I appreciate your help.

Thanks,

Joey

Re: Can I prevent a value from being submitted multiple times in a repeat question?

JosephBusalacchi — Mon, 08 Jun 2020 13:26:37 GMT

Hi James,

I have been waiting for a response from another ESRI staff and I am not sure what happened, but I haven't heard anything in days.

I am creating a Survey123 form for collecting quantitative data on plant species. I am having the exact same issue working on a very similar survey. I am trying to provide a warning if the data collector tries to add the same species twice in one plot. I have added the distinct_check java script and the message is always on. Could you possibly explain to me how to organize this code correctly in the Survey123 Connect spreadsheet to only show the message when there is a repeat?

I would also, like to add the following funtionality:

limit duplicate species ${plant_key} in the same plot, either by not allowing or flashing warning
keep a running total of all plants collected for each transect, by species ${s_name} and publish those results in the multiline note element on the belt transect group
limit the user from collecting more than 100% cover ${percent_cov}

I attached a .zip folder and sent it to Phil, see this thread. Is there someway you could help point me in the right direction for adding this functionality?

Thank you,

Joey

Re: Can I prevent a value from being submitted multiple times in a repeat question?

JosephBusalacchi — Tue, 09 Jun 2020 11:43:30 GMT

Good Morning Phil,

Sorry to keep sending messages, but I am starting to get desperate to learn if you will be able to help me or not. Some of the questions I asked are important for me to move forward with the development of this Survey123 app for field data collection.

Respectfully,

Joey