Data range validation

[BigJohn]

I hope I'm not asking a really foolish question but I have search around without much success.  How do check that data entered in a form is in a specific range.  Lets say we have a currency field "Rent".  How do we check in a form that the amount entered is greater than 0 and less then 10,000 say?

Thanks

[Mathilda]

Hi BigJohn,

 

I think this script might help. Please feel free to ask if something is unclear.

[Kurumi]

You could try using Criteria and changing the Comparison Type to Greater than and less than. You might want to check this article: https://howto.caspio.com/datapages/reports/search-and-filter-comparison-types/

[telly]

Hi @BigJohn,

I just want to add this helpful documentation https://howto.caspio.com/tech-tips-and-articles/range-search-finding-data-between-two-numbers-or-dates/