Search the Community
Showing results for tags 'Search'.
-
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!
-
Working With Calculated Age From Date Of Birth
clicknip posted a question in Calculations and aggregations
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. -
Hi, Is it possible to change the field that's used for a simple sort order, depending on the Search field used, in a tabular/list datapage? I have two Search fields: "Article" and "Workflow" that bring up results. When the user Searches by "Article" the results need to order by field "Article_Order". When the user Searches by "Workflow" it needs to filter by field "Workflow_Order". The user will never Search by both at the same time. I need to do this programmatically so the user doesn't have to use the dropdown or column label sort as it would be confusing to them. I also hate to have to have 2 separate datapages just to deal with the different sort scenario. I imagine the first, easiest part is to remove any ordering from Results Options. But then, how do you put in OrderBy for the results, in either javascript or some kind of css? -
How do I get more than 250 results(10 pages with 25 entries) for my search results... I need a larger results page so I don't have to go back and change up what I want on the page.
-
Hi, I've got a tabular datapage set to be responsive. Normally I use a toggle link to hide/show the Search form above the results (it's a better UX in that you can more easily style the overall page the datapage is deployed on). However, when set to Responsive it doesn't work anymore. I've tried to use the new methods for forms but it doesn't work. This is what works if the datapage is not responsive: The link on the host html page that shows/hides the Search form: <a class="btn page-action" href="#filter" data-toggle="collapse" style="color:green;"><i class="fa fa-filter" aria-hidden="true"></i> Filters</a> In the Search form's header: <div id="filter" class="collapse" style="text-align:left"> In the Search form's footer: </div> I've tried this but it doesn't work (using the same link to toggle): In the Search form's header: <div id="filter" class="collapse" style="display:none;"><div> In the Search form's footer: </div></div> Does anyone know how to use "collapse" with a responsive tabular datapage's Search form?
-
i have a search page where i am searching using a view and i would like to hide columns that are totally empty -
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.
-
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! -
Hi, I have been trying to figure out how to make my search results work. I have a product database that I want people to be able to search. The submission form has: one search field that allows people to type in brand names, materials, adjectives. Results show: Products that contain some or all of the words that were typed in. This is tied to a keyword field that includes lots of product descriptors. How do I change the logic and rules to make this work? Do I need to use Javascript to take the full string and separate each word into separate fields? The regular Caspio "or" logic doesn't work. Here's an example that might make more sense: People type in search results "gold shiny purple flowers" I want to be able to show products that contain gold or shiny or purple or flowers. Ideally the top of the search results include the most relevant products which might have all four words included. But, I want my gold shiny necklace to show up even if I don't have gold shiny flowers. Thanks! I don't know Javascript but I have been able to implement scripts when people give them to me. thanks for your help.
- 4 replies
-
- 1
-
-
- javascript
- search
- (and 3 more)
-
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.
-
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 table fields Keyword 1, Keyword 2, and Keyword 3 and returns any record that has the term "Resliency" in ANY of the three keyword fields. Right now there are three keyword fields, one for each of the three keyword columns in the database. Thank you for any help you can offer.
-
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'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 tried using "" in the search box so "2" would bring up records with just 2 and not 12 or 22, etc, but this doesn't work either. Does anyone know how to deal with this? I can't use List for data type as these records are imported and you can't import to List fields. The value 1,2,3,4,12,22 denotes a multi-record, meaning that record is related to 6 different records in another table. Thanks for any help!
-
Where should I to put the value for X in Next X Days comparison type in search for Report DataPage?
-
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 with "Admin" in the Department name, as there are a number of Departments with "Admin" as part of their name. e.g. Postal Admin, Finance Admin. Apologies if it's a rookie question !
-
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!!
-
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).
-
Is there a way to create a search filter for a calculated field?
-
critera Criteria precision on time alone
Hencoco posted a question in Tables, Views and Relationships
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? -
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?
-
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
-
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!
-
Possible to add "Reset Search" button next to "Search" buton?
telepet posted a question in Styles and Localizations
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.
-
Search by keyword is showing former search but not last one
MartaUCCRN posted a question in DataPages
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! -
Counting Search Hits Across Fields On A Single Record
viterbo posted a question in Calculations and aggregations
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.
