Search the Community
Showing results for tags 'multiple values'.
Hello, I have a table I am maintaining of products. It has about 1,000 records in it. One of the fields is SKU, which is a unique identifier for each product. Some users would like to be able to search for several SKUs within the file...how can they (or can they at all?) search for 100002, 102567, 256789 in one search field? I have the parameter today set up as "contains" - should I do something else? I've tried some boolean separators as well like ampersand or * but those didn't work. Any thoughts or ideas I could try? Thank you!
Hello, I was hoping at some point soon Caspio would enable Lookup tables/views in ListBox type fields so the user could create their own choices for the Listbox (instead of it being hard-typed in in the table Design for that Listbox field). It's been awhile though and I can't wait any longer- so I'm using the older method of js and a text field to store multiple values comma delimited. This works fine except I don't have a way to show the related text values to the stored numerical values in a Tabular or Gallery datapage. This is because the field (text255) only has the option for Text,
Greetings, I have a data set with a store with many locations Search form store name manager name Store A = 1 manager Store B = 1 manager Store C = multiple managers for example -CORRECT Store A 123 Somewhere Ave. wish, RR 80012 manager: Popicle Pop - CORRECT Store B 456 Summer Time Hopefully, DD 80014 Manager: Groovy Man The Problem: When I select Store C The results return all the stores assigned to Store C with manager names, however the stores name and address are duplicated, the manager names are unique.