Populate Applicable Rule Violated

BattJones

I'm converting a Word inspection form into Survey123 that has several sections with multiple Yes/No/NA questions each. 'No' answers relate to a rule/statute violation. The current inspection form has a bunch of VBA that plugs in the applicable rule/statute that is violated and creates a new row for a description of the violation and actions to remedy it.

I'm wanting to find the best way to replicate this behavior in Survey123, but am having difficulties in finding a good way to implement this. My less than ideal solution right now is a line item for each (see below). This doesn't seem super scalable/efficient as it will likely end up being 800+ rows.

• select_one (Yes/No/NA)
• Note (with rule/statute number)
• Text (description of violation)
• Text (description of remedies)

Is there a different way I can approach this? I've not found anything on if populating a repeat based on prior criteria is feasible or if JavaScript might be able to help.

 

Any assistance is greatly appreciated. Thanks!

BattJones

Hey, @DougBrowning . I appreciate the response. I actually previously implemented your plant species suggestion above on another form and it works beautifully, so thanks for that one!

I had the same thought, but unfortunately I don't think it'll fit the bill unless I can add additional functionality to the repeat table. The way the Word doc functions now is that it identifies what rule/statute is applicable to the violation (if X Violation then Rule 1234 applies, if Z Violation then Rule 678, etc.) and then creates a new row at the bottom of each section for each violation/description/remedy.