Jump to content

Search the Community

Showing results for tags 'search'.



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 34 results

  1. 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.
  2. Is there a way to create a search filter for a calculated field?
  3. 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 there any way to setup a criteria with only a time precision?
  4. 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?
  5. i have a search page where i am searching using a view and i would like to hide columns that are totally empty
  6. 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("Value1_1").onchange = function() {checkdropdown()}; </script> Also, here is a screenshot in the "Configure Search Fields" step of the DataPage: I'm hoping someone can help me with this. Thank you.
  7. 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.
  8. 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
  9. 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 the Search Results. What is the best way to go about this? Virtual Fields? Triggers? Thanks in advance for your help!
  10. 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, though the above looks like what I'd like, I would then need a way to hide the original "Search" button, which I don't believe would be possible.
  11. 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!
  12. 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!
  13. Hi Guys, I hope somebody has an idea for this. I'm stuck creating the report, step 3 below. 1) user Bob insert its color preferences on a search web form: Name color1 color2 color3 color4 Bob red blue yellow black 2) it is compared against a table I created with information from other users that also like colors Name color1 color2 color3 color4 John red white orange brown mary purple magenta green grey Elen white green red blue 3) I need to give Bob the best match with the other users of the database. On the report I search by "red" OR "blue" OR "yellow" OR "black" at the same time Table of best matches for Bob (this would be the report) Name "Hits on search" Elen 2 John 1 I hope to be able to do this with a calculated field on my report ("hits on search", on the example) and sort by it. Somebody suggested to use COUNT, but that counts vertically across users, if I understood correctly: (times "red" showed up under the color1 column, for example) Any idea would be appreciated. Thanks V.
  14. When using dropdown in a form, I would like to be able to search in a dropdown with the criteria "Contains". Now, if I type "C", the cursom jumps to the first Item in the list that starts with the letter "C". Is it possible to narrow down a search in a dropdown when typing and where only items that contains the text I typed are displayed?
  15. Is there a way to use the 'Allow users to select data using a search form' option on a tabular report but to SKIP opening the search form on 1st load of the report? Meaning, I'd like the user to go straight to the report's results and THEN if they want to search/filter they can click the 'Search' link and go to the search form. I know how to use a separate submission form to do a search/filter but that causes a LOT of extra datapages in the app and I have to pay for those over my limit (my app is huge). Also it's far more intuitive to open the full results set and then do a filter. It's clunky to have to go through a search form first to get to the results. This should be a standard option, IMO, like a check box in the wizard for 'don't open search form upon report opening. That said, I need a workaround. I got some basic concept for it from someone: "You will need to pass parameters to the URL of the resultspage for eg: showform =0 or 1 In the configure search fields you will write a javascript to hide the form is the showform is 0, When they link to see the search form again then you will pass the parameter to say 1 then the search form JS will show the fields in the search form. " I have no idea how to implement this in the report itself. If anyone has any ideas that'd be really great- thanks!
  16. Hello, I have set up a search form with Caspio. Lets assume there are 2 types of users: those who pay and those who use the service for free. Is there any way to limit the daily number of searches which the free user can run (say to 3 or 5 searches per day), while the users who are paying can run as many searches as they want daily, Thanks for your help !
  17. 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 across the entire table, but remove anything that didn't also meet the citizenship requirements. Is it possible to do this? The online chat support person said I would have to do a virtual field, but because I have a free account, couldn't give me more information (understandably).
  18. Hi, The Search and Report datapage has only one choice now to add a new variable for the results and that one is HTML Block. Any reason I am not seeing calculated field, Virtual field etc. Other datapages seem to be fine. See screenshot below. I appreciate any help. Thanks
  19. Sheik

    Word Report

    I need to create a datapage where my client can type in a report. My would prefer if the section resembles Microsoft word processor and need a search option where any keyword can be picked from the "MS Word" section
  20. 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 looking for. Thanks!!
  21. Thanks in advance for any assistance. I am trying to get results based off employer and location. Here is an example: Table 1 (Company): Employer_1, Employer_2, or Employer_3. Location is Business_Zip Table 2 (Customer): Employer_1, Employer_2, or Employer_3. Location is Customer_Zip When submitting a request form, the customer can request an answer from Employer_1, Employer_2, and/or Employer_3. The request will go to the Company with the matching zip (IE: Business_Zip = Customer_Zip) Here's where I'm stuck. I need to create a workflow that directs the question to the correct Company, based off matching Employer and zip. It would look like this: Customer completes the submit form, and request the information to come from Employer_1 and Employer_2. When Employer_1 w/ matching zip logs on, it will show the request, same for Employer_2 w/ matching zip, however Employer_3 + Employer_1 without matching zip + Employer_2 without matcing zip, will not show any data. I apologize for the extreme detail. I've been through the forums, online videos, and help questions for over a week now. I probably need to step away, but this is one of the last steps before I can launch. Thank you again!
  22. I have a need to search through 311 data pages for text. Is there a way to enter a search argument, say - "howdydoody.php" once, and have Caspio return a list of all data pages which contain the phrase "howdydoody.php" ? Thanks Bhang
  23. Gregs101Pros

    Not A Search

    I simply want to place a box next to a listed service trade, on my home page, where a site visitor will enter his zip code and be directed to all the say, Plumbers in a particular zip code that we have a page in our site for . I do NOT want a search box, I have that now and it is a 2 step process. I'm looking for one simple process. Is this what Caspio can do ? Are there any video tutorials or instruction for this ? Advice plzz. THANKS ALL !
  24. Hello everyone! I try to filter records by "previous month", but I cannot find the filter. There are the "Current Month", "Before Now", "Previous X Days" filters. I tried them all one by one and I tried combining of these filters, but the problem is "Previous X Days" is variable. I mean, today the previous month is: IS Previous 34 days AND NOT Current Month But tomorrow it should be 35 days... Any ideas are very much appreciated! Thank you for your time!
  25. Hi, I want to add some contents under certain column in result page based on condition. Is it possible to add new customized column or edit exiting column in result page through java script. Also unable to create new customized field in view. So, I am stuck. Can anyone help Thank you Ashfak
×
×
  • Create New...