Jump to content
  • 0

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



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?



Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

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.



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...