Jump to content
  • 0

Datapage logic



3 answers to this question

Recommended Posts

  • 0
On 9/11/2018 at 4:11 PM, HampasLOUpa said:

is it possible to put multiple values in a logic? I want to select all the records that are Criteria1 , Criteria2 ,Criteria3 and Criteria4.

Hi @HampasLOUpa.   You want to add multiple values for a Logic right? That's easy.

When you do your logic for a certain DataPage, Caspio allows you to put multiple values as a filter for a field (See full details here: https://howto.caspio.com/datapages/reports/search-and-filter-comparison-types/). If you have multiple criteria that you want to use in your logic, you can just do this:

Set you Logic to "AND".

Configure the filter criteria by setting the comparison to "Contains".

Next is to set the value. You can directly put multiple values instead of one criteria for each value. Put it like this:

"Criteria1 OR Criteria2  OR Criteria3  OR Criteria4 "

That way you won't have four of the same field for each of the criteria which usually is the cause of an error. 

See example below.


Link to comment
Share on other sites

  • 0

You can also add "New Criteria" equivalent to the number of values that you want to use. For example, let's say "Status" is your field and you have four values for that. In your "Configure Search Field" add 4 "New Criteria" . Then in your logic put an "OR" Operator next to the last field if you have other field. And then add the four criteria and then values. This should work well. Also the link provided is helpful. 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...