Virtual Fields and Calculations

[jpowell]

Can anyone confirm if it is or is not possible to perform a calculation on a virtual field?  For example, I have a Number Field that is set to Calculate based on a virtual field.  The Number Field equals [@cbparamvirtual3]/100

When I check verify, it accepts the calculation.  However, when I try to submit the form via the datapage, it throws an error that invalid data exists in a field.  If I remove the /100, it works fine.

Any thoughts here?

Thank you in advance

[Ulensr]

Hi @jpowell, you should try to ensure that the type you are using in your calculation is consistent.

 

You could try the following Cast([@cbparamvirtual3] AS int) / 100 or if you want digits, Cast([@cbparamvirtual3] AS float) / 100

 

Kind regards

[Ulensr]

Alternatively if you want to know the type of what you enter, you can use javascript.

 

Paste this in the footer (add header / footer if you don't have one) and make sure you disable the HTML editor in the advanced TAB but replace X with the number of your virtual field

When you then enter a value and click TAB for example it will popup and tell you the Type of this value

 

<script>

document.getElementById("cbParamVirtualx").onchange = function() {getType("cbParamVirtualx")};

function getType(field){
alert(typeof field);
}

</script>

 

Good luck

[cheonsa]

Just to add, for virtual fields/ parameters/ authentication fields, sometimes they need to be enclosed in single quotation marks. 

For example:

'[@cbParamVirtual1]'