Masked Input Widget: Option to use the dot as a thousand separator in calculation

Prezados

Boa tarde

Meu formulário (https://form.jotform.com/232835441998671) possui campos com cálculos entre eles, porem o calculo não esta sendo realizado corretamente, vejam nos prints abaixo

Ao realizar o calculo com 3 dígitos, funciona corretamente, exemplo abaixo

Calculo correto entre os campos "Consumo final" + "Numero" (ultimo campo do formulário).

Calculo incorreto entre os campos "Consumo final" + "Numero" (ultimo campo do formulário).

Vejam que quando temos 4 dígitos e aparece o identificador de milhar como ".", aparentemente o formulário esta entendo se tratar de casas decimais e faz o calculo de "5 + 1"

Testei diversas possibilidades de configurações nas condições de calculo, e também nas configurações do widget e não consegui que o calculo correto seja realiza

Gostaria que me auxiliassem com esta questão sem a retirada do identificador de milhar, e sem que eu tenha que trocar esse campo para um campo normal de numero. (fiz esse teste e ai funciona) pois tenho muitas condições envolvidas

Obrigado

Faltou uma informação, o resultado do calculo é o campo "Consumo inicial"

Certo - 500 + 1 = 501

Errado - 5000 + 1 = 6 ???

Hi Vonex,

Thanks for reaching out to Jotform Support. Unfortunately, our Portuguese Support agents are busy helping other Jotform users at the moment. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Portuguese, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

I’ll need a bit of time to look into this. I’ll get back to you as soon as I can.

Thanks for your patience.

Hi Vonex,

We really appreciate your patience and understanding while we’re looking into this. When I tested your form, the same thing happened. Unfortunately, on the Masked Input widget, you can use a dot as the thousand separator; but the value will not be calculated as thousands. If you want to utilize the widget, you must use a comma as a separator for thousands and a dot for decimals.

While the feature you’re looking for isn’t currently available, rest assured we’re always working to add new services and features to Jotform. I've gone ahead and escalated your request to our Developers. When or if it's implemented depends on their workload, how viable it is, and how many other users request it. If there are any updates, we’ll circle back to this thread and let you know.

Reach out again if you have any other questions.

Angeli

Bom dia

Obrigado pela resposta, porem eu tenho outro formulário (https://form.jotform.com/232895786730673) onde esta situação não ocorre, veja nos prints abaixo

Cenário 1

Cenário 2

inclusive o formulário onde não funciona e uma copia deste, a única diferença é que tirei a mascara de moeda (R$) e as casas decimais, pois agora preciso que a informação seja computada em quantidades e não valores.

Por isso não entendi por que não funciona da mesma forma.

Hi Vonex,

Thanks for getting back to us. I've already escalated this to our Developers. Rest assured that we’ll get back to you with an update as soon as we have one.

In the meantime, a workaround is to pass the value of 'Consumo Final' to a Form Calculation widget and also replace the 'Consumo Inicial' with a Form Calculation widget. I'll walk you through setting that up:

• First, add the Form Calculation widgets. 
• On the first Form Calculation, add the Consumo Final field.

• Next, make sure all the Decimal Places in Numerical Results are set to 0.

• Then set the Number of precision of Consumo Final field to 3.

• Finally, replace the Consumo Final Masked Input widget with the Consumo Final Form Calculation in the calculation condition.
• Do the same for the Consumo Inicial field.

Here's the result:

You can clone my demo form here to test.

Let us know if there’s anything else we can help you with. 

Angeli

Good afternoon

Thank you, I will wait for your response.

As for the suggested alternative, I had already done something similar, and I know that it works, but it does not have the thousands separator formatted as (.), but I will test it further, in the meantime I will wait for the developers to respond.

Thank you very much for your help and attention

Hi Vonex,

Thanks for your patience while we’re looking into this. Although we don’t have a solution yet, rest assured, we’ll keep working on this until it's resolved. We’ll get back to you as soon as we have an update.

In the meantime, let us know if you have any other questions.