Jump to content


  • Content Count

  • Joined

  • Last visited

  1. Is it possible to use virtual fields as search criteria? I have a report datapage with an actual search field named "Client_ID". That field is "Hidden". I also have two virtual fields, each with a different multi-select listbox. The virtual fields are both labeled "Client ID" and the one that gets displayed for the user to select from depends on the contents of an auth field (using a rule). I want the selections from the virtual field that is displayed to be used as the actual "Client_ID" selections in the search. The code I currently have in the footer (that doesn't work) is: <script> function setSearch(){ if("[@authfield:Level#]" == 3){ document.getElementById("@field:Client_ID").value=document.getElementById("cbParamVirtual1").value; } else { document.getElementById("@field:Client_ID").value=document.getElementById("cbParamVirtual2").value; } } document.getElementById("caspioform").onsubmit = setSearch; </script> Is what I'm looking to do even possible? I know I can have a separate search form and report datapage but I would prefer not to do that if possible.
  2. I have a HTML datapage which is the user' s main menu to my app. Now I would like to test whether the user is restricted in it's use of the first of four menu items. I have the following code, but it returns "file or directory not found" when I preview it and choose the 1st menu item: <script> window.onload = testFormRes; function testFormRes() { var dynLink; if ("[@authfield:Restricted^]"=="yes"){ dynLink="https://c0ect240.caspio.com/dp.asp?AppKey=eeda30004146e1be17fe4f64a319"; } else{ dynLink="https://c0ect240.caspio.com/dp.asp?AppKey=eeda3000a155f226d27146b0ae20"; } } </script> <div id="menu-mobile"> <div id="row"> <h1><i>[@authfield:Cust_Name]</i></h1> <h2>Main Menu - Res</h2> </div> <div id="row"> <div id="mobileNavagtion"> <ul> <li><a href=("dynLink") class="btnPatrolForm">ActivityForm</a></li> <li><a href="https://c0ect240.caspio.com/dp.asp?AppKey=eeda3000a31708e7da464d9e9b63" class="btnPostOrders">Post Orders</a></li> <li><a href="https://c0ect240.caspio.com/dp.asp?AppKey=eeda3000d7e592f401a541d4b948" class="btnReportsMain">Reports</a></li> <li><a href="https://c0ect240.caspio.com/folderlogout" class="btnLogout" class="btnLogout">Logout</a></li> </ul> </div> </div> </div> As one can probably detect, I am a novice at coding, any help would be appreciated! Richard
  3. I have the same coordinates displaying on my Detail page. And that is only when I set the Signature field to display only. I have followed the instructions to a "T". The Caspio support people can't find any errors either. Are there any other steps that could be added to those already in this post?
  • Create New...