pulldata function in Survey123 error

280
4
Jump to solution
06-15-2020 11:56 PM
ABUGIS
by
New Contributor II

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

Tags (2)
0 Kudos
1 Solution

Accepted Solutions
DougBrowning
MVP Frequent Contributor

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.

View solution in original post

4 Replies
DougBrowning
MVP Frequent Contributor

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.

0 Kudos
ABUGIS
by
New Contributor II

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?

0 Kudos
DougBrowning
MVP Frequent Contributor

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.

View solution in original post

ABUGIS
by
New Contributor II

Thanks Doug Browning‌ it worked fine and all good.

0 Kudos