topic Re: pulldata() with multiple filter criteria in ArcGIS Survey123 Questions

pulldata() with multiple filter criteria

AlexSteiner — Mon, 13 Mar 2023 19:41:43 GMT

Hello,

Is it possible to utilize the pulldata() function to return a value from an external table based on two filter criteria?

For excample, something like this:

pulldata('Table_Name','Return_Column','Lookup_Column_1','Lookup_Value_1', 'Lookup_Column_2','Lookup_Value_2')

I know this can be done with appearance searches, but I have not found a way to make it work with a pulldata(function) in the calculation column.

Thanks!

Re: pulldata() with multiple filter criteria

DougBrowning — Mon, 13 Mar 2023 22:03:43 GMT

I think I did this by adding a column to contact all the fields together. Then concat in the form and use that in pulldata. So basically making a key field. You can have a formula in excel to do it for you maybe.

Hope that helps

Re: pulldata() with multiple filter criteria

DormodyPeter — Thu, 11 Jul 2024 17:53:40 GMT

Hi, I am also having the same issue as Alex. I need to be able to use the pulldown function and filter 2 lookup columns. Any solutions on how to do this or could you elaborate on your idea above.

Thanks

Re: pulldata() with multiple filter criteria

DougBrowning — Thu, 11 Jul 2024 17:59:10 GMT

Creating a key that combines both fields as I posted above is still the only way I have seen.