A mask for input in "Spreadsheet to Form"

  • Cheeseathome
    Asked on March 18, 2018 at 5:40 PM

    I need to create the following mascara (or mask) for the "Spreadsheet to form" widget. The mask is the following ##. ###. ### / #### - ##. This is called CNPJ in Brazil. Every company has its CNPJ. It is what identifies it with the government of Brazil. Can you help me create a CSS code. Maybe give me a code for something else and I'll change to fit it.

  • jonathan
    Replied on March 18, 2018 at 7:00 PM

    If I understand correctly, you actually want to obfuscate the input while typing in the input box...

    Example:

    1521413947zzz 2018 03 19 06 Screenshot 10

    ---

    You can achieve a similar thing using custom injected CSS codes into the widget.


    #access-code{

      -webkit-text-security : disc;

    }

    1521413996zzz 2018 03 19 06 Screenshot 21


    Let us know this did not work.

  • Cheeseathome
    Replied on March 18, 2018 at 7:20 PM
    No. I need to enter the number when entering the following format. 99.999.999 / 9999-99 examples 25.290.782 / 0001-71 66.487.836 / 0001-70
  • jonathan
    Replied on March 18, 2018 at 7:53 PM

    Thank you for the clarification and explanation. Unfortunately masked input for the spreadsheet widget is not possible at this time.

    The most I come up with is to use hint text instead. You can do so using CSS codes like this.

    #id_3::after {

        content: "Format: ##. ###. ### / #### - ##";

    }

    1521417150zzz 2018 03 19 07 Screenshot 10


    alternate: position it below the field label.


    #label_3::after {

        content: "Format: ##. ###. ### / #### - ##";

    }


    Let us know if this will not work.



  • Cheeseathome
    Replied on March 18, 2018 at 8:06 PM
    did not work.
  • liyam
    Replied on March 19, 2018 at 4:33 AM

    Unfortunately, it is not possible to require or restrict the input value for the Spreadsheet to form widget into a specific format.

    What Jonathan did was add a subtext to set a reminder for your users on what format the values should be entered.

    If you have additional questions, please let us know.