Jump to content

Search the Community

Showing results for tags 'hidden value'.



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 2 results

  1. I'm trying to trigger a calculated field contingent on a select2 field or a hidden calculated field and I can't make it work. This is what I have: Field1(Cascading Dropdown Field for value: Field_ID) (converted into a select2 element using $('select[name="InsertRecordField1"]').select2();) VirtualField1 (Calculated Field) (Using the following sql SELECT Field_Name FROM Table WHERE [@field:Field1] = Field_ID) The SQL doesn't notice the changes made to Field1 nor its initial value on page load. I tried using JavaScript and SQL to give Field1's value to a another hidden Virtual Field and trigger the SQL with the following code: <script> document.getElementById('caspioNote').onmousemove = function() {myFunction();}; function myFunction() { var i = document.getElementsByName('InsertRecordField1')[0].value; document.getElementsByName('cbParamVirtual2')[0].value = i; } </script> ------ SQL for VirtualField1: SELECT Field_Name FROM Table WHERE [@cbParamVirtual2] = Field_ID The JavaScript works fine but the SQL does not seem to notice the changes in VirtualField2 This happens to other cascading fields too when I use VirtualField2 as the Parent Field. How could I archive this? Thanks in advance
  2. Hi, I have an update form that contains 2 hidden fields. Depending on the changes made in the form, the value of the hidden fields needs to change. One of the fields is a dropdown what controls placement on a report. I have added the following javascript to the footer. Any changes I make to the data are saved in the table, however, the hidden fields never change. Hopefully someone can spot the error in my code. Thanks, Bill <SCRIPT LANGUAGE="JavaScript"> function concatenate1() { var Sched.Status = document.getElementById("EditRecordStatus").value; var Control = document.getElementById("EditRecordID").value; var Company = document.getElementById("EditRecordCompany").value; var Company25 = Company.substring(0,25); var Position = document.getElementById("EditRecordPosition").value; var Date = document.getElementById("EditRecordDate_Open").value; var CompanyPosition = Control + ' - ' + Company + ' (' + Position + ')'; document.getElementById("EditRecordCompany_Position").value = CompanyPosition; if (Sched.Status == "Future Credit") { var DateControl = 'FC' + Date + ' - ' + Control + ' - ' + Company25; } else { var DateControl = Date + ' - ' + Control + ' - ' + Company25; } document.getElementById("EditRecordDate_Control").value = DateControl; } document.getElementById("caspioform").onsubmit=concatenate1; </SCRIPT>
×
×
  • Create New...