I made a Survey in the latest version of Survey123 Connect and receive the following error when i analyze the Survey: ''survey123 valueerror could not convert string to float: '<openpyxl.worksheet.formula.arrayformula object at 0x0000026BE87B31D0>' '' .
I am able to publish the Survey but when i fill in a Survey on my phone and export it i get another error (see attachment).
How can i solve this problem?
Best regards, Jurgen Rotteveel
Seconded needing the XLSX to analyze further.
Not sure if the issue is related to this just yet, but I will add that you should only use the bind::esri:fieldType and bind::type columns when absolutely needed. Ignore them otherwise. Off-hand, they are the only thing I would think that would cause a mismatch like that.
Hi,
I indeed had used a bind::esri:fieldType , after removing it the Survey is working. I thought a bind::esri:fieldType was necessary for auto filling data from filling in Field maps attributes (in a popup) but after removing the Bind type it is still working and the Field maps data is automaticly filled in in the Survey. Thanks fot the solution!
can you share your XLSX form (or at least the section) where you're doing the conversion? my guess is that it either has something to do with a calculation, or a custom Esri field type (or both are out of sync).
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
