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.