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
Solved! Go to 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.
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.
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?
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.
Thanks Doug Browning it worked fine and all good.