Survey123 if statement and indexed repeat TypeError

[JeetzPatel]

Hello all, I hopefully have a simple one. My S123 form aims to help users populate information for asset inspections. For some assets, they may have repeatable sections that have the same information between sections, hence I'd like to minimise how much data entry occurs on site.

In my S123 xlsx, I am attempting to populate a second repeat based on the answers of a previous repeat. My logic in the calculation field for the second repeat (for Q6) is:

if(${Q5}=1, indexed-repeat(${Q3}, ${RepeatA1A}, position(..)), '')

The aim here is to populate Q5 with 1 or 0 (Yes/No) based on if this asset's particular section has the same information as the other section. However, this calculation throws a "TypeError" in Q6:

I have looked at other help questions with similar issues and have changed the esriFieldType but can't pinpoint the esriFieldType I need. I have also changed Q6 to "calculate" instead of "select_one material" but this just makes Q6 not appear correctly:

Additionally, when I change the calculation to:

indexed-repeat(${Q3}, ${RepeatA1A}, position(..))

There are no issues with Q6, however I'd like users to have to option to decide whether or not the autopopulation of the repeat needs to occur or not.

I have attached my xlsx for context. Has anyone got some ideas? Any feedback is greatly appreciated. Thank you 🙂

[DougBrowning]

Q5 is a string have you tried quotes on the 1?   

if(${Q5}= "1", indexed-repeat(${Q3}, ${RepeatA1A}, position(..)), '')

Also it looks like you want to check in the same repeat number?  If so no need to index it at all.

Just  if(${Q5}= "1", ${Q3}, '')  would work.

Try that.

[JeetzPatel]

Thanks Doug. The quotes didn't work unfortunately. I checked not using indexed-repeat and found that if I create say 1 repeat record in the first repeat, then copy it using this method in the second repeat, if I then create another record in the first repeat, the value of the first record in the second repeat get overwritten with the values of the second record in the first repeat, which is not ideal in my case 😞

[DougBrowning]

Sorry I missed that these are two different repeats.  I think Deon answer may help as some functions do not fire correctly inside an if.  You still probably need "1" as these are lists so it will be a string.

Try that.

[DeonLengton · Accepted solution]

split your calc in two for the retrieval of the selected material in the first repeat

see attached Excel file... hope it helps

[JeetzPatel]

Thanks Deon, this worked pretty well. The need for another field is tough but I can work with that.