Trying to terminate survey if a calculation is in a certain range

Hi I am trying to work out how to end a survey if the result of a calculation is outside of a certain range. For example, we need the calculated variable to fall between 71 and 275 to include the participant. If outside of that we want the survey to end.

Please can you help with this?

Hi,
Going to the end of this page
https://opendatakit.org/help/form-design/binding/, read "Setting a relevant
conditions on group".
Best,

··· Le jeudi 26 janvier 2017 21:28:05 UTC+1, kja...@berkeleyair.com a écrit : > > Hi I am trying to work out how to end a survey if the result of a > calculation is outside of a certain range. For example, we need the > calculated variable to fall between 71 and 275 to include the participant. > If outside of that we want the survey to end. > > Please can you help with this?

Sadly I am working on the excel spread sheet and not editing raw html files so can use this. But thank you anyway.

I am trying to get it to accept a range. It will accept one parameter but I want it to say if between 71-252 eligible if less than 71 and above 252 not eligible and however I do it it doesn't seem to work.

Can anyone help with this using excel?

··· On Friday, January 27, 2017 at 9:06:07 AM UTC-5, Amal wrote: > Hi, > Going to the end of this page https://opendatakit.org/help/form-design/binding/, read "Setting a relevant conditions on group". > Best, > > Le jeudi 26 janvier 2017 21:28:05 UTC+1, kja...@berkeleyair.com a écrit :Hi I am trying to work out how to end a survey if the result of a calculation is outside of a certain range. For example, we need the calculated variable to fall between 71 and 275 to include the participant. If outside of that we want the survey to end. > > > > Please can you help with this?

Thanks Amal. I am not building the raw hmm file but using the excel spread sheet so sadly I can use this :frowning:

··· > On Jan 27, 2017, at 9:06 AM, Amal wrote: > > Hi, > Going to the end of this page https://opendatakit.org/help/form-design/binding/, read "Setting a relevant conditions on group". > Best, > > Le jeudi 26 janvier 2017 21:28:05 UTC+1, kja...@berkeleyair.com a écrit : > Hi I am trying to work out how to end a survey if the result of a calculation is outside of a certain range. For example, we need the calculated variable to fall between 71 and 275 to include the participant. If outside of that we want the survey to end. > > Please can you help with this?

Hi, Kirstie.
Try to adapt the file in attach to your needs.
variable2,variable3 and variable4 are those which won't be shown if
variable1(your variable of interest) is out of the range you've specified.
Best,

relevantconditionongroup.xlsx (10.5 KB)

··· Le dimanche 29 janvier 2017 02:47:50 UTC+1, Kirstie Jagoe a écrit : > > Sadly I am working on the excel spread sheet and not editing raw html > files so can use this. But thank you anyway. > > I am trying to get it to accept a range. It will accept one parameter but > I want it to say if between 71-252 eligible if less than 71 and above 252 > not eligible and however I do it it doesn't seem to work. > > Can anyone help with this using excel? > > > On Friday, January 27, 2017 at 9:06:07 AM UTC-5, Amal wrote: > > Hi, > > Going to the end of this page > https://opendatakit.org/help/form-design/binding/, read "Setting a > relevant conditions on group". > > Best, > > > > Le jeudi 26 janvier 2017 21:28:05 UTC+1, kja...@berkeleyair.com a > écrit :Hi I am trying to work out how to end a survey if the result of a > calculation is outside of a certain range. For example, we need the > calculated variable to fall between 71 and 275 to include the participant. > If outside of that we want the survey to end. > > > > > > > > Please can you help with this? > >