There has been a problem trying to replace ${B2...}

[99911111]

Unexpected KoBoCAT error 400: b’{“detail”:“There has been a problem trying to replace ${B2_WHICH_MEMBER_S_OF_THE_HOU} with the XPath to the survey element named 'B2_WHICH_MEMBER_S_OF_THE_HOU'. There is no survey element with this name.”}’

[Kal_Lam]

Welcome to the community, @99911111! Maybe this online validator should help you identify the exact problem. But this post discussed previously should also help you know what’s wrong with your syntax.

Error message seen: There has been a problem trying to replace ${} with the XPath to the survey element named ‘’. There are multiple survey element with this name

Thank you. The name {data} is also in your revision, then you haven’t used it in a formula and so it seems all right, but it’s not okay, because if I wanted to use it it wouldn’t be possible. I believe we now know that {data} should not be used as a formula field name I edited all 42 submissions by re-entering the datetime value in a new field with a different name. And then I redeployed the xlsx form without the {data} field anymore. I hope this post will serve others to avoid this undocum…

Note you generally see this error message when you reference a variable that is not (yet) defined in your form.

[99911111]

Thank you so much, and it is very useful