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!
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
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
Creating a key that combines both fields as I posted above is still the only way I have seen.