Skip to main content
Dashmir82
Dashmir82
Participating Frequently
March 14, 2019
Answered

fields hidden and calculate

  • March 14, 2019
  • 1 reply
  • 695 views

Hello everybody

I have 2 check boxes and a text box. The first checkbox is "ohne MwSt." and the second checkbox is "mit MwSt."

In the text field is the value of the VAT (3.7%) calculated from the field "Mietzins".

If the checkbox "ohne MwSt." is activated, then the other checkboxes must be hidden. This works, with the following code:

if (this.getField("ohne_mwst").value == "ohne") {
this.getField("summe_mwst").display = display.hidden;
this.getField("mit_mwst").display = display.hidden;
} else {
this.getField("summe_mwst").display = display.visible;
this.getField("mit_mwst").display = display.visible;
}

the second part is:

If you activate the checkbox "mit MwSt. 3.7%" then the amount in the field "Mietzins" has to be added.

In the field "Total Miete pro Monat" the total amount has to be calculated.

Here is an example with "mit MwSt. 3.7%:

Here is an example with "ohne MwSt.:

Can someone help me?

This topic has been closed for replies.
Correct answer try67

If you're using it as a calculation script, then try this instead (it also includes the rounding):

if (this.getField("mwst").value == "ohne") { 
    event.value = "0"; 
} else if (this.getField("mwst").value == "mit") { 
    event.value = roundToNearestFiveCents(Number(this.getField("mietzins").value) * 0.037);
} 
function roundToNearestFiveCents(v) {
    return (Math.round(v * 20) / 20).toFixed(2);
}

As for your second question: If you use radio-buttons instead of check-boxes then once a selection is made it can't be "un-checked" (also changed to something else), unless you reset the form. But if you set the No field as the default value (under Properties, Options), then it will always default to it unless Yes is selected.

1 reply

try67
Community Expert
try67Community Expert
Community Expert
March 14, 2019

You should give both fields the same name but different export values, so they can't be selected at the same time.
If you use the value 0 and 0.037 then you would be able to multiply the first field by the check-box's value to get the tax (?) amount.

Dashmir82
Dashmir82Author
Participating Frequently
March 14, 2019

Hello

sorry the second picture is wrong, here the right picture:

thanks try67 for your input. with this code it works.

if (this.getField("mwst").value == "ohne") {
this.getField("summe_mwst").value = "0";
} else if (this.getField("mwst").value == "mit") {
event.value = this.getField("mietzins").value * 0.037;
}

  • Our currency in Switzerland is in 5 steps. here an example: CHF 0.05, CHF, 0.10 etc. What is the syntax for rounding the value so that I get the right rounded value?
  • If the checkbox "mit MwSt." is not checked, the other checkbox should be activated automatically.
try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
March 14, 2019

If you're using it as a calculation script, then try this instead (it also includes the rounding):

if (this.getField("mwst").value == "ohne") { 
    event.value = "0"; 
} else if (this.getField("mwst").value == "mit") { 
    event.value = roundToNearestFiveCents(Number(this.getField("mietzins").value) * 0.037);
} 
function roundToNearestFiveCents(v) {
    return (Math.round(v * 20) / 20).toFixed(2);
}

As for your second question: If you use radio-buttons instead of check-boxes then once a selection is made it can't be "un-checked" (also changed to something else), unless you reset the form. But if you set the No field as the default value (under Properties, Options), then it will always default to it unless Yes is selected.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices