Jump to content

Search the Community

Showing results for tags 'parameters'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Caspio Bridge
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


MSN


Website URL


ICQ


Yahoo


Skype


Location


Interests

Found 64 results

  1. 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>
  2. I have a DataPage that I am embedding in a Joomla article. I use Joomla ACLs, so I am not using Caspio's authentication. But I still want to get the user's Name and ID (from Joomla) to load into the Caspio database to track who created/updated the records. I uses a PHP snippet of code to get the user's information and put it into a variable. This works because I can echo it to the screen. I then want to pass the variable to the Caspio DataPage by modifying the embed code generated for the DataPage as follows: As generated by Caspio: <script type="text/javascript" src="https://c1abs817.caspio.com/dp/ec1d70004e69797b8ed24ca4ade4/emb"></script> <div class="cxkg"><a href="https://c1abs817.caspio.com/dp/ec1d70004e69797b8ed24ca4ade4">Click here</a> to load this Caspio <a href="http://www.caspio.com" target="_blank" title="Cloud Database">Cloud Database</a></div> <div id="cbec1d70004e69797b8ed24ca4ade4"><a href="https://www.caspio.com" target="_blank">Cloud Database</a> by Caspio</div> As modified by me: <script type="text/javascript" src="https://c1abs817.caspio.com/dp/ec1d70004e69797b8ed24ca4ade4/emb?joomuser=<?php echo $username; ?>"></script> <div class="cxkg"><a href="https://c1abs817.caspio.com/dp/ec1d70004e69797b8ed24ca4ade4?joomuser=<?php echo $username; ?>">Click here</a> to load this Caspio <a href="http://www.caspio.com" target="_blank" title="Cloud Database">Cloud Database</a></div> <div id="cbec1d70004e69797b8ed24ca4ade4><a href="https://www.caspio.com" target="_blank">Cloud Database</a> by Caspio</div> Notice that I have put my modification " ?joomuser=<?php echo $username; ?>" into the script in two places. Not really sure if it's needed in both places, but not knowing, I put it in both. When I press the SUBMIT button on the DataPage, the record ( a transaction header record) is written to the database and then a details DataPage is loaded. The record is written as expected and the 2nd DataPage is presented, but when I check the record written, the user name from JOOMUSER is not recorded. Here is a screenshot of how I have the field set up on the datapage: Clearly, I am doing something wrong or missing a step. Any help would be greatly appreciated.
  3. I have a Submit form where I select a client account in a dropdown and it displays the account info in fields below via cascading auto complete. Instead of using a dropdown and fields, can I instead load/display the table data (account info) in an HTML block using parameters? or any other way?
  4. 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?
  5. I have ticketing application, which is spread over many datapages (50+). Out of a userbase of 20, I have 5 users that don't need to see the full app, but only a 'limited' version. I think this could be achieved if I pass a parameter through the login authentication page, which would be received by any subsequent datapages the users visit(and then add conditional logic on each datapage to hide whatever needs to be hidden, if a specific parameter is received). My issue is the standard Caspio interface can only pass the login information (e.g. Email) as a parameter through the authentication page - e.g. [@testpar]? <script> document.addEventListener('BeforeFormSubmit', function (event) { var comparevar = document.getElementById("xip_Email").value; if (comparevar === 'user1email@test.com') { //pass [@testpar] = 'limitedView' } }); </script>
  6. Hello. I have a submission form with a popup link. The form has a Job dropdown element that is being used as a parameter to pass to the popup. When a Job is selected from the dropdown and the popup link is clicked, a List Report pops up and shows records related to the Job that was selected. This works great. However, I need an element in the form to be cascading, and the Job dropdown has to be the parent field for this. When I enable the cascading feature, my popup stops working. I get an Uncaught TypeError of null, stating that the parameter field name cannot be found. So, Job can be found before it is made a parent field for a cascading element, but once it is made the parent field, it stops working. Here is my code. <script> var fieldName = "Job"; // The name of your table field. var paramName = "Job"; // The name of your parameter /* No modifications necessary beyond this line */ var inputField = document.querySelector('[action*="[@cbAppKey]"] #InsertRecord' + fieldName); var linkToChild = document.querySelector('[action*="[@cbAppKey]"] #linkToChild'); var baseUrl = linkToChild.href; //do not touch var moddedUrl = baseUrl; //do not touch function updateLink() { moddedUrl = `${baseUrl}?${paramName}=${this.value}` } ['change', 'keydown','keyup'].forEach( function(e) { inputField.addEventListener(e, updateLink); }); inputField.dispatchEvent(new Event('change')); linkToChild.onclick = function() { window.open(moddedUrl, '', 'resizable=no,status=no,location=no,toolbar=no,menubar=no,fullscreen=no,scrollbars=no,dependent=no'); return false; } </script> Any help would be appreciated. This is maddening me, haha.
  7. Hello All I'm trying to integrate a QR code generator in my Caspio data page. It works easily enough when using a simple URL, but I don't know how to include Query strings. As an example, if I use https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=http://website.com then it works fine. If I try and include query strings at the end though, for example- https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=http://website.com&name=fred&email=fred@aol.com it doesn't work. I've tried encoding the URL, but that doesn't work either. Any help would be very gratefully received. Thanks Duncan
  8. Hi, I am using a script in an html block to detect certain criteria and display something based on that criteria. Here is my script: <script> var status = "[@field:Account_status]"; function invitepopup() { window.open("https://c3fot467.caspio.com/dp.asp?AppKey=34fe4000f38aceb2a5da4c74bea2&UserID=[@field:User_ID]", "Invite", "menubar=1,resizable=1,width=500,height=500"); } if (status === "Yes") { document.write("Active"); } else { document.write('<a href="#" onclick="invitepopup()" title="Click to invite again">Invited by [@field:OriginUserName]</a>'); } </script> The if/else works fine, it shows "Active" for all the active users and "Click to invite again" for all the invitees ... however the link doesn't send the parameter properly. https://c3fot467.caspio.com/dp.asp?AppKey=34fe4000f38aceb2a5da4c74bea2&UserID=[@field:User_ID] is passed with the wrong User_ID. It seems to be passing the ID of the last user in the table, rather than the ID of the row it is in - it's currently showing 3 invitees in my table and they all are being received by the popup with the same ID (last user in the table). However if I just put this in as a plain (<a href="https://c3fot467.caspio.com/dp.asp?AppKey=34fe4000f38aceb2a5da4c74bea2&UserID=[@field:User_ID]" title="Click to invite again">Invited by [@field:OriginUserName]</a>), it works completely fine! Is there something in the script which is removing or replacing the User ID? I'm completely stumped! Hope someone can help! Many thanks Nikki
  9. I would like to set up the filter logic to combine And with Or logic but I can't find the any documentation on how top do this. I have something like Cond-A And Cond-B And (Cond-C Or Cond-D Or Cond-E). This is probably an uncommon situation. I would appreciate any guidance on this. I tried doing it as shown below but I got a message that says"Incorrect logic" and that some logic elements are not configure correctly after I clicked the Next button
  10. Hello, I am building a Login/Registration/Password-reset database and authentication system with Caspio and am trying to integrate it into an existing PHP based web page. My web page is highly customized ecommerce site that has specialiazed B2B purchase order type system without any login. I want to expand into offering online credit card payments and paypal but I require a customer account system to authenticate and save customer data and provide my FoxyCart with shipping and bulk pricing for individual customers. 1. Is this possible with Caspio? After building a login system I can't see where or how I can pass Authentitcation data through to my order system. 2. How can I update my current php database with newly (caspio) registered users? 3. Is there a webhook or API to assist in this?
  11. Hi, i am deploying my pages using the URL and I need to clear the parameters, how can i add ?cbResetParam=1 to the page URL
  12. I also posted this in User JavaScript and CSS Discussions because I'm not sure whether custom script was required to achieve this result. I have a submission form DataPage with a multi-select listbox field. I would like the values the user selects in that field to be passed into the notification email. Currently, only numbers representing the values display. This is the parameter in the email: Profession : [@field:Profession] This is what it displays in the notification email: Profession : 4,5,6,53 I would like it to display this: Profession : Accountant, Actor, Agent/Manager, Artist Is this possible? Thank you.
  13. I would appreciate any help you can provide on the following: I this java script on an input form where the parameter [@SU_Type] is passed into the page through a link. THIS SCRIPT WORKS perfectly: <h5><span id="business2" style="color:#263C87;">Company Information:</span></h5> <script> TypeC=[@SU_Type] if(TypeC == 1) {document.getElementById("business2").style.display = "none"} </script> THE PROBLEM: I'm trying to do something very similar on the email/destinations page of another form and it is NOT working. In this form the parameters [@Mailing_Addr_Type] and [@Mailing_Check] are being used in the form and should then be passed, which I am assuming makes them available for use on the Destinations page. However, no matter how I format them in the Jave on the Destinations page of the form the Java does not seem to read the values. I have tested the java itself on other sites and it works if a Value is assigned to md directly. What am I missing? This is my latest iteration, treating the variables as values on the same form as the Java. It does not work. I have tried the following parameter formats: [@field:Mailing_Addr_Type] (with and without the # at the end) [@Mailing_Addr_Type] Thanks for taking the time to look at this. CODE THAT IS NOT WORKING (with fake link info): <h4>Your submission was successful.</h4> <p id="answ3">If you wish to enter additional addresses:</p> <p id="answ2">It appears that the address you entered was not a mailing address (or was not marked as one). Please click the link below and enter a mailing address that can be used in the letter of authorization document. This is required by the utility, not us. Thank you.</p> <button onclick="location.href='https://www.GOOGLE.COM/'" type="button">Add another address</button> <p><span id="answ1">Or, if you are done entering addresses: </span></p> <span id="answ4"><button onclick="location.href='https://www.GOOGLE.COM/'" type="button">Proceed to the Letter of Agreement</button></span><br /> <br /> <script> A=document.getElementById("InsertRecordMailing_Addr_Type").value; B=document.getElementById("InsertRecordMailing_Check").value; md=A+B if(md==0) { document.getElementById("answ1").style.display="none"; document.getElementById("answ3").style.display="none"; document.getElementById("answ4").style.display="none"; } else { document.getElementById("answ2").style.display="none"; document.getElementById("InsertRecordMailing_Check").value=1; } </script>
  14. Hello, I'm tying to improve my app's error messages using Localizations. I see on some error messages there are variables or parameters that provide the user with some very valuable information. Value cannot be shorter than %s characters. Value cannot be larger than %n characters. Are you sure you want to delete %n records. %p authorization failed. Cannot redirect to %p etc. Does anybody know how to use these, or where I can find a list of the variables we can use and how to? Thanks and ThinkEZ
  15. I have a submission form DataPage with a multi-select listbox field. I would like the values the user selects in that field to be passed into the notification email. Currently, only numbers representing the values display. This is the parameter in the email: Profession : [@field:Profession] This is what it displays in the notification email: Profession : 4,5,6,53 I would like it to display this: Profession : Accountant, Actor, Agent/Manager, Artist Is this possible? Thank you.
  16. I am trying to filter datapages that are embedded within a page that I show within an iframe and I can not seem to get the parameters to pass into the I-Frame when the parent page is loaded. I have a "Project" report with custom link to details page. This link passes Project_ID fine to datapages actually embedded on the target page. What I want to do is embed other pages (hosted on same domain) via IFrame and have the results of datapages embedded on the page shown in iframe filtered by the Project_ID. I want to use I frames to reduce load time, data usage and also have the ability to refresh specific datapages when editing data. Again, the parent page that hosts the Iframe is receiving the parameter fine, i just can not get the DPs within the embedded page to see the passed parameter. Much help in advance!
  17. Hi Guys my parameters seem to be stuck, even using reset doesn't seem to work, these are all in the preview mode, it used to work great. Now it's like it only remembers the last result, YES I did the reset thing, but nothing worked. Once I click once on the link, the one I click on those results keep showing up doesn't matter if I click afterwards on another link it will show me the results of the first time I clicked. Please help!
  18. I have a report that has a calculated field in it that is based on a conditional statement. For one of the options, I would like it to multiply a field by the value of an input box. I can't figure out how to do it though. I've tried passing the value as an external parameter in the URL but I can't figure out how to reference that in the calculated field formula. Right now the input field is on the web page that the Caspio iframe is embedded on, but I can also move the input to the header of the form if that would help. Is there a way to do this? I'm using the code below... CASE WHEN [@field:Per]='lamp' THEN [@field:Per] * 2 WHEN [@field:Per]='fixture' THEN [@field:Cost] * EXTERNALPARAMETER ELSE 0 END
  19. Morning, I'm trying to use cbResetParam=1 on the end of my webpage URL to reset internal parameters, and normally this works fine But this time I'm giving the instruction from inside my search form which is in an iframe, and nothing's working. Should I be applying 'cbResetParam=1' to the webpage URL, or to the scr URL (as I've tried to do below)? At the moment I've put the following code in an HTML block of my search form and run it off a button. <script> function myResetFunction() { document.getElementById('https://c2ect538.caspio.com/dp.asp?AppKey=b8a94000367dd...').src += '&cbResetParam=1'; } </script> Many thanks for any help...
  20. Hello! I am trying to deploy a tabular report data page filtered by an external parameter on my wordpress webpage. I have downloaded the caspio plugin for wordpress, and I have had success embedding data pages in code blocks on "normal" wordpress pages built with the GUI web builder. However, the webpage I am modifying in this case is a custom .php file that is edited under Appearance->Editor in an Avada theme (I'm not sure exactly how to explain this). My report appears on this page if I use an iframe, however, this method prevents me from receiving parameters. Does anyone have advice for embedding a data page for wordpress directly into a customized wordpress file? I have tried the following and nothing showed up on the page: <?php do_shortcode('[caspio method="embed" subdomain="true" url="URL" appkey="APPKEY"]'); ?> I also tried the following, which appeared as text on my page [caspio method="embed" subdomain="true" url="URL" appkey="APPKEY"] Thanks in advance for your help!
  21. Hello, I don't know if it's Wordpress issue but for some reason, whenever I deploy a datapage in iFrame, both wordpress code and html code, it wont receive any parameters however when using different deployment, it's working fine. Currently I deployed the datapage using the other means but I'd prefer using iFrame on some instances. Thank you.
  22. Hello, I have created a search data page similar to the example shown in http://howto.caspio.com/tech-tips-and-articles/parameters/add-a-search-interface-to-results-sets-page/ The search works fine the first time around (sometimes on a clean page load), but if you search again the search and appsession parameter from the previous search are still shown cached in the browser. Manually deleting these from the browser URL Bar allows for a successful search. From within the search form, I tried setting the destination to the same page and used the same search page url (http://www.mydomain.com/searchpage.html?cbResetParam=1). But apparently this clears the search parameter before the results data page can receive them. My question is where do I insert the cbResetParam=1 reset parameter to reset the browser cache when a new search is submitted from the submission form? I am guessing it could be reset "onclick" using js in the footer, but alas I am still learning js and could not find any examples to get started on Thank you in advance for any help on this.
  23. Hello, I have been working on this issue for weeks now and I have even contacted Caspio and scheduled two expert sessions and the issue has not been resolved. I am trying to limit the number of people who can sign up for a training on our website. So if the limit for a training is 15, after the 15th person signs up, I want that training to close and people to no longer be able to sign up for it. I was directed to this url http://howto.caspio.com/tech-tips-and-articles/advanced-customizations/how-to-limit-the-number-of-submissions/. I have set up all this to the best of my ability. My problem is that when my submission form is redirected to my single update form, there is a blank webpage. So to our individuals who are signing up, it could almost appear that they didn't sign up. I have tried everything and I'm thinking it could have something to do with parameters? It is set up that you have to have authentication, it is set up with a unique ID, which is eventid, and I did have it where <div style="display:none;"> this html was in the header. Once I took this away, it displays no records found. I have the header saying Thank you for registering, but no records found is displayed underneath that sentence. I have no clue what to do and I am stuck. I've attached what the the page with no records found looks like. Please help!
  24. Hi, My current code is: <SCRIPT LANGUAGE="JavaScript"> function update() { var p2 = document.getElementById("cpParamVirtual10").value; document.getElementByName("cpParamVirtual4")[0].value=p2; } document.getElementByID('caspioform').onload=update; <SCRIPT> and I have it deployed in the footer of a submission form however it is not working. Virtual10 is a hidden field that loads with a passed parameter . Virtual4 is a cascading dropdown ( and on exit passed the parameter that virtual10 loads). I want to set the cascading dropdown to the value it was when the form was submitted the last time instead of resetting itself every time. Thanks for the help.
  25. Hi I am new to using Caspio and would appreciate some help building a form and report which searches across 4 language database entries (L1-L4). I need 9 language search boxes in 3 columns (this will be expanded later to allow more parameters). The logical connection between each of the four boxes in each column vertically is AND and the relation between the 3 columns horizontally is OR. For example, to find people in the database who speak English and German and/or Spanish (and any combination of these), would look like on the search form: English English English AND AND AND Spanish OR Spanish OR German AND AND AND German [no selection] [no selection] I have built the form datapage using virtual fields to try to pass on to the report but I am struggling at this point. I can see that it is easy to have one search box searching records in L1-L4 using virtual fields, but not multiple search boxes searching multiple records in L1-L4. I have already looked at the various tutorials and guides on the caspio site but I cannot work this out. My general query is: is this possible? My more specific question is: is it possible to pass parameters from more than one virtual field to the report? More particularly, if, as in the case above, I have made no selection, can Caspio be told to ignore those fields for the purposes of the search? Many thanks for your help Toby
×
×
  • Create New...