nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Schermafbeelding 2025-02-04 145152.png

Screenshot_20250204_144654.jpg

DougBrowning_0-1739306069634.png

force_gnss.png

Encontre mais publicações marcadas com

Accepted answers

abureaux

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.

All comments

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

Seconded needing the XLSX to analyze further.

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

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.