Jump to content

freshstart

Members
  • Posts

    14
  • Joined

  • Last visited

Recent Profile Visitors

671 profile views

freshstart's Achievements

  1. I have deployed 2 datapages to my webpage, 1 submission and 1 report. The submission datapage has a large number of dropdowns so it takes some time to load. Anybody know how I can put a progress bar or spinner up to indicate that date is being retrieved? It doesn't even have to be a progress bar - just a spinner indicating that something is happening so visitors won't leave the page to soon. I would need it to disappear once the datapage has loaded. I saw this article from a while back but it never indicates how to close the bar or spinner once loading is complete. Js: Auto-Submit A Datapage - Caspio JavaScript Solutions - Caspio Community Forums Thanks for any help!
  2. I posted a similar question to this one last year but I am asking for some additional help or new input if it is available. I have a website(www.teesacrossamerica) with a search box and 5 dropdowns which visitors use to filter down to the items that are of interest. I wanted to be able to select the dropdowns in any order and as each dropdown is selected the remaining dropdowns offer only the options relative to the selected dropdown. I contacted Caspio and was told they couldn’t help since cascading dropdowns only work in 1 direction, but that it might be possible using javascript. I was able to design a way of accomplishing what I wanted but it took about 180 dropdowns and cascading dropdowns to make it work. I use javascript to hide and disable dropdowns that are not relevant during the filtering process. Everything works perfectly and the process returns the information the user requests, however, due to the large number of dropdown elements the page loads very slowly as all of the dropdowns are populated on page load, even the ones that are not visible and/or disabled since these events don’t occur until after pageload. View my website and use the dropdowns to see how it works. www.teesacrossamerica.com I now have a couple of questions that I am hoping someone can help with: a. Is it possible to load tables in filestor that can be accessed by my dropdowns and my results page, and would this significantly speed up my page load times? All information in my tables is public so I am not concerned about security b. Is there any other way to reduce the number of dropdowns I have to use possibly by changing the parent element of my cascading dropdowns dynamically (this question I asked before), or by any other means, and how would I do that? I appreciate any help! Thanks
  3. Is it possible to dynamically change the parent field of a cascading dropdown using javascript? the filter and the field for display and field for values would stay the same. If so how would the code read? Any help would be appreciated.
  4. I have 1 dropdown followed by 4 cascading dropdowns lined up horizontally on a submission page. When the submit button is selected the results come out fine, but all of the dropdowns are reset. I don't want the dropdowns to reset when the submit button is selected, but would like to have a separate reset button so the user can reset the dropdowns when desired. Also, the submit button is below the dropdowns and I want to put it and the reset button on the same horizonal line and to the right of the dropdowns. I appreciate any help. Thanks
  5. I have a search page that passes parameters to a results page. I have the search values coming from a lookup table or a custom “Allâ€, with no value if a selection is not made from the lookup. My results page uses the parameters to get the information from a data table. Each cell in the fields of the data table may contain multiple data entries, such as multiple states (AL, GA, FL, etc.) When I select a value from the lookup table it is passed to the results page as a parameter. If a field cell contains the value from the parameter I only want to display the parameter value and not all of the contents of the cell, so I use html to display the value of the parameter. This works fine but-- If there is no value in the parameter I want to show the entire contents of the cell. Can someone give me the javascript code necessary to do the following: If parameter “[@Virtual1]†is blank show field contents “[@Field:fieldname]†Else show parameter “[@Virtual1]†I have little knowledge of javascript so I would appreciate a detailed response if you can help me. Thanks in advance
  6. I have enable deployment but have not actually deployed the pages yet. I want to test them within Caspio first.
  7. I have setup a Submission form with 1 virtual field to pass a search parameter to a Report results page. I enabled advanced options and parameters. On exit I am passing the parameter [@Virtual1] and opening my Results page On my Results page I have enabled advanced options and parameters and set up the search type to filter data based on pre-defined criteria. I am allowing parameters and selected Bridge and External parameters. I then configured the filtering field to receive external parameters [@Virtual1] and to ignore criteria if empty. I set up my Results page fields with the fields I want to view based on [@Virtual1] but when I run my submission form and the Results page opens the parameter has not been passed. As a test I set up my Submission form to return to the same form after submission. I used the footer to display [@Virtual1] and after I press the submit button the page refreshes and shows [@Virtual1] is there. Then I set up the header on my Reports page to display [@Virtual1] and changed my Submission form to open the Results page after submission. The header does not display [@Virtual1] and the report is showing all records instead of the ones related to [@Virtual1]. For some reason my Results page is not receiving my parameter [@Virtual1]. Can anyone help with this?
  8. Thanks Caspio Guru. You have given me several things to look at. I appreciate your time.
  9. I don't think this is what I need, although I may not be explaining my problem clearly. I am using virtual fields to pass the parameters from my submission form dropdowns to my results page. I am using html to show the parameter being passed. It is working fine unless the selection is "All". When I set up my dropdowns in the submission form I use a lookup table and also a custom value set to "All" with no value so that users can select this option and see all records. Since the "All" option has no value there is no value being passed when this option is selected. I would like to display the word "All" on my results page when and only when the user selects "All" from my dropdown on the submission form. Any other selection is passing the parameter and displaying it perfectly. Is it possible to use an "if" statement to assign a value when no value is passed? If so how would I do that? I don't know anything about javascript and very little about html. Thanks, I appreciate your help.
  10. I don't think this is what I need, although I may not be explaining my problem clearly. I am using virtual fields to pass the parameters from my submission form dropdowns to my results page. I am using html to show the parameter being passed. It is working fine unless the selection is "All". When I set up my dropdowns in the submission form I use a lookup table and also a custom value set to "All" with no value so that users can select this option and see all records. Since the "All" option has no value there is no value being passed when this option is selected. I would like to display the word "All" on my results page when and only when the user selects "All" from my dropdown on the submission form. Any other selection is passing the parameter and displaying it perfectly. Is it possible to use an "if" statement to assign a value when no value is passed? If so how would I do that? I don't know anything about javascript and very little about html. Thanks, I appreciate your help.
  11. Thanks so much. I used the html block and it worked great except for 1 thing. I have my dropdown lists setup to allow "All" to be selected. When "All" is selected I cannot get the word "All" to show up using html, it just gives me a blank. I am assuming it is because no value is assigned to this option. Any suggestions?
  12. Is it possible to print parameters on a report datapage? I am using a submission form with virtual fields to filter my database and show the results on a report datapage. Here is a sample of my database. Each record contains these fields Field 1: Store Field 2: Catgory Field 3: State Some of the stores are represented in multiple states and rather than create a record for each store in each state I would like make 1 record for each store and enter each state, separated by commas, into the state field. I then search for each record that "contains" the state parameter requested on the submission form. So far this all works fine, but rather than display all of the information in the state field on my report datapage I just want to show the parameter used for the search. Any way to do this?
  13. I have 2 data pages. 1 is a submission form and the other is a results page. I am passing parameters from the submission form so that the results page finds the correct information from the database for display. My database records have several fields, but for the purpose of this question I will only use 3 of the fields. Field 1: Store Name Field 2: Category Field 3: State Some of the stores are located in multiple states. Many are in all 50 states. Rather than creating a separate record for each store/category/state I have put all states for that store name into the state field, with each separated by a comma. When I submit my search using a "contains" format I have no problem finding each record that I am searching for, but I don't want to display all of the text that can be found in the state field, I only want to display the parameter that was passed when I ran the search. Is there any way to display the parameter on my results page and not the actual text found in the state field?
×
×
  • Create New...