FormLogicError: Could not evaluate...

AmyRoust — Thu, 27 Oct 2022 20:51:06 GMT

I'm working on a really complicated Survey123 Connect XLSForm and have hit a roadblock. Everything works until I introduce this question:

type: note

name: Ravg_before

label: Ravg Before

appearance: horizontal

calculation:

if(pulldata('BMPMod_Chart','ChangeBefore','PracticeName',${practice})='None',pulldata(${LandType_Before},'Ravg','County',${county_bmp_location}),pulldata(${LandType_Before},'Ravg','County',${county_bmp_location})*pulldata('BMPMod_Chart','MultiplyBefore','PracticeName',${practice}))

When I fill out the form inside Survey123 Connect, I get the correct result:

But when I publish the survey and open it in a web browser, I immediately get this error message:

I realize that this is really hard to troubleshoot without providing the XLSForm and the related media files that drive all of the lookup values. I'm just hoping for some clues that might get me across the finish line without having to call tech support.

Things I've tried:

Ensured that all column names in all CSV files in the media folder have no spaces or special characters.
Ensured that every record in every CSV in the media folder is fully populated (no null values/empty cells)
Renaming the two CSVs that have a - in their file name to remove the -

I have not removed the underscore from the CSV called BMPMod_Chart because I am successfully calling that CSV and returning values in earlier questions without error.

Any other ideas on what I can try? I don't know what the web browser is checking that the desktop app is not.

Re: FormLogicError: Could not evaluate...

ZacharySutherby — Thu, 27 Oct 2022 21:00:23 GMT

Hello @AmyRoust,

This looks to be the same issue outlined in BUG-000139694, if you separate the pulldata functions into their own calculate questions, then reference those calculations in the if() statement does that resolve the issue?

Re: FormLogicError: Could not evaluate...

AmyRoust — Thu, 27 Oct 2022 21:13:18 GMT

Oh my gosh, yes! Thank you so much! Breaking it apart fixed the problem. You are my hero!

topic Re: FormLogicError: Could not evaluate... in ArcGIS Survey123 Questions

FormLogicError: Could not evaluate...

Re: FormLogicError: Could not evaluate...

Re: FormLogicError: Could not evaluate...