nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Autopopulate Repeat Question Type using Values from Another Repeat Question Type

jantolihao

Hi, everyone!

I just want to ask if it's possible to autopopulate a repeat question type using the values from another repeat question type.

For instance, I have here 2 Repeat Question Types: Owners Declaration and Assessment. Please see the reference image below.

What I want to do is, I want to autopopulate the Machinery Name and Machinery Description fields in Assessment Repeat using the values from Owners Declaration Repeat. Yes, I can call/reference the fields in the calculation. However, I am having issues for multiple records in Owner Declaration Repeat. It does not properly/correspondingly autopopulate the Assessment Repeat. It just autopopulates the first "page" of the Assessment Repeat. Please see reference image below. I have 2 records in Owners Declaration Repeat but in Assessment Repeat, only 1 record is autopopulated. It seems that it only autopopulates what is currently displayed.

Do you have any hints/ideas in addressing this concern? Thank you in advance.

Find more posts tagged with

Accepted answers

jantolihao

Hello, everyone! Update on this concern. I already addressed this concern. These are the steps that I performed:

1. Inserted a calculate question type that counts the entries inputted by the user in the first repeat (Owners Declaration)

2. The number that will be calculated in No. 1 will be placed in the Repeat Count of the second repeat (Assessment).

3. For the fields in the second repeat (Assessment) that will be auto-populated by the records in the first repeat (Owners Declaration), I used the combination of indexed-repeat and position (..) function in the calculation column. Please see sample calculation entry below.

indexed-repeat (${field name}, ${repeat name}, position(..))

Thank you everyone for helping and for providing reference links. 🙂

All comments

jantolihao

Hello, everyone! Update on this concern. I already addressed this concern. These are the steps that I performed:

1. Inserted a calculate question type that counts the entries inputted by the user in the first repeat (Owners Declaration)

2. The number that will be calculated in No. 1 will be placed in the Repeat Count of the second repeat (Assessment).

indexed-repeat (${field name}, ${repeat name}, position(..))

Thank you everyone for helping and for providing reference links. 🙂

jantolihao

Thank you for the response, @MarikaVertzonis. Fortunately, I already addressed this concern.

ChristopherCounsell

Try using position(..) for the current repeat record, with the indexed-repeat value.

e.g. indexed-repeat(${room_no}, ${floor}, position(..))

Theoretically this gives you the indexed-repeat value (room) from table one (floor) at the current index of the second table.

Haven't tried it though, and you may have issues if people change values or go back/forth a lot triggering re-calc, so would really recommend not having a split into the two tables if you can avoid it.

Marika Vertzonis

You describe that there needs to be two tables (Owners Declaration and Assessment), but can they be nested? ie: Owners Declaration is table that is related to your primary feature layer, and then Assessment is related to Owners Declaration.

jantolihao

Hello, @DougBrowning. Thank you for answering. I tried this one. However, I am having issues on getting all records from one repeat then transferring/referencing them all to another repeat. Yes, we can use the floor example in indexed-repeat for specific record corresponding to specific index, say, index 3. But it seems that indexed-repeat does not cater to all records. I'm still not sure though. But thank you for the link.

jantolihao

Hello, @ChristopherCounsell. Thanks for answering. However, I cannot put the questions in the same repeat since 1 repeat will only create 1 related table. The requirement is that there should be 2 related tables: 1 for Owners Declaration and 1 for Assessment. But thank you for the links.

dougbrowning

Take a look at

indexed-repeat(question, repeat, index number)

Returns the value from a specific question in a repeat record. For more information, see Repeats.

indexed-repeat(${room_no}, ${floor}, 3)

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm

ChristopherCounsell

Put the questions in the one repeat, instead of splitting them in two?

It's a bit difficult to understand the way you have the survey setup but I'd recommend taking a look at these:

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformrepeats.htm#ESRI_SECTION1_9F07ECB9F1C341CF8A05AF54B1B011B0

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-repeats/ba-p/898041

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.