Latest Contributions by AmyRoust

Several people in my organization installed the ArcGIS for Excel add-on today. Two of us had no issues; the other two see a blank screen instead of the Choose an ArcGIS connection screen. In other words, they should see this: But instead, they only see this: Troubleshooting so far: I don't think it's a firewall thing since we're all on the same network and two of us were able to connect. Everyone has the Microsoft Access driver that is required for using Excel in ArcGIS Pro. The only other difference that we can think of is that the two who are successful have local admin rights on their machine and the other two don't. It seems odd that admin rights would block a simple sign-in screen, though. Anyone have any ideas on what else we can try?   ... View more

Looks like others have had similar issues to this, but I'm not finding a solution to my version yet. I have two notes fields that are doing simple calculations based on values from other fields. Here is a sample: ${Ravg_after}*${Kavg_after}*${LSavg_after}*${Cavg_after}*${Pavg_after}   In the Connect desktop application, it calculates as expected:   When I try it in a web browser, I get NaN:   I tried adding a round function since it had so many decimal points, but no luck. What am I missing? ... View more

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. ... View more