Repeat group counter

[primidiapr]

I have created a form to collect data at the household (family) level. The form first captures common information about the family, and then information for each individual family member.

Since the questions for each family member are the same, I placed them inside a repeat group where the enumerator can click “Add new member” to enter details for additional members.

I added a calculated field intended to display the member number (e.g., Member 1, Member 2, etc.) for each entry in the repeat group. However, the calculated field always shows “1” for every family member instead of increasing incrementally.

How can I configure the calculation so that the member number increments correctly for each repeated entry?

Currently, I have a calculated field named fm_counter with the calculation formula position(..), but this does not work as expected.

Additionally, is it possible to display a note such as “You are currently filling in details for Family Member #x**”**, where x dynamically reflects the correct member number? If so, how can this be implemented?

Finally, is it possible to limit the repeat group based on a value entered earlier in the form? For example, if the enumerator specifies that the family has 4 members, the repeat group should only allow data entry for 4 members and prevent adding a 5th member.

Any guidance or examples would be greatly appreciated.

[Xiphware]

@primidiapr

if the enumerator specifies that the family has 4 members, the repeat group should only allow data entry for 4 members

The easiest way to accomplish this is to set the repeat_count to whatever value was previously entered, rather than trying to enforce a max.

@primidiapr

I have a calculated field named fm_counter with the calculation formula position(..), but this does not work as expected.

I’m not sure why this is not working for you, but yes this is exactly how you would do it.

Please take a look at the following form, which I think does what you desire:

SimpleRepeatCount.xlsx (14.4 KB)

[primidiapr]

This is what my file looks like after adding repeat count and position. When I deploy this, I’m getting the error “TypeError: Cannot read properties of null (reading ‘dataset’)”.

[Kal_Lam]

@primidiapr, you may need to validate your XLSForm using this online validator to check for any syntax issues that may be affecting deployment.

This post discussed previously should help you use the online validator.

Unable to deploy Server error 500

@okware_256, all you need to do is follow the steps outlined below: Open online validator. This screen appears as shared below: [Image 1] There press Choose File and upload your XLSForm. Once the XLSForm is uploaded there, press Submit. As soon as you press Submit, you will see something as shown below: [Image 2] Now press Preview in browser. If your XLSForm has issues, you will see errors and will not be able to open your XLSForm in a browser. But if your XLSForm doesn’t have issues, you wi…

[primidiapr]

The form is working perfectly fine on the validator. But not when I upload it to kobotoolbox. Any idea why?

Also, the screenshot that you shared in your first reply, shows number on the top right corner of each repeated box. Does the same number appear in the xlsx data file?

This is how it shows currently, the number here will also change when position(..) is deplyed sucessfully, right?

[Xiphware]

Can you post the rest of your form here - I suspect the error you are seeing is related to something else unrelated.

@primidiapr

shows number on the top right corner of each repeated box.

This is the iteration number that Enketo displays for each repeat iteration section. It is not stored directly in the final submission data itself. However, the pos calculation(s) - or fm_counter in your form - is an explicit field in the form definition and therefore this data will be included in the submission data and resulting table. eg

results in