Jump to content

Search the Community

Showing results for tags 'multiple values'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Caspio Bridge
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


MSN


Website URL


ICQ


Yahoo


Skype


Location


Interests

Found 3 results

  1. 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!
  2. 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.
  3. 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. Store C - (results returned) 788 Okaywhereissummer Rd AwwwMan, FF 80022 Manager: Boogie Wonderland Store C 788 Okaywhereissummer Rd AwwwMan, FF 80022 manager: Popicle Pop Store C 788 Okaywhereissummer Rd AwwwMan, FF 80022 Manager: Lucy Lunchmeat Store C 788 HereIam Rd AwwwMan, FF 80022 Manager: Dolly DoorKnob Store C 788 HereIam Rd AwwwMan, FF 80022 Manager: Kick Rocks Store c 788 HereIam Rd AwwwMan, FF 80022 manager: Popicle Pop ***The goal: I would like the results to return unique store locations, (so that means all the managers associated to that one store are displayed), and create a link the user will click on and route to the details page, this page will display a snippet of information pertaining to each manager at that store. (see below) Store C 788 Okaywhereissummer Rd AwwwMan, FF 80022 (link > click to details page with snippets of information of the managers associated to this location only) Manager: Lucy Lunchmeat Manager: Boogie Wonderland manager: Popicle Pop Store C 788 HereIam Rd AwwwMan, FF 80022 (link > click to details page with snippets of information of the managers associated to this location only) Manager: Dolly DoorKnob Manager: Kick Rocks manager: Popicle Pop I also need to be able to search on the manager name individually, this result set would return all the stores the manager is assigned to and create a link to the details page that will display a snippet of information pertaining to manager selected. Select manager > Popicle Pops Store C 788 HereIam Rd AwwwMan, FF 80022 (Name: Popicle Pops Link) Store C 788 Okaywhereissummer Rd AwwwMan, FF 80022 (Name: Popicle Pops Link) Whew! Is this possible? I have researched JavaScript (case - switch ) , which I think can be a option, only I don't know where to begin. I'm stuck. Help !! Ideas, Any suggestions on how to achieve this complex search form is greatly appreciated. Hopefully, it's a simple solution. Thanks Dawana
×
×
  • Create New...