Jump to content
  • 0

Virtual Fields and Calculations


jpowell
 Share

Question

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

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...