Search the Community
Showing results for tags 'multiple values'.
Found 3 results
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, html, email, url link in a Tabular/Gallery datapage. Multiple values can be shown for a text field on a Details page using js and a ListBox type display. Is there any way to utilize something similar for a Tabular/Gallery datapage? I even tried using a trigger to push those multiple values from the text255 field into a Listbox field (because you can display a Listbox type field in a Gallery datapage) but the trigger won't allow updating into Listbox fields. This is frustrating- having dynamic lookups for Listbox fields would solve this issue entirely.