Jump to content

Search the Community

Showing results for tags 'javascript'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • 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


Last Updated

  • Start


Filter by number of...


  • Start




Website URL






  1. I want to create a JS if statement that updates a fields value based on another fields value. If the field Virtual2 does not equal "Don't Share" I want the field CON_1 to equal Virtual2 Here is what I used unsuccessfully in the footer of a details page in a tabular report data page... <SCRIPT LANGUAGE="JavaScript"> function con1() { var v2 = parseFloat(document.getElementById("InsertRecordVirtual2").value); if(v2="Don't Share") {} else {document.getElementById("InsertRecordCON_1").value = (v2);} } document.getElementById("caspioform").
  2. In a Single Record Update form I'm trying to update different fields based on the value of a Virtual field. The Virtual field is loading with and External Parameter (number value). Depending on what value that Parameter is I need a specific field to update/change on when the 'Update' button is clicked. I don't want all fields to update, just a single specific field based on the value of the Virtual field. For example: If Virtual1= 3 then update myField1="mytext" If Virtual1=4 then update myField2="mytext" If Virtual1=5 then update myField3="mytext" Here's some co
  3. Does anyone know any code for collapsing or expanding sections in a Pivot Table and a Tabular table? For example lets say that column 1 is 'Regions' and Column 2 is 'Countries'. The pivot table table is set up to show all regions and all countries expanded. I'd like to set up a button outside the results table to be able to collapse all countries, all in one go, to just show region totals, without having to go through each region individually. Many thanks in advance.
  4. Hi! I have multiple scripts for a submission page. When I execute the page I am only able to get one to work at a time. Not all three. I am not sure what I am doing wrong. Any help or advice would be appreciated. I have pasted the scripts below. I have all the scripts in the footer of the page. The first simply checks that the MOQ field is greater than the Inner Pack field. The second checks that cost is less than retail. They third, if the virtual check box is checked, it will copy the data from the Vendor VPN field to the Vendor Style field. <SCRIPT LANGUAGE="JavaScript
  5. 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 s
  6. I have a simple pivot table with 'Years' field across the top and a 'Regions' field and a 'Countries' field down the side. The regions field is collapsible, so the User has the choice whether or not to show the countries inside each region. So far so good. Problem is that In the regions column I want to be able to show selected regions with the collapsible option, but I also want to show (in the same column) other selected regions which do NOT have the collapsible option and therefore just show the aggregate total of their countries. I know this is not a regular option, so I'd
  7. Hi I notice whenever I use javascript within caspio datapage and do a preview, it seems to work. However when I save my datapage and have it deployed to my web environment, the script does not work at all. Anyone know why and how I can fix this? Thanks in advance.
  8. I'm trying to use an if statement in js that references a data field to see if there's a null value. I can't get the syntax to work though. Here's the code in the footer of a Details datapage: <script> var v_lk = parseFloat(document.getElementById("EditRecordmstrSuppliers_LinkedIn").value); if(!(v_lk) === "") { document.getElementById('section3').style.display = "inline"; document.getElementById('section4').style.display = "none"; } else { document.getElementById('section3').style.display = "none"; document.getElementById('section4').style.display = "inline"; } <
  9. In an html block on a Details datapage, I'm trying to show buttons with hyperlinks to social media pages using font awesome icons. The issue, though, is I need to show/hide these font awesome icons based on whether the datafield used for the url is null/blank or not. Basically, if the user has not entered a url link in the 'Facebook' field then I need to hide the Facebook font-awesome/hyperlink (because there is no url for Facebook for that record). I just want to show the social media links that have actual urls and hide those that don't. Here's the code to a couple of those hyper
  10. Hi Hope someone can help me out here with my javascript problem. I have a submission form (which is multi-step form, 2nd page of a form which is now a update form) which is collecting information like project type, project name, description. It is cascading from project type -> project name -> description Because I can't do a cascading text area for "description". I have created a virtual text field for this value hoping to copy this into the "description" text area. I am having no luck with javscript which I have modify from what i found on this forum. Ca
  11. Hi I am stuck with javascript doing multiple calculations in same datapage. 1st javascript is calculation of unit cost, no of units and total (in local currency) 2nd javascript is convert local unit cost to USD based on cascading dropdown field 3rd javascript is using unit cost (in USD), no of units to derive total cost (in USD) the 1st javascript seems to be working. But when I add on 2nd javascript, only one value shows and in the wrong field. There is also no error appearing in the web console. Eg javascript 1 calculation
  12. Hello, I have a search and report datapage where I have added an HTML block in the results section which has an iFrame element inside of it. I am trying to accomplish this: User processes a search, results are shown where some results will equal saved results from another table. So table (A) produces results that I want to cross-check to table (B). If there is a match based on an ID field in both tables (A+B), I want the iFrame element to show basic data (timestamp & user name). I was successful in doing this part... Here is where I am having problems.... If table (B) d
  13. Hi All, I'm new to the forum and Caspio. So I'm still on a journey of discovery and therein I have encountered a challenge. I'm looking for help in developing a javascript that returns an html symbol in the results page depending on the time that has lapsed from Date1. The idea is that the html symbol keeps changing color based on how much time has lapsed. The field only resets when there's status update. Below I have html symbol I was hoping would fullfil this objective... <h1><span style="color: #99cc00;">✪</span></h1> <h1><
  14. I use the below code in my caspio datapage under emails & destination as suggested by in the forum. It was working like a charm but suddenly now it does not work anymore. anyone can help with new code or why it is not working? <script> window.close(); window.onunload = function(){ window.opener.location.reload();} </script>
  15. <script type="text/javascript"> document.onkeydown = function () { sysend.broadcast(); }; var audio1 = document.getElementById("player"); window.addEventListener("keydown", playPauseKb, false); alert(audio1.id); //document.getElementById("audio1").onkeypress = function () { document.getElementById("audio1.id").onkeydown = function playPauseKb(event) { var x = event.keyCode; console.log(x); if (x == 113) { audio.currentTime -= 5;//F9 Rewined }
  16. I am using Laravel as backend and bootstrap as frontend I am using transaction ID from orders in table. Now if user clicks on that transaction ID, then I want to display the order on Bootstrap Modal... Here is code of Frontend : <table id="example" class="table table-striped table-bordered " cellspacing="0" width="100%"> <thead> <tr class="bg-info"> <th><center>Transaction ID </center></th> <th><center>Shop Name </center></th> <th><center>Sales Man
  17. I am trying to format multiple fields on a page. The first is the phone number, which I found the JavaScript for on the JavaScript forum. My issue is that I need to format phone number, social, and a tax-ID on one page and I am unsure how to accomplish this task. For phone number I am using the script below, plus I found another for formatting a social on StackExchange, but my JavaScript reading/writing skills are sub-par and I did not combine these correctly. Then I want to add in the option to format the tax ID as well, which is ##-####### (2 digits, dash, 7 digits). <SCRIPT LANGUAG
  18. Can someone help with this javascript please...I'm using a submission form and one of the fields in the calculation is a cascading dropdown with a parent of Merchandise_ID and the other is a text input field. Not sure why its not working, but nothing is showing up in the destination field. <strong><span style="color:#000000;"></span></strong> <strong><span style="color:#000000;"> <div id="mypage1"> </div> <SCRIPT LANGUAGE="JavaScript"> function calculate() { var Gross_Qty_Sold = isNaN((parseFloat(document.g
  19. Hi, With the responsive gallery code ( on mobile), the results are confined to being separated by <tr>'s (or in some cases colspan="2") meaning that a field label can't be followed by it's value on the same line. I'm wondering if I hide the field label can I append the field label to the value using javascript? For instance: (as it exists) Booth # 34 For instance: (as I'm trying to do) Booth # 34 <---- ("Booth #" label hidden in datapage but appended to beginning of value through code) Never mind! I figured it out No JS needed!
  20. Hi everyone, I'm fairly new to the world of JavaScript and have the following scenario on a submission page: During submission, my users select a business client using an AutoComplete field. Once they selected a client, two virtual fields pull two values for this client from an external table. These lookups are set up using cascading text field. On the same DataPage, there is a radio button with two options. Should the two virtual fields remain blank (basically meaning that there is no value for either of the fields for this client in the external table), the 2nd radio button option
  21. Hello. I would like to concatenate two text fields (both foreign keys) and populate a third text field in the same table with the concatenated value when submitting a DataPage. I understand how to do this when I am concatenating the stored value of the fields, but I would like to concatenate the display values of the two lookup fields, not their stored values. Please advise.
  22. So this is something that has been addressed a couple of different times but not of the Javascript solutions work for me. I have an update page that has 3 listboxes with multi-select enabled. I need the update page to display the multiple selections in the listbox separately and not in one long sentence separated by commas. Here are two of the different scripts I have tried to use, neither has worked. First: <script> // Function for selecting corresponding elements from the list box. function select_ (){ // get listbox element var o_els = new Array("EditRecordSt
  23. I have a datapage submission form which I need to make a counter based on an external parameter. Virtual2 receives an external parameter (authorization field) on loading. This works fine. Goods is a hidden field in the datapage. An updated value should be saved in this field on submission. The script goes like below, but it doesn’t work. Actually I cant get goods to receive and store any value. Please advise on solutions. <SCRIPT LANGUAGE="JavaScript"> Function calculate() { var number = parsefloat(document.getElementsByName('cbP
  24. We have a number of processes which were originally built to update single records and used javascript to test for certain conditions and post values into fields dependiong upon the results. As an example, if an agent clicks the JS button to mark a job as compete, the script caclulates the current time plus 10 minutes and posts that to a field. When looking at the "live" situation on screen, the controller screen filters for jobs that are either no marked as complete, or where the Completed Time + 10 mins field value is after no (i.e. a job will be shown if completed within the last 9 mi
  25. <script type="text/javascript"> function calculate(){ var pm1 = document.getElementById("cbParamVirtual3").value; var pm2 = document.getElementById("cbParamVirtual8").value; var pm3 = document.getElementById("cbParamVirtual13").value; var pm4 = document.getElementById("cbParamVirtual18").value; var pm5 = document.getElementById("cbParamVirtual23").value; var pm6 = document.getElementById("cbParamVirtual28").value; document.getElementById("EditRecordTotal").value = pm1 + pm2 + pm3 + pm4 + pm5 + pm6; } document.getElementById("Mod0EditRecord").onmouseover=calculate(); </script>
  • Create New...