Hey everyone, I am a Survey123 novice and am using Survey123 Connect with an XLS Form to create my survey. I am trying to use the pull data calculation but I have been unable to get it to work. I have my .csv in the media folder and my pull data equation is as follows: pulldata('mcintosh','Totalalive','PlotID',${plot_id})
The PlotID field is being calculated based on the answer to three questions in the form, which creates the id of 3 numbers separated by two periods (ex: 0.3.2). I don't get any error messages when I save the XLS form but no data ever populates the field from my calculation. Attached are screenshots of my .csv, XLS form, and the form as seen in Survey123 Connect. Previous existing is the field where I am trying to get the pull data formula to return the value from the .csv. Any help is much appreciated. Thanks.