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 🙂
