Can I call multiple outputs from a series of inputs in Survey123?

[deleted-user-57QLt_-7NcdX]

Hi,

I have a fire weather form developed in Survey123 where I am asking users to input three variables; 1) elevation, 2) dry bulb temperature, and 3) wet bulb temperature.  The elevations are currently grouped into two categories, 0-500 feet (low elev) and 501-1900 feet (mid elev).  

From those inputs, I would like to provide them with (autofill) Relative Humidity and Dew Point readings using the attached CSV file.  

While this seems like it should be relatively straightforward, I'm struggling for a coding solution.  

Thanks in advance for any help.

[JamesTedrick · Accepted solution]

Hi Scott,

To accomplish this, you would need to create a new column that aggregates your 3 lookup values into 1 code value.  The you can generate a matching code in the form and conduct a lookup.  I've attached an implementation based on your form & data.

[deleted-user-57QLt_-7NcdX]

Thanks James,

That solution worked well.  Much appreciated.