Hi Guys, I am new for the community and I have got this problem when checking my XLS form from the online validator. Can anyone help me in solving this issue please
Welcome @alexman,
Could you share a related extract of your form, please?
@Kal_Lam can activate upload right for you, please.
1 Like
Hi Wroos,
Thanks for your prompt response.
Here I have attached the xls form I am building and has some issues which I need your assistance.
Best,
Alex
(attachments)
test.2.xlsx (18.5 KB)
These constraints in your form dont look right. They are the wrong syntax, and its looks like you are trying to re-assign values with them (!?), which you cant, at least not via a constraint.
Can you perhaps describe what you are trying to do here?
1 Like
Hi there, thanks for your prompt response and I just want to indicate that if the respondent is the head of the household, we don’ need to repeat the questions in the head of the household section. That is want I tried to indicate there, but we can remove that conditions. I removed those conditions and tested but the following loading error still appears.
There’s a few issues with your form. First, there appears to be a couple unterminated groups right at the end:
Next, you appear to be calculating the sum() of various values entered during a repeat, however you are doing these calculation inside the repeat group (!), whereas any calculations aggregating all the values of a repeat - eg sum, min(), max() - must appear outside (and intuitively after) the repeat. I suspect this is what is actually throwing the cryptic errors you are seeing.
Have a look at the examples in the sum function documentation for how these calculations should be laid out. There’s also a good example here (courtesy @Kal_Lam): Income calculation inside a repeat group - #17 by Kal_Lam
I might also suggest validating your form before trying to deploy it, to save you some time. This will quickly pickup these form issues.
2 Likes
