Survey123 pulldata and decimals not returning a value
Hi: I have a survey123 form where I am trying to perform a pulldata calculation. A .csv file was uploaded to the survey's media file. The pulldata syntax is in the calculate column of the field survey. I want the field person to enter a depth value (feet) and then have the following question populated with the corresponding gpm value from the media .csv file.
It looks like pulldata doesn't work nicely when the lookup values have decimals? In troubleshooting, I changed the decimal values to integers and the function works. Thus, my syntax is correct, but leads me back to the decimal issue. Is there any way to get around this? I tried converting to text but my 0.00 value becomes 0 in the lookup and my 0.10 value becomes 0.1. I would like to have all lookup values be honored to two decimal places. Below is my media table.
Hi @cbolen
The pulldata() function should work with decimal input. In the following example, the user inputs a decimal depth and the gpm value returned from the CSV is also stored as a decimal:
It's not possible to specify how many decimal places are displayed in the form for a decimal question (trailing zeros will be dropped). If it's important to display the values to two decimal places (including trailing zeros), you could consider using text questions instead; open the CSV file in a text editor to check that the values have the desired number of digits.
If you encounter further issues please feel free to share your XLSForm & CSV files so I can take a closer look.
Best,
Jim
