Jump to content


  • Posts

  • Joined

  • Last visited

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

DAG4Debt's Achievements


Newbie (1/14)



  1. Do you have the documentation for this. I can't find it on the Caspio site and need to create a datapage to delete a field in a table based on a view
  2. I am embedding my datapages in iframes on my site, but I keep getting this error message in Firefox: error:Permission denied to access property 'document'. I tried changing the SSL option from https to http but the error persists. Can I do anything on Caspio to make this work? What's the problem with accessing my datapage from my website?
  3. I have a function that I'm trying to implement when my datapagse opens in an iframe. The function reguries the event in lieu of in the child page (i.e. my Caspio datapage). I've tried adding it in HTML Blocks, but I'm not sure that's the best way to change the tag in Caspio. In any event, it's not working properly and I suspect this is the source of the problem because it doesn't always load (but it does sometimes). Is it ok to add this to the top of a datapage in an HTML block like I've done?? Is the functionality of this affected at all with Caspio? (since we don't have any access to or tags)
  4. Barbara, Thank you so much!! That worked perfectly. It took me a while to realize you changed the cbParamVirtual1 value from cleanRsult to result after I changed the fieldName to VIrtual 10_1, but it workes splendidly now! Love you!
  5. Three total. The first is the search and report page. It is on that page the user selects initial filtering criteria and the report is generated. The parameters are passed to page 2. Page 2 is details page for links checked from page 1. The parameters from page 2 to page 3. All parameters for the filtering criteria pass fine except the parameters that I need to parse for the multi-celect: Location_City. Page 3 is a report/table datapage with criteria selected for the report from the parameters transferred from page 1. Like I said everything works fine except that "OR" field for the multi-select which appears to be passing either blank or empty.
  6. Yes and no. I am using a search and report page for an initial result table. I am passing the search parameters to a new table and then returning them to another results table so the user doesn't have to repeat entering search criteria. The parameters are generated from a search and report datapage. I have used the code provided and modified it, but I can't get it to work. I am using InsertRecord instead of cbParamVirtualX for the field name because it is generated from a search/report datapage. I also have a hidden virtual field for cbParamVirtual1 which is where the new "OR" results are supposed to go. That variable, however, passes as blank. I am wracking my brain here. The Location_City field is the one that needs to be parsed with names separated with "OR". It is from a cascading listbox. Here is my code: var fieldName = "InsertRecordLocation_City"; var x1=document.getElementsByName(fieldName); x1[0].multiple=true; function splitAndParse() { var result = ""; var cleanResult = ""; for (var i = 0; i < x1[0].length; i++) { if (x1[0].options.selected) { result += "\""+x1[0].options.value+"\"" + " OR " ; } } if (x1[0].length > 4) { cleanResult = result.substring(0,(result.length-4)); } document.getElementById("cbParamVirtual1").value = cleanResult; } document.getElementById("caspioform").onsubmit=splitAndParse;
  7. I was trying that, but can't get it to work. Are you saying that the values do not include "||cb||" but a comma instead? I was trying to use the replace function (i.e. [@Field].replace=? but that wasn't working. DO you have some sample code to change the values in the table to include the OR statement instead of "," or "||cb||"? Here is my code: v_Virtual_City=[@Virtual_City].replace(/,/g," OR "); document.write(v_Virtual_City); The document.write line is just to test, but the "," is not replaced. I also tried "||cb||" but that's not replaced either.
  8. I have configured a search form that allows for multi-select listboxes. I'd like to pass them and run a query from a table. The parameters pass fine, but they look like this (two cities selected from the multi-select): "Chula Vista||cb||El Cajon". When I try to use this Virtual parameter as a data field using pre-defined criteria for a tabular report, no records are displayed. The report should generate all matching records for the two cities, Chula Vista AND El Cajon. How can I pass parameters using the multi-select variable (let's call it Virtual1) and run those parameters successfully against the data fields? By the way, I tried changing the comparison type to "contains", but no go. Please help.
  9. I have transitioned my entire site to Wordpress, but I cannot seem to transfer any paramters through the URL from one page to the other. I am using the following code: onclick='window.open("http://URL/?GUID=[@field:GUID#]","_self",false The page direction and everything work fine, but the URL for Wordpress shows a blank field for the GUID even though I've confirmed that the GUID is entered in the underlying table. The URL for the new page then displays: http://URL/?GUID= The GUID is completely blank. The GUID is an auto assigned, Random Unique ID, Application Use only value. Is this a function of Wordpress, Caspio, or am I doing something wrong? Please help. I have numerous forms that need the same functionality so this is crucial.
  10. I have to do this manually for every embedded code. Is there a way to have it removed automatically before deployment?
  11. Please can someone respond to this. This is an imperative. I find it disconcerting that every tutorial, help, or support function I've read demands that these kinds of parameters can only be passed through a query string, but then the response from Caspio support is "why am I doing it that way?" If there is a way to pass parameters through the bridge from an HTML block, that'll work, but I need a response or an alternative to encrypt or pass data securely. I also will implement https, but my understanding is that only encrypts the data during transmission from the browser to the server, but the URL query string is still visible in the toolbar on the user's browser which still needs to be avoided. The data is extremely confidential. Thoughts please ????
  12. I need a small table that essentially summarizes detail from a View. All I need to do is count the number of fields in a table with particular values and display them in a table summary. For example, X number of records with Y value in one field, Z number of records with A value from a different field in the same table. It seems that this should be such an easy task, but its a tremendous feat and I can't figure it out. I've tried Totals and Aggregates, but I don't need all the detail, and even when modifying the style to eliminate some rows, it still doesn't do what I need it to do. Similarly, I've tried working with java to pull and calculate the data in an HTML block, but can't et this to work either. Here's what I need: Value A Value B Value C Field X Count A Count B Count C Field Y Count A Count B Count C Field Z Count A Count B Count C There has to be an easier way to manipulate the data in Caspio. Please let me know. Thanks.
  13. Additionally, I have conditional statements written in java that direct the user to pages depending on the parameters on selected records. I cannot seem to pass these blindly through Caspio bridge
  14. The problem with this is the parameter then displays for all the world to see in the URL. I have the same issue/problem, and need to transfer the parameter silently to the popup. I'd like to either (1) use Caspio bridge to pass the parameter, or (2) encrypt the parameter in the URL. Any help is appreciated.
  • Create New...