Español
English
Forum
Calc Builder Support
Calc Builder supportForums
No se permite escribir sin estar logado. Por favor, login
Add predefined mask in text input 20.02.2014 23:27
Hi,
I need for my project to add a predefined mask in text input.
I had it in js file ; /www/modules/mod_calcbuilder/assets/js/jquery.meio.mask
Line 142 : 'mymask' :{mask:'AA-999-AA-999' }, ...
But there didn't work.
I see which certain mask not appear in the choice like cpf (cadastro nacional...)
Have you a solution for my problème ?
Thank's
I need for my project to add a predefined mask in text input.
I had it in js file ; /www/modules/mod_calcbuilder/assets/js/jquery.meio.mask
Line 142 : 'mymask' :{mask:'AA-999-AA-999' }, ...
But there didn't work.
I see which certain mask not appear in the choice like cpf (cadastro nacional...)
Have you a solution for my problème ?
Thank's
Re: Add predefined mask in text input 21.02.2014 09:54
Hello,
Instead of creating a new mask in js file, did you try to write the mask in the text field on the right of the mask property inside field configuration?
Regards,
Moonsoft Team
www.moonsoft.es
Instead of creating a new mask in js file, did you try to write the mask in the text field on the right of the mask property inside field configuration?
Regards,
Moonsoft Team
www.moonsoft.es
Re: Add predefined mask in text input 16.01.2019 14:14
Hello
I needed to have entered number formatted with input mask like this 999,999,999 (integer us)
And to allow entering numbers only. Input mask option is used for tasks like that.
In order to do so in your system - fields needs to be set as text type,
because when field is set as number, there is no input mask available as option.
Problem: when I change field from from number type into text type, to use input mask,
calculation doesn't work any more.
Any suggestions how to have both input mask and calculation ability?
Thanks,
Regards
I needed to have entered number formatted with input mask like this 999,999,999 (integer us)
And to allow entering numbers only. Input mask option is used for tasks like that.
In order to do so in your system - fields needs to be set as text type,
because when field is set as number, there is no input mask available as option.
Problem: when I change field from from number type into text type, to use input mask,
calculation doesn't work any more.
Any suggestions how to have both input mask and calculation ability?
Thanks,
Regards
Re: Add predefined mask in text input 17.01.2019 09:08
Hello,
yes, if you format the numbers, they are no longer numbers, but plain texts, either for php or the excel cell. In order to make further calculations with such formatted values, you would need to convert them back to numbers, and then launch your operations. If you have your math in php formulas you could just remove all the ' , ' characters and you will get a valid number again. If you use an excel file, you could also replace the commas, and/or use any built in function like VALUE to extract the number from that formatted text. Here we found some tips to get a number from a formatted text using excel formula:
https://www.ablebits.com/office-addins-blog/2018/07/11/excel-value-function/
Hope this helps, regards
Moonsoft Team
www.moonsoft.es
yes, if you format the numbers, they are no longer numbers, but plain texts, either for php or the excel cell. In order to make further calculations with such formatted values, you would need to convert them back to numbers, and then launch your operations. If you have your math in php formulas you could just remove all the ' , ' characters and you will get a valid number again. If you use an excel file, you could also replace the commas, and/or use any built in function like VALUE to extract the number from that formatted text. Here we found some tips to get a number from a formatted text using excel formula:
https://www.ablebits.com/office-addins-blog/2018/07/11/excel-value-function/
Hope this helps, regards
Moonsoft Team
www.moonsoft.es