Can you use pulldata() to grab data from multiple rows from CSV?

[Anonymous User]

I am creating a survey to assess park's operations. Within each park there are multiple operation id's for assessment.

I want to use pulldata() to list out the id's in the park, not just one. I need to do this for other features in the parks, like there may be multiple playground units in one park and I want to display all of their id's/info as well.

Here is an example of my csv looks like:

ParkID	OperationID	ParkName
1000	00025	Julia's Walk Park
1000	00035	Julia's Walk Park
1002	0009	Main Street Promenade

I don't have to have to concat several opid's within the pulldata() formula because not all of the parks contain multiple id's, and there isn't a set number of ops or features per park.

Thanks!

[Anonymous User]

Hi Caryn,

Unfortunately not, due the nature of how pulldata() works, it will return only one single value for the first value it finds in the list that matches the search criteria.

Phil.

[AndrewE]

Is this something that custom pulldata java script functions might be able to do once they are enabled?

[Anonymous User]

Hi Andrew,

Yes, you could use a javascript function to return multiple values as an array or list from a csv file by searching and returning all the values that match the input value.

Phil.

[ChrisRoberts2]

Hi Phil

Do you have an exmaple on how you would achieve this?  For example the extract of a table used in a pulldata function has multiple common names. If a user picks a common name that is not unique I would like to show a warning in a Note or something to show them the unique sub species or scientifc name to ensure they pick the right species.

Cheers

Chris

[PavlovaVitale]

how would you do that?