How can I copy a dropdown value?

[barrantj]

Hello all,

I'm new in caspio and I'm working in a new solution.

I have created a Submission form and I have a cascading dropdown. My problem is that I can't copy the content in the cascading dropdown...

Can anyone help me? please!

Thanks in advance.

[MayMusic]

You cannot copy a dropdown value generally but you can right a code to get the value and put it in a text field and then copy the value from there.

[barrantj]

Thanks for your replay... Can you show me how to do that?

[NaghmehK]

You can add a virtual field http://howto.caspio.com/datapages/form-elements/html-blocks.html to your page and get the value of the dropdown in that. To do so add an HTML block below these dropdown and virtual field in your submission page and paste this code in there:
 

<script>
function myValue(){
document.getElementById("cbParamVirtual1").value=document.getElementById("InsertRecordname").value;
}
document.getElementById("InsertRecordname").onchange=myValue;
</script>

You need to replace cbParamVirtual1 with the virtual field ID and InsertRecordname with your dropdown ID.

[jwinters]

I have been trying to get this to work, but I keep getting errors. I am trying to copy a Virtual field to a dropdown list. Any help would be appreciated.

<script> function myValue(){ document.getElementById("Part_Number").value=document.getElementById("Virtual1").value; } document.getElementById("Virtual1").onchange=myValue; </script> 

cbParamVirtual1 = Virtual1 InsertRecordname = Part_Number - This is the Dropdown List ID.

[MayMusic]

try this:

<script> function myValue(){ document.getElementById("InsertRecordPart_Number").value=document.getElementById("cbParamVirtual1").value; } document.getElementById("cbParamVirtual1").onchange=myValue; </script>

[ricksarris]

Hi, guys this is first time i am visiting this forum. Its glad to see such a great info posted here. So many things i came to know new by this forum.

[quinnygdn]

The JS code is not shown in this thread. Can anyone advise how I can see it - I am trying to solve a similar problem.

Thanks

[MayMusic]

It should be showing  now

[Kurumi]

Hi @barrantj,

As of July 12, 2018, Caspio introduced new features which you can find here: https://howto.caspio.com/release-notes/caspio-bridge-13-0/

This release includes a new feature, Calculated Values in Submission Forms.  This allows you to generate calculations which you can use to get the value of your dropdown. You can use Virtual field and set it as Calculated Value. In the formula section, insert the field name of your dropdown. 

 

For more information about Calculated Values, you can check these videos:

 

I hope this helps!

[NailDyanC]

Hi Just to add to the previous comment, you may also check this link about calculated value: https://howto.caspio.com/datapages/datapage-components/calculated-values/

*Just an update and FYI : You can now add the Calculated Value form element to Update Forms and Details Pages to generate dynamic calculations as users interact with your forms. Previously, this feature was only available in Submission Forms.