Search the Community

Hi, How can I pass multiple parameters using a Virtual field? Ideally I wish to use an Auto-submit script so I believe URL method wouldn't work. Multiple fields (values) will be cascaded automatically based on User ID when a button is clicked and submitted using an auto-submit script. On the other hand a report data-page will receive all parameters to filter results. Any thoughts or suggestions welcome. Thanks in advance

After following a couple of threads on the related topic, I still cannot figure this out... I have a report page that shows a chart that has the search above the chart. The search is just a listbox that allows multiple entries by holding control. I have the below script in my footer along with a Virtual Field (Virtual1) hidden that is passing parameter Virtual1. I have a second pie chart on the page below that takes the parameter from Virtual1 as CONTAINS. However, this pie chart will not work based on the script below. I believe the parameter is not passing at all, and I am not sure why. Does anyone see any issue? Here is my current website I am testing this out on: https://simionehhaclaims.weebly.com/dashboard-v2.html The pie chart should be pulling up below the bar/line combo chart but it will not work. <script type="text/javascript"> var fieldName = "Value1_1"; 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 " ; } } document.getElementById("cbParamVirtual1").value = result; } setTimeout(splitAndParse, 20); </script>

I have an problem that I cannot figure out how to solve. It's a bit complicated, but I think it may be unsolvable within Caspio. Anyone who can solve this gets a gold star because I have tried everything. I have a table of customers example (C1, C2, C3, ... Cn ) and a table of vendors (V1, V2, V3... Vn). Every customer can have deals from multiple vendors e.g.( Customer C1 can have deals from vendors V1, V3, V4, C2 can have deals with V2, V4, V5) etc. Vendors can have different deals with one or more customers, but only a single deal with a given customer. This yields a "deal table" view consisting of combos of vendors and customers IDs forming records that have all the instances of vendors for each customer e.g. (V1/C2, V1/C3, V2/C2) OK- Here's the problem. I want to create a table that shows "All customers I don't have a deal with" from the perspective of a vendor. I do a login which passes vendor ID, and I can only view records that are not equal to that vendor ID, but that will still show all other vendors that have deals with that customer. I want to basically eliminate a customer entirely from the view if that customer ID shows up in the vendor's deal table. I need to pass all the customer IDs in the vendor deal table somehow into the combined view table and do a big "not equal" to any of those customer IDs. This doesn't seem to be possible, or maybe requires javascript. The rules don't allow you to eliminate individual records based on the content of another table. Thanks in advance. Like I said, gold star if you figure this out.