Spreadsheet to form widget: How to manage accepted characters

how to manage to get an instant notice, when typing a character which is not supported?

I've managed to do this for normal input fields using Conditions Show/Hide Field, but it is not working for this widget. Is the another another possibility to manage this?

Hi TeamFlow,

Thanks for reaching out to us for help. Although that feature isn’t available yet, as a workaround, we can use Short Text element and then pass the value to the Spreadsheet to form widget. Let’s do it:

1. In Form Builder, click on the Add Form Element menu on the left side of the page.
2. Under the Basic tab, select Short Text element. Drag and drop the element to your form.
3. Next, click on the Widgets tab and look for Spreadsheet to Form widget. Drag and drop the widget to your form.
   
4. Select the Short Text element and click on the Gear icon.
5. Under the Options tab, click on the Downward icon under Validation. Select the validation that you want to use.
   
6. Select the Spreadsheet to Form widget and click on the Wand icon.
7. Under the General tab, set the Autofill By Condition to Yes.
   
   

Now, let's set up the conditional logic.

• Click on the Settings tab in the orange navigation bar at the top of Form Builder.
• Select Conditions on the left side of the screen.
• Click +Add a New Condition.
  
• Select Update/Calculate Field and then set the conditions just like you see below:
• Finally, click on Save.
  

Here's a screencast of the form in action:

Reach out again if there’s anything else we can help you with.

Thank you for your support!!!

With your explanation and additional hiding the input box of the widget, i got the perfect solution for me.