topic Re: Select multiple records and submitted records should be individual in ArcGIS Survey123 Questions

Select multiple records and submitted records should be individual

Kristofer — Mon, 15 Apr 2024 09:52:12 GMT

Hi All,

I am facing the issue on repeat section and multiple select question. My requirement is when user select the multiple students name from dropdown or list and each selected name records should be stored in a separate row in the related table. I am using begin_repeat type and name question is within the begin_repeat.

A Snapshot is attached here for your references.

I am configured the survey form using Survey 123 connect (3.19.116)

Thanks & Regards,

Kristofer

Re: Select multiple records and submitted records should be individual

DougBrowning — Mon, 15 Apr 2024 13:41:00 GMT

What you are seeing is how a select multiple works. It stores the values as a comma separated list. It cannot make repeat records. You would need to use a select one and have the user hit the plus button to add more records.

Re: Select multiple records and submitted records should be individual

Kristofer — Mon, 15 Apr 2024 17:04:23 GMT

Hi @DougBrowning

Thank you for your quick response!!

Is there a way like automatically insert three repeats in the survey form (like manually hits the plus sign) when options A, B, and C are selected in the multiple-choice question and calculate the selected values within these inserted repeats?

Thanks & Regards,

Kristofer

Re: Select multiple records and submitted records should be individual

DougBrowning — Mon, 15 Apr 2024 17:57:13 GMT

No there is no way to do that. A python script after that fact would be about the only way.

Re: Select multiple records and submitted records should be individual

RobertAnderson3 — Mon, 15 Apr 2024 18:01:10 GMT

There is a repeat_count field in the XLSX you could use to automatically create repeats, the issue I've run into for my workflows is it's a hard count not like a default or something you can still add/delete after, but if you're using the select_multiple to pick how many, I wonder if you could count(select_multiple) and create the right amount that way.

Re: Select multiple records and submitted records should be individual

abureaux — Tue, 16 Apr 2024 15:39:27 GMT

You could use an automation process like Power Automate to enter that data in a separate database the way you want. But tbh that is likely overly complicated for this application. I'd re-do the survey to simply change the select_multiple to a select_one (plus any other applicable changes to suit this new data collection method).