topic Re: Error converting XLSForm in ArcGIS Survey123 Questions

Error converting XLSForm

AmandaBeck — Tue, 08 Feb 2022 19:17:43 GMT

I cannot figure out what is causing this error message when I try to validate my Survey123 form. The error message is attached as well as my form. Any thoughts?

Re: Error converting XLSForm

Katie_Clark — Tue, 08 Feb 2022 19:25:08 GMT

Amanda,

It looks like the error message in your JPG is cut off, and the XLS Form PDF is a bit hard to read (for me at least) since the calculations overlap into other cells and it's a static format so I can't change cell widths.

Could you possibly provide the full text of the error message, and also provide the XLS Form in table format?

Re: Error converting XLSForm

AmandaBeck — Tue, 08 Feb 2022 19:31:14 GMT

b'ODK Validate Errors:\n>>Something broke the parser. See above for a hint.\nDependency cycles amongst the xpath expressions in relevant/calculate\n\nResult: Invalid'

Above is what the error states below the Error Title: Error converting XLSForm

Re: Error converting XLSForm

DougBrowning — Tue, 08 Feb 2022 19:36:52 GMT

You have a loop here

pulldata("@javascript","function_nextid.js","Brant Lake Challenge Finisher Survey",${finisher_number})

You cannot give finisher_number to a function then get a value back into that same field. The would create an endless loop.

Dependency cycles can be hard to understand so I hope that makes sense.

Re: Error converting XLSForm

AmandaBeck — Tue, 08 Feb 2022 19:43:54 GMT

Hello @Katie_Clark and @DougBrowning

Overall, this is what I am trying to do. I created a survey in the web version initially which I have connected with integromat for sending an email to the survey submitter with an attachment including a Completion Certificate. On that Completion Certificate - which is a report from Survey123 - there is a spot where it says the Finisher Number, meaning the number of which they completed the challenge. For example, 1,2,3 and so on. At first I was using the ObjectID field as the identifier for that Finisher Number, but after reading some more and of course doing tests of my integromat scenario, when I wish to go live with my survey, the Certificate Finisher Number will not be accurate since I cannot delete ObjectID's. I than came across a feed on ESRI community talking about using Javascript and Survey123 Connect to get this to work. My plan was to have an auto incrementing field in my survey123 form which I can than use in the report or Certificate that is then sent to the survey submitter.

Please let me know your thoughts, much appreaciated!!

-Amanda