Jump to content

Search the Community

Showing results for tags 'search'.

  • 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 19 results

  1. Hi - New Caspio user here...I have a database that was created in MS-Excel with records for research citations that I want others to be able to search. The original file has multiple keyword fields so that people could use drop-down boxes to select more than one keyword. In Excel, this was represented as three columns with headers Keyword 1, Keyword 2, and Keyword 3. Now in Caspio I really want just one search term - Keyword - that will look up the same value for any of the three keyword fields in the database. So...the search term for Keyword is "Resiliency" and Caspio searches the three data
  2. 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!
  3. Hello, I'm trying to figure out how to filer records with a text field that contains comma delimited values. The problem is the search doesn't actually recognize 'delimited' in a field and so 'contains' will bring up records that I need to filter out. For example, if a record's text field has a value of 1,2,3,4,12,22 the user might do a search/filter; "‘contains 2” (it can’t do = 2 because the actual value of the field is “1,2,3,4,12,22” and “2” won’t be equal to it). But the ‘contains’ function will bring up records with not only ‘2’ in them but also ’12’ and ’22’ etc. I tr
  4. Where should I to put the value for X in Next X Days comparison type in search for Report DataPage?
  5. I have a tabular report containing afield that has a lookup table associated with it (1 to many relationship). How do I do a search in the table for rows that have a value that is contained in a lookup table. E.g.I have lookup table of Department ID & Department name. In my tabular report of employees with Employee ID, Employee Name, Department ID (each employee belongs to a particular department) I want to search for Employees belonging to a department, using the department name rather than Department ID. And I want the search to be able to use "Contains" e.g. bring up all Employees w
  6. I have a report I'm using to search through various fields of my table. I would like to include a search box that can search for a term within/across all of my fields. Is this doable? How? Edit: I've continued to look for this info and I found this article http://howto.caspio.com/faq/reports-datapages/how-to-do-keyword-search-across-multiple-fields/ But, I don't understand the steps. When I go to create a submission form, I don't know what field(s) to include. I can't seem to tie the form and report together, and the search doesn't end up working. I'm not sure it's even what I'm looki
  7. I recently set up a virtual field so that my search bar would search across multiple fields. Now, I want to add some drop down boxes to help eliminate some results. For instance, this database includes scholarship information for students. I want them to be able to type a keyword that will be searched across the entire table. Let's say they type "Astronaut." The Astronaut Scholarship will appear. But let's say this student is not a US Citizen and can't apply as a result. I want to insert a drop down box (which corresponds to a citizenship field I have in the table) that would search Astronaut
  8. Is there a way to create a search filter for a calculated field?
  9. I tried to hide my Search button with this code in the Header of my DataPage: <style> .cbSearchButton{ display:none !important; } .cbSearchButtonContainer{ display:none !important; } </style> And it works except when I deploy the embedded script in WordPress, the search button reappears.
  10. I want to be able to search a table according to the criteria of a “From Time” (greater than equal to) and a “To Time” (less than equal to), the problem is that there is no option for Time, only Date AND Time. The result should be ALL records from all dates between the specified time. Eg. Created on (Timestamp) From 06h00 To 08h00 à display records created between 06h00 and 08hoo across all of table history. Currently I am using a submission form with a virtual field to pass the parameter to the search form. I have one Timestamp field and three Date/Time fields I wish to search. Is t
  11. How can I use Multiselect listbox to perform a search with OR logic? I have separate search and report as described in the video: https://howto.caspio.com/getting-started/display-results-on-a-separate-web-page/ Does anybody have ideas?
  12. i have a search page where i am searching using a view and i would like to hide columns that are totally empty
  13. I would like to ask for help in my JS code. I'm trying to change the value of a checkbox in a search form when a specific option in a dropdown is selected. I want the checkbox to be set to true if "Math" is selected in the dropdown. Below is my code that's not currently working: <script> function checkdropdown(){ var drpselected = document.getElementsByName("Value1_1").value; if (drpselected == "Math") { document.getElementsByName("Value2_1").checked = true; } else { document.getElementsByName("Value2_1").checked = false; } } document.getElementsByName("Va
  14. I have a table that includes the person's date of birth (DOB). I am able to create a virtual field in my Report DataPage that calculates the age from the DOB and display it. I also need to be able to search on age. How can I do searches such as: 1. Age is equal to x 2. Age is greater than x (minimum age is x) 3. Age is greater than minimum x and less than maximum y Thank you for any help on this. The application has to do with booking models, where age is an important factor.
  15. Hi there, Could anyone help me to resolve the issue with the following search logic scenario: a user can search by Date field with "from&to" range with criteria, but if criteria are blank I would like to return records with blank Date field Field datetype: Date&Time Thanks, @Vitalikssssss
  16. Ok so I have a search function that runs as a multi-select. The search options look like this: Project Status: Awarded In Planning In Design Under Construction Project Completed Project Canceled There's a lot more than that but that's the general idea. What I want is to have a checkbox that says "Search Completed/Canceled projects?" and only when that checkbox is marked yes should Completed & Canceled projects be included in the search. If they run the search without that box checked I want all Completed & Canceled project to be omitted from
  17. I've added a "Reset Search" button in a search page and wonder if it's possible to have the "Reset Search" button be on the same line as the "Search" button. I'm looking for something like figure A in the attached image. I know how to add an additional "Search" button thanks to this thread and I've come up with this code: <div align="center"> <input class="cbSearchButton" id="searchID1" name="searchID" type="submit" value="Search" /> <input class="resetButton" onclick="window.location='[my_URL]'" type="button" value="Reset Search" /> </div> However
  18. I have a long search form with a number of optional checkboxes that are necessary when needed, but infrequently used. Is there a way I can place an additional search button at the top of the page so users don't have to scroll to the bottom to perform a search? Thanks!
  19. Hello! We have a search form for a database in which when we search by keyword it shows the results from the previous search made but not the last one. For example: Search #1: United States Results #1: random results Search #2: Ecuador Results #2: United States ... Results #3: Ecuador Has anyone had this issue and was able to fix it? Thanks!
×
×
  • Create New...