Unable to upload xls form, Sarah J

Hello, I have two issues I’m facing:

I wrote a pull data function, and I want to link the next question based on the answer of the pulled data, how does this work?

Please advise urgently.

Welcome to the community, @MAYLA! Could you kindly provide more details on this so that the community should also be able to help you out? Try providing some dummy questions, possible scenarios, and the condition you say should link. These details should help the community to understand and provide you with appropriate suggestions.

Hello, I used the online validator which helped a lot, thank you! However, I’m still getting an Error: [row : 21] Missing calculation:

However, I couldn’t know exactly what’s wrong, Please advise asap and thank you so much

Hello, I’m still waiting for your support regarding the missing calculation Error. Please advise urgently

@MAYLA, maybe it’s time you share your XLSForm and the CSV file with the community. The community should be able to help you out.

endlinedraft.xlsx (47.6 KB)
pulldataBLQMAYLA.csv (27.2 KB)

@MAYLA, could you share only the relevant part of the XLSForm with the pull data function so that the community could test it for you without having had to go through the entire form?


at the very top name of “Calculation” should be in lower case as “calculation”. And then in row 34 there is missing " '" missing after Nowpregenant

And i found some relevant logic errors as well in some place.

Other than that I was able to validate the form and its working on my side.

Dinesh Dongol

1 Like

Thank you for your help, I was able to fix the pull data function and fixed logic issues. However I’m now getting this error while trying to open the form

There are following errors in your sheet

Error: [row : 21] Missing calculation.
[row : 7] simserial is no longer supported on most devices. Only old versions of Collect on Android versions older than 11 still support it.
[row : 17] Group has no label: {‘name’: ‘take_now’, ‘type’: ‘begin_group’}
[row : 18] Group has no label: {‘name’: ‘start_q’, ‘type’: ‘begin_group’}

1 Like

@MAYLA, I still observe the following issue in your XLSForm

If you closely observe here this is your pulldata function …

pulldata('pulldataBLQMAYLA', 'NowPregnant', 'WOMID, ${WOMID})

Fix it as shown in the image shared below …

pulldata('pulldataBLQMAYLA', 'NowPregnant', 'WOMID', ${WOMID})

And this should solve your issue.

Thank you for assisting in this! it worked out

1 Like