Survey 123 error survey123 could not convert string to float:

[JurgenRotteveel]

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

[ToddW_stl]

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).

[abureaux · Accepted solution]

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.

[JurgenRotteveel]

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!

Best regards, Jurgen Rotteveel