Number range in excel file

Support
1

Hi,

I'm trying to constrain the range of numbers that can be inputted into an
integer box. I'm building my form in excel.
Can anyone provide some advice? I've been searching the forum but can't
find a relevant answer.

Thanks

Fran

2

https://formhub.org/syntax/#32-constraining-responses

subtitle: "constraining responses":
http://opendatakit.org/help/form-design/xlsform/

After you build your form in Excel and convert it to an XML file, you can
do more advanced
constraints: http://opendatakit.org/help/form-design/binding/
(might be able to use the advanced features in Excel, I'm just not familiar
with it)

··· On Monday, March 17, 2014 10:13:12 AM UTC-7, fr...@blueventures.org wrote: > > Hi, > > I'm trying to constrain the range of numbers that can be inputted into an > integer box. I'm building my form in excel. > Can anyone provide some advice? I've been searching the forum but can't > find a relevant answer. > > Thanks > > Fran >
3

Thanks for the link. I've got this to work just as we need.

··· On Monday, March 17, 2014 8:16:11 PM UTC, havey dewlett wrote: > > https://formhub.org/syntax/#32-constraining-responses > > subtitle: "constraining responses": > http://opendatakit.org/help/form-design/xlsform/ > > After you build your form in Excel and convert it to an XML file, you can > do more advanced constraints: > http://opendatakit.org/help/form-design/binding/ > (might be able to use the advanced features in Excel, I'm just not > familiar with it) > > > On Monday, March 17, 2014 10:13:12 AM UTC-7, fr...@blueventures.org wrote: >> >> Hi, >> >> I'm trying to constrain the range of numbers that can be inputted into an >> integer box. I'm building my form in excel. >> Can anyone provide some advice? I've been searching the forum but can't >> find a relevant answer. >> >> Thanks >> >> Fran >> >