Search for negative and positive records

[imJihyo]

Hello! I've been looking for possible solutions, but I can't seem to find any. Is there any way to make a field in search form to look for either positive values or negative ones? I tried working with criteria but can't make it work. Any help would be appreciated! <3 I'm working with an integer field btw.

Thanks in advance!!! 

[ParkLoey]

Hi @imJihyo, this took me some time to figure out as well! I noticed Caspio has a "range" comparison type in search fields.

Basically, what you need to do once you've added the field to your search fields, is choose from the radio button, dropdown, or list box form elements then check the comparison type. You'll see the "range" option there. After that, you just need to configure what you consider is positive or negative. Here's what mine looks like:

My "negative" values never exceed -700 and positive ones don't exceed 30000 so that's what I indicated.

 

I hope I helped you figure out how to do it 

[kpcollier]

I think you can do this with a combination of Criteria, Virtual Field, and Rules. I haven't tried this, just a thought in my head.

• Split the Integer field into two criteria. For both criteria, set the Form Element to Text Field. Go to the Advanced Tab, check the 'On Load: Receive a Parameter'. Set Default Value to 0. 
• For one criteria, set Comparison Type to Greater Than. For the other, set it to Less Than. 
• Use workflow in this article to hide the integer field and the criteria:

https://howto.caspio.com/tech-tips-and-articles/how-to-hide-fields-in-datapages/

• Add a Virtual Field dropdown or radio buttons with values of Negative and Positive for the users to select to search for Negative or Positive values. 
• Create a new Rule. For Criteria, add the Virtual Field = Positive. For Action, Disable the Integer Criteria with the Less Than comparison type.
• Create another rule for when Virtual Field = Negative. For action, Disable the Criteria with the Greater Than comparison type.

When you disable fields, they aren't used in the search filtering. So the idea is to split the integer into two criteria, where one is searching for values less than 0 and the other the opposite. Then use a virtual field to delineate which criteria to disable.