Error converting XLSForm

[AmandaBeck]

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?

[Katherine_Clark]

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?

[AmandaBeck]

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

[DougBrowning]

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.

[AmandaBeck]

Hello @Katherine_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