pulldata function in Survey123 error

[ABUGIS]

Hi guys,

I'm trying to use the @pulldata function in Survey123 and populate a note with Common species Name when the user select the Scientific Species name.

i keep getting the ODK validate errors saying:"Dependency cycles amongst the xpath expressions in relevant/calculate"

attached is my XLSForm and csv pull data file from my media folder and also screen shot of my error.

can someone please help as i have exhausted myself looking for an answear ?!

Thanks

Naeim

#survey123

#survvey123pulldata

#pulldata

James Tedrick‌

[DougBrowning]

I think you have the pulldata on the wrong line.  Move it down 1.  Right now you are trying to calculate into a field using the value from that field.  

Hope that helps.

[ABUGIS]

Thanks Doug Browning,

if i move it 1 row down it trows a calculation error and when i try using the pull data with no calculation it comes up with another error. i have tried it many different way and nothing worked.

appreciate your help anyway.

have you tried the 1 row down on your end?did it work?

[DougBrowning · Accepted solution]

Sorry I just looked quick and saw you were looking up in the same column as the field you were in.

You need to change your lookup to use the Spec_Sci name.  No need for field com_note just make con_name a note.
pulldata('BWISpecies','Common','Scientific',${Spec_Sci})

In my project what we do for species is

CODE  Scientific Name  Common name  

That way a user can search for any part that they know and then they get it.

Hope that makes more sense.

[ABUGIS]

Thanks Doug Browning‌ it worked fine and all good.