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

Found 60 results

  1. 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
  2. Parameters Reset

    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
  3. 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
  4. 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>
  5. 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?
  6. Localization Variables

    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
  7. 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.
  8. 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.
  9. Parameters seem to be stuck

    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!
  10. 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
  11. 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!
  12. iFrame Parameters

    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.
  13. 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.
  14. Display table data in HTML Block

    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?
  15. 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!
  16. HI, I want to use a var. (variable) as a parameter value. Something like this: <script> var myTotalcont = parseFloat(myCells[column_number].innerHTML); if (myTotalcont>="[@field:GEBRUIKERS_Aantal_paarden]") { window.location = "[@app:Overzicht_paarden_klanten_accounts]?cont=myTotalcont"; } </script> How to work a round. in the window.location.
  17. Hi everyone, I pass parameters in query string from one datapage in another. There is a problem with passing + in the phone field. The + always replaces with white space. I found this topic: http://stackoverflow.com/questions/1005676/urls-and-plus-signs It seems that I need to use java script code to fix this issue. Can anyone help? Thanks!
  18. Parameter transfer

    I am very new to Caspio, I am having trouble figuring the best way to link 2 different databases. One is a list of applications and info of the person and the other is the info I enter if I hire them. My solution was a button on the application from the first database that opens up the second application and passes parameters of record number, name, email, and phone. Problem: If the employee changes their phone number and I enter it into the second data base the next time I open the second with the first it re-passes the parameter and overwrites the new phone number. Ideas?
  19. Facebook and Unique ID

    I followed the Facebook like button tutorial found here http://howto.caspio.com/tech-tips-and-articles/social-media/add-a-facebook-like-button-to-your-datapage/, but when the like button is pressed it links back to my site with the correct external parameter in the URL string but it's not going directly to the details page for that item. Need to figure this out. Thanks.
  20. I have 2 tables for T-shirts:1 - purchases2 - InventoryI'm trying to submit a purchase through a submission for that gets listed in the purchases table (this part is easy), but then I need the inventory table to add the value purchased for that item to the current value in the table for that item to create a new value for that item that includes what was purchased already & what has just been purchased. I've been thinking on this for a while and can't seem to understand how to pass the parameter to two spots + have the 2nd spot get this parameter added to its current value. The purchases table will log purchases per item per date purchased while the inventory table will have quantities per item with only one record per item. I'm thinking that I need to have some javascript that tells the inventory table to "get" the new purchases and "add to" the current value. Any suggestions here?
  21. UploadFile (3.3.28) - REVISION

    After working with Caspio Support I recommend the following change be made to the SOAP API "handbook". In section 3.3.28 UploadFile the VB example incorrectly states the final command with parentheses. It currently reads: aobjWS.UploadFile(strAccountID, strProfileName, strPassword, "file.txt", fileContent, "text/plain", -1, false) It should instead read: aobjWS.UploadFile strAccountID, strProfileName, strPassword, "file.txt", fileContent, "text/plain", -1, false I believe the handbook should be revised accordingly.
  22. I have a single record update form deployed on my webpage which contains an iframe inside an html block on the parent page. This iframe collects a signature. I need help getting the signature to pass to the parent page once the iframe has been submitted. How can I pass a parameter from an iframe to the parent page it is deployed in?
  23. Hello, I tried to apply the examples from other post but not sure if applies, so I will try if somebody can help me to address the problem. have a table of where one of the field is a "number". I can insert a new line on the top of the table, but I want that the value of the "number" field of the new line is automatically filled with the MAX+1 value of all the others number in the result table. I already have the aggregate with MAX+1 and I would like to pass this value in the hidden "number" field. Thanks for the help Bye, Sergio
  24. I have a datapage where I need to reset some of the parameters to 0, but not all of them. How can I add a button/link that will reset certain parameter values to 0 and reload the page to show the changes? Here's what I'm trying but is not working... I have 2 parameters and need a button to reset each respective parameter, so I inserted an HTML Block with the following link: <div id="cxkg"><a href="MyDataPageLink&Parameter1=0">Delete</a></div> this reloads the page with the field cleared, however when I try to erase the second parameter with: <div id="cxkg"><a href="MyDataPageLink&Parameter2=0">Delete</a></div> the page reloads, the 2nd parameter is gone but the 1st is back to what it was before... Is this because the parameter is not saving? or is it some sort of auto-fill issue... Please help! Thanks!
  25. Receive parameters in iframe

    I have a submission form where I've deployed an update form in the html block. The Update form were deployed using the iframe deployment. How can I receive parameters in iframe? Thanks
×