Latest Contributions by BrandonArmstrong

Hi Jennifer, I believe the error that you are encountering when attempting to load your survey in the web app is due to the pulldata function and calculation you are using for your geopoint(s). If you take a look at the 'Calculate Location from CSV' sample in Survey123 Connect, you can see the recommended format for referencing lat/long locations using pulldata. You will need to process different parts of your pulldata calculation into separate fields and then concatenate the lat/long values back together to be used in for the geopoint question. Type         Name                 Calculation calculate    lat                    pulldata('em_lookup','lat','locality',${locality}) calculate    long                 pulldata('em_lookup','long','locality',${locality}) calculate   location_calc    concat(number(${lat})," ",number(${long})) geopoint   location             ${location_calc} I have attached a sample of how this looks to this response. Let me know how it goes. Best, Brandon ... View more

Hi Wayne, After taking a look at your XLSForm I see that you have included the pulldata function several times within the same calculation column for a question which includes references to values from other preceding questions.  For use with the web app you will need to separate each pulldata calculation into its own question.  So, in your form, you will need to have 3 separate questions which pull their respective values (these can each be type calculate), then reference those questions in the calculation of a succeeding question which performs multiplication against the values you'd like to reference from preceding questions.   For instance, you current calculation is the following... (pulldata('AllterraRates', 'Daily', 'Equipment',  jr:choice-name(${Equip}, '${Equip}')) * ${EquipRentalDays} * ${EquipNoUnits}) + (pulldata('AllterraRates', 'Weekly', 'Equipment',  jr:choice-name(${Equip}, '${Equip}')) * ${EquipRentalWeeks} * ${EquipNoUnits}) + (pulldata('AllterraRates', 'Monthly', 'Equipment',  jr:choice-name(${Equip}, '${Equip}')) * ${EquipRentalMonths} * ${EquipNoUnits}) You will need to split it up into separate parts so that the web app can process it.  Consider the following... question_1: pulldata('AllterraRates', 'Daily', 'Equipment',  jr:choice-name(${Equip}, '${Equip}'))  question_2: (${question_1}* ${EquipRentalDays} * ${EquipNoUnits}) question_3: pulldata('AllterraRates', 'Weekly', 'Equipment',  jr:choice-name(${Equip}, '${Equip}')) question_4: (${question_3}* ${EquipRentalWeeks} * ${EquipNoUnits})  question_5: ('AllterraRates', 'Monthly', 'Equipment',  jr:choice-name(${Equip}, '${Equip}')) question_6: (${question_5} * ${EquipRentalMonths} * ${EquipNoUnits}) question_7: (${question_2}+ ${question_4}+ ${question_6}) I will upload an example of an edited version of your XLSForm which is working upon making these changes. Let me know how it goes. Best, Brandon ... View more