Is it possible to submit a single text list of multiple items in a single search?

[randomspam]

Hi, I've not got much experience of Caspio yet so wanted to understand if this was possible as it's key to a project I was thinking of building.

In a data page, I want a user to be able to submit a list of items, this would be an actual list, not built up systematically one entry at a time. The list could be comma separated for example but all the entries would be submitted at once. Each submitted item would have different values attached to it that would need to be returned from tables.

For example,  I could store the colours in my database.

Red = 1

Green = 2

Blue =3

Could I then enter into a single search box "Red, Green, Blue" and have the values, 1,2,3 returned to me in my results?

Can Caspio break down my single list of items into separate items and search for them individually?

Thanks

Rs

[AnchovyXL]

Hi randomspam,

I don't know if you can use a single search box for that.

What you can do instead is add new criteria to your field.

In the example you gave, you can add three criteria for the field "Color".  (See screenshot here: http://prntscr.com/l45g2h)

This won't show you a single search box but three search boxes for the "Color" instead.

It will show you a result that might be close to what you want.

You can also play withe the Logic to customize the search and result.

Please do see this link about criteria: https://howto.caspio.com/datapages/reports/search-and-filter-comparison-types/

There might also be another way to do what you want depending on the entire workflow of your app. If you want, you can send me your workflow and I'll see what I can advise.

Hope this helps.

Thanks.