Pulldata not working on web form but is working in Survey123 app

Question

Hello,

I have a linked CSV file that has per diem rates in it.  I am trying to use the pulldata function to bring in rates based on the zip code and fiscal year.  The function works perfectly in Survey123 Connect version 3.18.124 and in the survey app however it won't load anything when using a web browser.  I can't figure out why it works in the app but not on the web.  I have a different CSV file for employee information in this same form using the same functionality and it works perfectly.

Here is the calculation.  "per_diem_rate" is the name of the csv files, meals is where the number I need returned is location, zip and fiscalyear are the two fields I am filtering by.

pulldata('per_diem_rates', 'meals', 'zip', ${class_zip}, 'fiscalyear', ${class_year})

XLS_and_CSV_Files

ChipMorgan65 · Accepted Answer

Hi,

What you're doing makes sense, but I don't see anything in the pulldata doc that supports multiple criteria like you've specified. I recommend that you request this as a new feature.

In the meantime, a crude workaround would be to concatenate the zip and fiscal year columns into a third column in the CSV and then do a single criteria lookup based on that other column.

Let's call that third field fiscal_year_zip. Concatenate the fiscal year and zip fields into that third field with a - (dash) between the two fields for readability. You can do this automatically with an Excel concat function, but understand that the function will be collapsed to values when saving the CSV file.

You could then revise your pulldata as follows:

pulldata('per_diem_rates', 'meals', 'fiscal_year_zip', ${class_zip}-${class_year})

I'm doing this off the top of my head, so I might well be missing something.

Chip